Dear all,
Iam trying to restore Sql 2000 backup in sql 2008 server db.
It shows me foll error:
"There is already an object named sysnsobjs in the database"
any Solution?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pravin GhadgePosted Feb 7, 2012, 10:53 PM
Iam foll the same steps.
Jignesh TrivediPosted Feb 7, 2012, 10:39 PM
Are u follow the following step?
1. I create a new, empty database.
2. I right click on the database, select tasks | restore | database
3. The database is in a *.bak file so I choose to restore from file and select this file.
4. I choose to restore all the backup sets and under options, choose to overwrite the existing database.
or are u run any script for restore datata base?