Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2007
    Posts
    6

    Unanswered: An internal consistency error occured sqlstate:42000

    Hi all,

    I am getting error message 'An internal consistency error occured sqlstate:42000" when i am trying to restore the database.

    Regards,
    Shashi.

  2. #2
    Join Date
    Oct 2009
    Posts
    1
    i am also getting the same error any one there to help us out..

  3. #3
    Join Date
    Aug 2009
    Posts
    262
    Check thes message in the SQL Log.
    "The backup data in 'C:\GAYE_Data\DLR_DIF.bak' is incorrectly formatted".

    Some thing like that ..

    Backups cannot be appended, but existing backup sets may still be usable.

    It transpired that the file was incomplete it was copied and showed correct written size but wasn't.

    Recreate the backup and it works

    or

    Another alternative solution is listed at the Microsoft website, but it isnt a great solution! (id on knowledge base is 268481)

  4. #4
    Join Date
    Aug 2009
    Posts
    262
    what does 'RESTORE VERIFY ONLY' command shows ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •