none
Restore backup from 2000 server to 2005 server get message a severe error occurred. Do not get the error when restoring back to 2000

    Question

  • 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.


    Monday, October 28, 2013 10:26 PM

Answers

  • Msg 0, Level 11, State 0, Line 0
    A severe error occurred on the current command.  The results, if any, should be discarded.



    Hi,

    Your database is restored properly. The above message is not related to database restore. Make sure you are running with latest service pack SP4 for SQL 2005.


    Thanks & Regards RAJUKIRAN L Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers.

    Wednesday, October 30, 2013 11:59 AM

All replies

  • Hello,

    There are many different issues that could be the root cause. First, check the errorlog and post any errors associated with it. Normal causes of these failures include direct updates to system catalogs, imported data that is outside of the data type domain, and actual corruption.

    Please run a full DBCC CHECKDB() on the 2000 database and let us know what the output is.

    -Sean


    Sean Gallardy | Blog | Twitter

    Monday, October 28, 2013 10:52 PM
  • Msg 0, Level 11, State 0, Line 0
    A severe error occurred on the current command.  The results, if any, should be discarded.



    Hi,

    Your database is restored properly. The above message is not related to database restore. Make sure you are running with latest service pack SP4 for SQL 2005.


    Thanks & Regards RAJUKIRAN L Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers.

    Wednesday, October 30, 2013 11:59 AM