Master Database

  • Hi..

    restore database master from disk = 'M:\sudhakar\backup\master070110.bak' with move 'master' to 'E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf' ,

    move 'mastlog' to 'E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.ldf' , replace

    I am trying to restore the master database in the sql server 2005 standard edition , systems giving the error message.

    Msg 3179, Level 16, State 1, Line 1

    The system database cannot be moved by RESTORE.

    Msg 3013, Level 16, State 1, Line 1

    RESTORE DATABASE is terminating abnormally.

    Pls help to resolve this issue. thanks in advance.

  • why are you trying to move its files, that should be done via the startup parameters.

    restore the master database with the replace option so it restores the files to their current location. Then use this procedure to move its files:

    http://msdn.microsoft.com/en-us/library/ms345408(SQL.90).aspx

    you MUST move mssqlsystemresource to the same location at the same time.

    ---------------------------------------------------------------------

  • Note sure if this is the same link but may also help you:

    http://msdn.microsoft.com/en-us/library/ms345408.aspx

    Gethyn Elliswww.gethynellis.com

  • Thanks for your reply....

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

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