Restore backup from 2000 to 2005 get message a severe error occurred.. only on one server

[bmacbmac]

Hello,

Server A = SQL 2008

Server B = SQL2000 instance AND an SQL 2005 instance

I am trying to run a daily script (using studio manager on Server A) that backups up a database in 2000 (server B) and restores the database to 2005 (server B).

On Server A, I launch studio manager and log into the 2000 server SQL. Then run the following script:

--Backup 2000 DB
backup database MYDB to disk = \\SERVERB\Sharename\MyDB.BAk'  with init

go

--Restore DB on 2005 server
EXEC [SERVERB\mssql2005].[master].[dbo].[sp_executesql] N'restore database MYDB
from disk = ''\\SERVERB\Sharename\MyDB.bak''
with replace'

Then I get this message:

Processed 472 pages for database 'MYDB', file 'MYDB_Data' on file 1.
Processed 1 pages for database 'MYDB', file 'MYDB_Log' on file 1.
RESTORE DATABASE successfully processed 473 pages in 0.205 seconds (18.866 MB/sec).
Database 'MYDB' running the upgrade step from version 610 to version 611.
Database 'MYDB' running the upgrade step from version 609 to version 610.
Database 'MYDB' running the upgrade step from version 608 to version 609.
Database 'MYDB' running the upgrade step from version 607 to version 608.
Database 'MYDB' running the upgrade step from version 606 to version 607.
Database 'MYDB' running the upgrade step from version 605 to version 606.
Database 'MYDB' running the upgrade step from version 604 to version 605.
Database 'MYDB' running the upgrade step from version 597 to version 604.
Database 'MYDB' running the upgrade step from version 593 to version 597.
Database 'MYDB' running the upgrade step from version 590 to version 593.
Database 'MYDB' running the upgrade step from version 589 to version 590.
Database 'MYDB' running the upgrade step from version 554 to version 589.
Database 'MYDB' running the upgrade step from version 553 to version 554.
Database 'MYDB' running the upgrade step from version 552 to version 553.
Database 'MYDB' running the upgrade step from version 551 to version 552.
Database 'MYDB' running the upgrade step from version 539 to version 551.
Converting database 'MYDB' from version 539 to the current version 611.
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.

The database on the 2005 server appears fine.

I should note that I can go to SERVER B and log into SQL 2000 with query analyzer. I run:

EXEC [dellsql\mssql2005].[master].[dbo].[sp_executesql] N'restore database kootbatch3c
from disk = ''\\dellsql\docdata\kootenaipioneer\kootbatch3b\backupkootbatch3b''
with replace'

And it says the procedure was successful. I don't receive any error messages.

 

[gmmastros]

I don't know if this is related, but I saw this:

http://support.microsoft.com/kb/910416

Can you make sure your SQL2005 database engine is up to date with service packs?


-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom