Post reply

restoring master database on seperate server

  • August 22, 2008 at 1:00 pm

    #123188

    hi !

    I am trying to restore the master database from enterprise edition to standard edition, I am getting this error below :

    "The backup of the system database on device c:\.... cannot be restored because it was created by a different version of the server (134219778) than this server (134219767) "

    The source database version is "

    Microsoft SQL Server 2000 - 8.00.2050 (Intel X86) Mar 7 2008 21:29:56 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4) "

    The target database version is "

    Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2) "

    why is the target database showing SP2 where as I have applied sp4 to this database and if I check from enterprise manager the database version is shown as SP4.

    I didnt get any errors during the patch application also so its very confusing .

  • August 22, 2008 at 1:51 pm

    #862100

    ok i got the version and levels separately from the source and target databases and its below :

    SELECT SERVERPROPERTY('ProductLevel') level , SERVERPROPERTY('ProductVersion') version

    LEVEL VERSION

    SP48.00.2039 <<<<<<<< target

    SP4 8.00.2050 <<<<<<<< source

    is this version difference which is not letting me restore the master database ? Isnt this version

    difference coming from being standard or enterprise edition ? and if yes I thought I could restore a

    system database from enterprise edition to standard .. or can I not ?

  • August 25, 2008 at 11:15 am

    #862678

    Go thru this link once which says "You cannot restore system database backups to a different build of SQL Server":-

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

    HTH

    MJ

  • August 25, 2008 at 12:48 pm

    #862724

    I don't believe that you can change versions.

  • August 25, 2008 at 2:09 pm

    #862778

    I succeeded in restoring the databases from enterprise backup onto a standard edition.

    The problem was a missing hotfix 2050 and once i applied it to the standard database I could restore the system databases.

    thanks for all your help

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

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