What does SQL Server do if you select more than 1 full backup when doing a restore?
- by Rob Sobers
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.