Friday, May 15, 2009

Restore Data from sql server 2000 to Sql server 2005 Management studio express

While restoring data from sql server 2000 to sql server 2005 Management Studio express

1. Created new database named test on sql server 2005 Management studio express
2. Restore database from sql server 2000 by selecting backup file

Then I selected and clicked ok. Then I got error

System.data.sqlclient.sqlerror: the backup set holds a backup of database other than the existing database (Microsoft.Sqlserver.express.smo)

Workaround is "restoring the database with options 'overwrite existing database'"


Now db gets restored.

No comments: