Restoring master db to new location: sysnsobjs err

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Restoring master db to new location: sysnsobjs err

Author

Topic

j_70
Starting Member

4 Posts

Posted - 2007-06-15 : 12:19:50

I am attempting to restore a master database backup to a new location
(new_masterdb) and am getting the following error:

System.Data.SqlClient.SqlError: There is already an object named 'sysnsobjs' in the database. (Microsoft.SqlServer.Smo)

There is empty so I am not sure why it is finding this object. How can I get around this?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-06-15 : 12:46:24

You should be using this approach:
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071&Product=sql2k

Tara Kizer
http://weblogs.sqlteam.com/tarad/

j_70
Starting Member

4 Posts

Posted - 2007-06-15 : 13:52:12

I tried the procedure you recommended and receive the same error. It would appear that they object is coming from the backup but being read twice. Any further ideas? Thanks.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-15 : 14:32:09

Restored on same server? How did you do that? What's error number?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-06-15 : 14:48:47

What command are you running when it throws the error?

Tara Kizer
http://weblogs.sqlteam.com/tarad/

j_70
Starting Member

4 Posts

Posted - 2007-06-18 : 08:30:25

The steps I am using to try and restore the database are. I am doing this is SQL Server Mgmt Studio:

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.
5. I receive the following error:

System.Data.SqlClient.SqlError: There is already an object named 'sysnsobjs' in the database. (Microsoft.SqlServer.Smo)

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-18 : 15:45:04

Tried with restore statement? You may need move db files.

j_70
Starting Member

4 Posts

Posted - 2007-06-19 : 06:59:02

I tried moving the data files, the procedure listed in this article, but receive the same error:

http://support.microsoft.com/default.aspx?scid=kb;en-us;224071&Product=sql2k

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources