Restoring Files from a Disk Device
Hi,
I have a question about an apparently annoying feature of EM.
Let's say I run the following script:
sp_addumpdevice 'disk', 'full_backup', 'c:\tmp\fullbackup.dat'
go
backup database test_db to full_backup
go
backup database test_db to full_backup
go
backup database test_db to full_backup
go
I get a single .dat file with three backup sets on it, position 1-3, which I can see by running:
restore headeronly from full_backup
So far so good. Now I run a fourth backup using 'with init':
backup database test_db to full_backup with init
This overwrites the .dat file, leaving me with one backup set at position 1, as I can see by running 'restore headeronly'.
This all makes sense. 'Restore headeronly' gives me accurate info about what backup sets actually exist on the backup device.
Not so with EM. If I right click on test_db and select Restore Database from the All Tasks menu, EM lists four backup sets, one for each of the backups I performed above. Problem is the earliest backup displayed in EM is now inaccurate because it was over written by the fourth backup(both wrote to file position 1), and the second and third backups listed in EM are invalid because files positions 2 and 3 no longer exist on the disk backup device. Only backup set four displayed in EM is a good backup.
So my questions are:
1. Is there anyway to get EM to accurately display the contents of the disk device, listing only valid available backups?
2. I assume 'restore headeronly' is reading the the contents of the disk device directly. Where is EM getting it's available backup info from, msdb?
3. Why does EM want to display a backup history instead of valid, available backups?
Any insights appreciated.
Bob
|
