Post reply

ERROR RESTORE SQL 2000 ENT.EDI DB TO SQL 2008 ENT

  • September 5, 2010 at 2:08 pm

    #227349

    Hi,

    I try to restore sql 2000 database in sql 2008 database server and I am getting following error message in the restoration process.

    100 percent processed.

    Processed 5935600 pages for database 'xxxx', file 'xxxx_Data' on file 1.

    Processed 369 pages for database 'ohmis', file 'xxxx_Log' on file 1.

    Msg 3167, Level 16, State 4, Line 1

    RESTORE could not start database 'ohmis'.

    Msg 3013, Level 16, State 1, Line 1

    RESTORE DATABASE is terminating abnormally.

    Msg 3414, Level 21, State 1, Line 1

    An error occurred during recovery, preventing the database 'xxxx' (database ID 6) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.

    Please suggest, how i can solve this issues?

    Is any option to get more details of this error?

    Thanks in advance

  • September 5, 2010 at 4:12 pm

    #1216716

    Anything more in the SQL error log?

    From the looks of the error, either the backup is damaged or the original database is corrupt.

    Can you get another backup to try?

    Can you run the following on the SQL 2000 DB?

    DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 5, 2010 at 4:35 pm

    #1216724

    What do you get back from running restore verifyonly on the backup that you are trying to use?

    Joie Andrew
    "Since 1982"

  • September 5, 2010 at 4:45 pm

    #1216726

    Joie Andrew (9/5/2010)

    What do you get back from running restore verifyonly on the backup that you are trying to use?

    Worth noting that without checksum backups (2005+), restore verify only checks the backup header and a couple other things. It does not check the integrity of the entire backup.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply