Post reply

Internal consistency error occured.

  • August 29, 2007 at 8:55 pm

    #176365

    I'm getting "Internal consistency error occured. Contact Technical Support for assistance. RESTORE DATABASE is terminating abnormally." when doing a database restore.

     

    My question is, can we do a backup on MSSQL2K with SP4 and restore on MSSQL2K without SP?

     

     

    ---

    sw.yin

  • August 29, 2007 at 9:54 pm

    #730308

    You cannot. You can only restore a database to an SQL Server with later service pack.

  • August 30, 2007 at 2:15 am

    #730350

    Sorry, but that's nonsens. You can restore a backup of a SQL 2000 database on any SQL 2000 server, no matter what service pack. If it's a system database you should be very careful doing this, but it is possible.

    Anyhow, if the previous restore failed with a internal consistency error I doubt that it will restoe succesfully on any other server. Try RESTORE VERIFYONLY first, to check if the backup file is ok.

    Markus

    [font="Verdana"]Markus Bohse[/font]

  • August 30, 2007 at 1:44 pm

    #730580

    Thanks for the feedback. I will try that.

  • September 4, 2007 at 2:14 pm

    #731321

    MarkusB:

    This is a discussion forum. I wish you would not write in that way. We came across this problems before. Here is a link for your reference. Please check.

    "You cannot restore system database backups to a different build of SQL Server."

    http://support.microsoft.com/kb/264474

    Although a system database restore may work occasionally, the restore is not guaranteed. When I wrote "you cannot", this is what I really mean.

  • September 5, 2007 at 1:12 am

    #731406

    SQLORACLE

    sorry if I offended you but I'd like to make two comments.

    First of all your article only talks about system databases, while the original post never mentioned these.

    Second I've seen it done in the past, that's why I'm so sure. I once spent a whole day at a customer trying to figutre out what was wrong with a server and it turned out they had restored the master database from a SP2 machine into a SP3 server.

    Maybe on SQL 2005 this is no longer possible but on 2000 you definetely could.

    Markus

    [font="Verdana"]Markus Bohse[/font]

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

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