Restoring Database Fails

A vendor has sent me several databases and all of them restore fine except for one. I get a message that the MDF file is claimed by secondary and primary. That the MOVE CLAUSE can be used to move one or more files. Has anyone come across this issue before?

asked Jun 28 '11 at 09:12 PM in Default

sqlnubi
845 ● 4 ● 5 ● 6

Are you using the SSMS GUI to do the restore?

Jun 28 '11 at 09:13 PM Tim

Yes I am, SSMS 2008.

Jun 28 '11 at 09:13 PM sqlnubi

(comments are locked)

1 answer:

Once you have chosen the file to restore, named the database and checked the box to restore, you need to click on options in the top left. From here you can expand out the path to the physical files. You will see that you have multiple data files. The error message above eludes to that as well. When you expand the path out you should see that both the primary and secondary files defaulted to the same name. You can change the name of either one and then successfully restore the database.

answered Jun 28 '11 at 09:15 PM