SQL 2000 to SQL 2008 backup restore

[Reworking]

I am getting this error:
There is already an object named 'sysnsobjs' in the database.
Any ideas?

[Erland Sommarskog]

Reworking (Rewo...@discussions.microsoft.com) writes:
> I am getting this error:
> There is already an object named 'sysnsobjs' in the database.

So you have a backup from SQL 2000 which you try to restore in SQL 2008?

sysnsobjs is a new system table in 2008, and like all other system tables
not visible to users. (The old system tables are now compatibility views.)

I can think of two possibilities:
1) The database upgrade loses track, and tries to create the table twice.
2) There was already a table (or some other object) sysnsobjs in the
database.

You could at least investigate the second possibility by running

SELECT * FROM sysobjects WHERE name = 'sysnsobjs'

in the original database. (Or restore the backup on SQL 2000.) But even
this is the case, there should not be any error, since the system tables
lives in the sys schema.

If that does not reveal anything, and you need the backup restored, I
think it's time to open a case with Microsoft.

I Googled on the error message and got a few hits, but I found no
resolution. Interesting enough, in most cases it is the master database
people are trying to copy.

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx