Error when restoring: There is already an object named sysnsobjs in the database

Question

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?

Pravin Ghadge · Answer

hi Jignesh Iam foll the same steps.

Jignesh Trivedi · Answer

hi 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?