Unable to restore from backup

  • My network admin fried the box SQL server was on. A new box was built, but now when I try to restore the databases I get the following error

    Has anybody encountered this?

  • Can you cut and paste the text of the message?  All I see is a red x.

    Steve

  • The error message reads:

    The backup of system database on device C:\Backups\ivr_db_20040831003.bak can not be restored because it was created by a different version of the server(13218488) than this server (134217922) RESTORE DATABASE is terminating abnormally.

    I also get this message with some other backups. Some did restore though, which is REALLY weird.

     

     

  • Microsoft have a support article on this:

    PRB: System Database Backups Cannot be Restored on a Different Build of SQL Server

    http://support.microsoft.com/default.aspx?kbid=264474

     


    Julian Kuiters
    juliankuiters.id.au

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

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