I have a Windows 2008 R2 Server running SQL2008 (not R2).
I havew been trying to restore a database using the Restore Database Tool in Enterprise Manager. That is Right click the database, select Tasks ->Restore ->Database.
On the General page I have selected my source as a Database Backup and selected the file location. I have selected the only backup set in the file.
On the General Tab I have selected the 'Overwrite the existing Database (with Replace)'
When I click the OK button to action my selections I receive the following Error message:
Restore failed for Server 'WIN2008SQL'. (Microsoft.SqlServer.SmoExtended)
System.Data.SqlClient.SqlError: File 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\MAESTRODB.ndf' is claimed by 'MAESTRO_INDEX_DATFILE'(4) and 'MAESTRO_DATFILE'(3). The WITH MOVE clause can be used to relocate one or more files. (Microsoft.SqlServer.Smo)
I have not been able t ofind a solution to this...
View Complete Post