Post reply

Unable to Restore Master Database SQL 2005 x64

  • October 15, 2008 at 9:17 am

    #192235

    Hello,

    I am having problems restoring the master database on another server during an in house dr exercise and recieve the following message:

    Msg 3154, Level 16, State 4, Server SVR09, Line 1

    The backup set holds a backup of a database other than the existing 'master' dat

    abase.

    I can confirm the server in question is configured with the same build of SQL Server i.e. 9.00.3054.00. The backup set does contain a backup of the master database and not another database.

    Also the following software build details in the header of the backup set are exactly the same as the build of the other server, ie:

    Software Version Major - 9

    SoftwareVersionMinor - 0

    SoftwareVersionBuild - 3054

    Could anyone help, we are running SQL Server 2005 x64 Enterprise Edition in both cases ?

    Many Thanks


    Mstuart

  • October 15, 2008 at 10:13 am

    #885339

    Is it a disk backup or a tape that you are restoring from?

    The_SQL_DBA
    MCTS

    "Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

  • October 15, 2008 at 11:22 am

    #885371

    DId you try

    RESTORE HEADERONLY FROM backupDevice

  • October 15, 2008 at 11:48 am

    #885390

    I think you need to use the 'WITH REPLACE' argument of RESTORE DATABASE. Here's a thread that discusses the same subject: http://www.sqlservercentral.com/Forums/Topic490956-357-1.aspx

    Greg

  • October 15, 2008 at 12:59 pm

    #885429

    Thanks for your help, its a disk backup I am restoring from. I can confirm the ldf and mdf files are in the original locations as on the other server.

  • October 15, 2008 at 1:08 pm

    #885432

    Two things. One, have you looked up master database in BOL? It talks about restoring the master database. Two, when you started SQL Server to restore the master database, did you bring it up in single user mode?

    😎

  • October 15, 2008 at 1:26 pm

    #885441

    Hi Lynn,

    I am familiar with the procedure in 2000 and have read on 2005, SQL is running in single user mode unfortunately. Whats more confusing is I have been able to simulate a master database restore following this issue by backing up the master database on the server and then restoring in single user mode.

    Any help would be appreciated ?

  • October 15, 2008 at 1:31 pm

    #885445

    What is the result of running the following from an earlier post?

    RESTORE HEADERONLY FROM backupDevice -- replace backupDevice with the filename of the backup diskfile.

Viewing 8 posts - 1 through 7 (of 7 total)

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