Running 2005, I have backups with multiple datasets on them.
But when I open the restore backup windows, it only shows me the last set.
How do I see the all the sets so I can choose which set to restore?
Thanks,
Tom
TheSQLGuru - 30 Apr 2008 23:13 GMT
I don't understand the statement "backups with multiple datasets on them".
Do you mean you have made multiple backups to the same file? If so, did you
make sure you didn't INIT the file each time?

Signature
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
> Running 2005, I have backups with multiple datasets on them.
>
[quoted text clipped - 5 lines]
>
> Tom