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.
Subscribe to:
Post Comments (Atom)

No comments:
Post a Comment