Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a backup file that contains 2 backup sets. Both backup sets are full backups. When I open SQL Server Management Studio and choose "Restore..." and pick the file as my device, it lets me pick both backup sets.

The restore operation completes without error, but I'm not sure exactly what SQL server did. Did it restore the first one, drop the database, and then restore the second one? Will it always let the most recent full backup prevail?

It doesn't seem to make sense for SQL server to even allow you to select more than one full backup.

share|improve this question

1 Answer 1

up vote 1 down vote accepted

On the Restore database dialog, there is a setting: To a point in time: and the default is Most recent possible. So your restore operation should be restoring only the most recent backup. Here is some more information from MSDN on this.

Since a full backup includes the Transaction log, it could make sense to include two full backups. The first one could be used for the initial restore and then only the transaction log from the second full backup could be used to update the incremental changes from there.
Another reason could be if the transaction log was truncated after the first backup was performed and your .MDF file was corrupted in the meantime. At that point you might want the MDF from the first full and only the transaction log from the second full.

share|improve this answer
    
Hmmm... does it even let you pick transaction log only when doing a restore from a full backup? Seems odd. –  Rob Sobers May 27 '10 at 20:58
    
No, it doesn't. You pick the date/time you want and it picks the best backup(s) to use... –  Scott Lundberg May 27 '10 at 21:11

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.