Friday, March 9, 2012

Restoring from Multiple data sets

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,
TomI 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?
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"tshad" <tshad@.dslextreme.com> wrote in message
news:upzCs2uqIHA.3616@.TK2MSFTNGP06.phx.gbl...
> 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
>

No comments:

Post a Comment