SQL Server Performance

Steps to Restore Master Database from a backup in clustered SQL Server 2005

Discussion in 'SQL Server 2005 Clustering' started by gpreddy, Nov 24, 2008.

  1. gpreddy New Member

    Hi,
    Could you please provide me the steps to follow to restore the master database from an existing backup in Clustered SQL Server 2005?
    Thanks in advance
    gpreddy, Nov 24, 2008
    #2

  2. ghemant Moderator

    ghemant, Nov 25, 2008
    #3

  3. gpreddy New Member

    Thank you
    The link you given is for sql server 2000. Could you plz explain me the steps to restore master database in clustered SQL Server 2005 EE x64 on Windows 2003 R2 EE x64
    gpreddy, Nov 25, 2008
    #4

  4. ghemant Moderator

    I believe this will remain same for SQL Server 2005
    ghemant, Nov 26, 2008
    #5

  5. satya Moderator

    I sense a problem here in moving the master database withina clustered enviornment, which must be performed on a controlled manner. Otherwise you will be risking the availablility of cluster as SQL service is dependant on the master datbase.
    What Hemant referred still applicable and as it is SQL 2005 you can make use of SQLCMD:
    Bring all the resources of the SQL Server Group in the cluster offline (except for Disk drive and IP Address).
    Go to command prompt and start sql server using the following command sqlsrvr.exe -m (single user mode)
    Connect to sqlcmd using ip address of the sql service sqlcmd -S xxx.xx.xx.xx (ip)
    satya, Nov 26, 2008
    #6

Share This Page