October 24, 2007 at 3:31 pm
I am upgrading a DB from SQL 2000 to SQL 2005. I trying to restore the backup file from SQL 2000 to 2005. Here is the script I have.
RESTORE DATABASE [xDBx] FROM DISK = N'C:\BU\xDBx2000.BAK' WITH FILE = 1, MOVE N'xDBxdata' TO N'C:\Data\xDBxData.mdf', MOVE N'xDBxlog' TO N'C:\Data\xDBxlog.ldf', NOUNLOAD, REPLACE, STATS = 10
and this the error msg I get
10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.
80 percent processed.
90 percent processed.
100 percent processed.
Processed 513776 pages for database 'xDBx', file 'xDBxdata' on file 1.
Processed 3 pages for database 'xDBx', file 'xDBxlog' on file 1.
Converting database 'xDBx' from version 539 to the current version 611.
Database 'xDBx' running the upgrade step from version 539 to version 551.
Warning: User "sys" (principal_id = 266) in database "xDBx" has been renamed to "_ID_0x0000010A_RENAMED_FROM_sys". "sys" is a reserved user or schema name in this version of SQL Server.
Warning: Database "xDBx" was marked suspect because of actions taken during upgrade. See errorlog or eventlog for more information. Use ALTER DATABASE to bring the database online. The database will come online in restricted_user state.
Database 'xDBx' running the upgrade step from version 551 to version 552.
Database 'xDBx' running the upgrade step from version 552 to version 553.
Database 'xDBx' running the upgrade step from version 553 to version 554.
Database 'xDBx' running the upgrade step from version 554 to version 589.
Database 'xDBx' running the upgrade step from version 589 to version 590.
Database 'xDBx' running the upgrade step from version 590 to version 593.
Database 'xDBx' running the upgrade step from version 593 to version 597.
Database 'xDBx' running the upgrade step from version 597 to version 604.
Database 'xDBx' running the upgrade step from version 604 to version 605.
Database 'xDBx' running the upgrade step from version 605 to version 606.
Database 'xDBx' running the upgrade step from version 606 to version 607.
Database 'xDBx' running the upgrade step from version 607 to version 608.
Database 'xDBx' running the upgrade step from version 608 to version 609.
Database 'xDBx' running the upgrade step from version 609 to version 610.
Database 'xDBx' running the upgrade step from version 610 to version 611.
Msg 3167, Level 16, State 3, Line 1
RESTORE could not start database 'xDBx'.
Msg 3167, Level 16, State 1, Line 1
RESTORE could not start database 'xDBx'.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Can you help me please.
Thanks
October 25, 2007 at 12:52 am
It appears you have a user in the db named sys. Sys is reserved in 2005, it's the system schema.
Try changing the user name to something else in SQL 2000, take a fresh backup and restore that. See if that works.
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
October 26, 2007 at 12:05 am
Refer the below link from Microsoft.
http://support.microsoft.com/kb/290787
And also check whether the backup you are having is a valid backup with RESTORE VERIFYONLY command.
Regards..Vidhya Sagar
SQL-Articles
October 26, 2007 at 12:47 am
In sql 2005, through the restore database wizard its quite simple to move the earlier version of a database. Provided you need to take the ldf & mdf files offline from the earlier version and copy & paste the same to the respective directory.
See Help on restoration of the databases through msdn/technet.com for more....
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply