Results 1 to 9 of 9
  1. #1
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Unanswered: An internal consistency error occurred

    I think I'm hosed...anyone ever seen this before?

    Server: Msg 3270, Level 16, State 1, Line 1
    An internal consistency error occurred. Contact Technical Support for assistance.
    Server: Msg 3013, Level 16, State 1, Line 1
    RESTORE DATABASE is terminating abnormally.
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    i bet Technical Support has seen it, otherwise they wouldn't be telling you to contact them

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jul 2007
    Posts
    96
    Last time I heard of that it was a problem with the connection that was corrupting the .bak file for a reason that I can't remember. However, that error can occur for many other reasons.

    Do you get any errors when you do a DBCC CHECKDB?

    i bet Technical Support has seen it, otherwise they wouldn't be telling you to contact them

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Our "Technical Support" team said the D drive took a hit...whatever that means, and my guess is that they restored it....half of my db's are suspect now

    I was able to restore 1 database, then I started to restore another and got that error

    I'm taking a backup to another box now to see if it'ss restore there

    I'm thinking I'll have to rebuild the whole box
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Quote Originally Posted by Brett Kaiser
    Server: Msg 3270, Level 16, State 1, Line 1
    An internal consistency error occurred. Contact Technical Support for assistance.
    Server: Msg 3013, Level 16, State 1, Line 1
    RESTORE DATABASE is terminating abnormally.
    I've seen that before ... the backup was corrupted and I had to fall back to a previous day and use tran logs to get current - IMHO you are hosed on that backup file.

    -- This is all just a Figment of my Imagination --

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Well I'm copying the backups to another server and I've got 5 per database

    I hope the backups aren't corrupt

    See...the importance of testing the backups is not lost on me now....I still think it's SQL Server itself that's corrupted

    Somone mentioned something about the Reg keys
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  7. #7
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by Brett Kaiser
    Somone mentioned something about the Reg keys
    Was it me?

  8. #8
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by pootle flump
    Was it me?

    No

    Nice new title
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  9. #9
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Backup was corrupted

    When I tried to restore it on another box, I got the same thing

    Damn, now I gotta try'em all until I find a good one
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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