RE: Restore using the GUI – SQLServerCentral

SSC Guru

Points: 1003894

August 2, 2015 at 11:49 am

Welsh Corgi (8/1/2015)
I read in Brad McGehee’s Backup and recovery book that when you perform a restore you only need to provide the Full, Differential and the last transaction log backup.

Not correct. You need to restore the last Full, Differential, and ALL transaction log backups that occurred (lsn-wise) after the Differential.

The SQL Server Restore GUI is pretty good at figuring all that out.

As a bit of a sidebar, I've found that Dif files grow to sizes larger (sometimes, MUCH larger) than a Full backup of the database that run a lot of batch imports and so I simply avoid them. Remember that Dif backups are CUMULATIVE OF ALL CHANGES until the next successful FULL backup occurs.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)