Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 BACKUP/RESTORE QUESTION

Author  Topic 

macsterling
Yak Posting Veteran

56 Posts

Posted - 2009-01-23 : 21:46:19
I backed up a database to a device (file), then did some work on it, and backed it up again to a different name (so I could restore to either point.)

When I go to restore it to the second view, it says I have 2 media families and I have to provide both.

I can only find where it wants the name of the file to restore from. What does it want and where do I go to get it?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-24 : 00:47:38
The error is misleading. If you are restoring using the GUI, then make sure to go to the options page and specific overwrite. If you are restoring using the RESTORE command, then make sure to add WITH REPLACE.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -