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
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