Restoring database from MS SQL 2000 to SQL Express 2005

• Question

• 

  

  0

  Sign in to vote

   

  Hello,

  I tried to restore a database which I backuped from MS SQL 2000 to SQL Express 2005 but it always failed with the following error message. What could be the problem?

  Restore failed for Server 'SERV\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)

  Additional information

  System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'gtp' database.

  (Microsoft.SqlServer.Express.Smo)

  Thanks

  Sunday, April 29, 2007 3:13 PM