Same. One per file stamped with the datetime in the name

Because we assume that people know the basic terminology or, if they don't, will go and look...

There's no 'general' solution to backing up a 2 TB database.

General: Backup often enough that you will be able to restore to meet your...

Nothing.

A LUN is a SAN concept, not a database concept.

Please note: 3 year old thread (and what I was in this thread was incorrectly accused of being wrong. I've been wrong elsewhere, but not here)

Not enough information....

raotor (11/28/2012)

---

My full backups are done to the same file (i use NOINIT option on BACKUP), so the same physical backup file contains both full backups as far as I...

One thing that's important to note is that the query processor is a pipeline. It does not execute each operator one by one on the entire resultset, so, in the...

The problem is that you're using the GUI. Don't.

Script your restores (there are scripts that will create the restore statements for you from MSDB). There's no broken log chain here,...

raotor (11/28/2012)

---

Today I performed a second full database backup after thinking I wouldn't destroy the chain and now I cannot restore the database to a point in time before the...

Brandie Tarvin (11/28/2012)

---

Data read by the query processor goes somewhere. When in SSMS, it's outputting to the screen or the file, so it makes sense to me that these pages...

Please note: year old thread.

Anyone with more patience than me want to try and handle this?

http://www.sqlservercentral.com/Forums/Topic1389777-1550-1.aspx

Previous threads on the subject:

http://www.sqlservercentral.com/Forums/Topic1382850-1550-1.aspx

http://www.sqlservercentral.com/Forums/Topic1368391-1550-1.aspx

http://www.sqlservercentral.com/Forums/Topic1364097-1550-1.aspx

They haven't.

The cost has...

SQLSACT (11/28/2012)

---

Thank You Gail

Please bear with me

On one of my posts regarding this,...