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

    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
  2. ghemant Moderator

  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
  4. ghemant Moderator

    I believe this will remain same for SQL Server 2005
  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)

Share This Page