Post reply

Error while restoring database in SQLServer 2000

  • September 21, 2007 at 6:39 am

    #374561

    I am getting an error that says MS SQL-DMO (ODBC SQL State: 42000) - An internal consistency error occured. Restore db is terminated abnormally.

    I have even try deleteing the database, re-creating it and restoring again but still the same issue.

  • September 21, 2007 at 7:15 am

    #735216

    Sounds like you have a corrupted backup. Do you have another sql instance you can test the restore on?

  • September 21, 2007 at 7:27 am

    #735223

    Not really. I just thiught it might be something am doing wrong. Will try historic other backup if available

  • October 1, 2007 at 9:25 pm

    #737986

    Please let us know if this is the case. Might help others or we can give you other suggestions. I think it's probably corrupt, but you never know.

  • October 8, 2007 at 3:26 am

    #739926

    yes, the file was corrupted even though that same file was used in the past for restoring data.

    I ran another backup from out live server and was able to restore that data on the test server.

    Thanks for you help/suggestion.

  • October 8, 2007 at 6:26 am

    #739961

    You can use RESTORE HEADERONLY and also RESTORE VERIFYONLY which

    Verifies the backup.If the backup set is complete and that all volumes are readable.

    Please check the BOL for more information.

    Minaz

    "More Green More Oxygen !! Plant a tree today"

  • October 9, 2007 at 10:16 pm

    #740623

    Yes, first use RESTORE HEADERONLY to ensure that the backup returning header information of the backup file. If needed use RESTORE VERIFYONLY, because it may take more time to verify the complete backup sets and all volumes are readable and the duration will depend on your database size.

    Thanks
    Jay
    http://www.sqldbops.com

Viewing 7 posts - 1 through 6 (of 6 total)

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