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…