Restore SQL failed

drink · October 4th, 2005, 04:14 PM

TITLE: Microsoft SQL Server Management Studio
------------------------------

Restore failed for Server 'SAG'. (Microsoft.SqlServer.Smo)

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'thePhile' database. (Microsoft.SqlServer.Smo)

Would you tell me what is wrong?

drink · October 5th, 2005, 04:37 AM

I used the thephile's backup(2003-1).I created a new sql2000 database,and restore,then error message appeared.

rellsbu · October 23rd, 2005, 11:00 PM

I ran into this. When you restore, I needed to select "Force".