November 12, 2008 at 12:53 pm
So I have read multiple ways in restoration of a 2000 db in 2008.
Any ideas????
The main way I am trying is as followed:
Create new DB in 2008 set option to sql 2000 compatibility.
I then go to restore select from device and find the 2000 DB
I check the restore box and select ok.
Receive error
TITLE: Microsoft SQL Server Management Studio
------------------------------
Restore failed for Server 'CAMATO\CAMATO'. (Microsoft.SqlServer.SmoExtended)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: There is already an object named 'sysnsobjs' in the database. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
November 12, 2008 at 1:02 pm
As you are using Management Studio, correct, you need to go to the options tab and select overwrite existing. You may also need to change the destination location for the mdf/ldf files using the elipses (...) button on the same tab.
November 12, 2008 at 1:44 pm
Looks like a conversion problem. If I'm interpreting the error correctly, it's saying that it can't create one of the new system tables because an object with that name already exists.
What does the following return on the SQL 2000 DB
SELECT name, xtype from sysobjects where name = 'sysnsobjs'
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 12, 2008 at 1:51 pm
Yes I am using the SQL Server Management I tried checking Overwrite and using a different location. The error is still happening. The only difference that I see when restoring and under the options tab. The orginal file name for my 2000DB is named Master. Is there a way to change the original file name. I think that the database we created in 2000 is the actual problem?
November 12, 2008 at 1:56 pm
Are you trying to restore the master database from a SQL Server 2000 installation?
November 12, 2008 at 2:03 pm
with SSMS, you can script the restore statement it will use. (use the script button after you've filled out everything you need.)
Can you script it to a new query window and post that script ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
November 12, 2008 at 2:09 pm
No it is a database that was created in 2000 Management.
November 12, 2008 at 2:09 pm
Going to try SSMS Script but not sure exactly how to using the query
November 12, 2008 at 2:10 pm
What does the query I posted return when run against the original SQL 2000 database?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 12, 2008 at 2:13 pm
The script you wanted me to run that in the 2000 or 2008? I ran that script in 2008 under the master and it returned
sysnsobjsS
November 12, 2008 at 2:17 pm
Run it on the SQL 2000 server in the database that you are trying to upgrade.
The query will always return a result on SQL 2008, as that's one of the system tables. It's not a system table on 2000 though and shouldn't exist there.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 18, 2008 at 6:45 am
GilaMonster (11/12/2008)
What does the query I posted return when run against the original SQL 2000 database?
I ran this line in my SQL2000 under my DB, the Master DB and it returned nothing.
I also ran this line in SQL2005 to a blank 20005DB, Master and this came up
name xtype
sysnsobjsS
November 18, 2008 at 8:48 am
Still receiving this error message.
Things I have done: Renamed the original file name, changed location, performed a DBCC No error were found,
SELECT name, xtype from sysobjects where name = 'sysnsobjs'
this returned nothing in SQL SERVER 2000 and in 2005 returned
namextype
sysnsobjsS
HELP I am lost
November 18, 2008 at 6:52 pm
How about
SELECT * FROM sysusers where name = 'sys'
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 19, 2008 at 12:56 am
Is your SQL2000 db comming from a sql2000 version that is supported for upgrade (i.e. >= SQL2000 SP4) ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply