Restoring master database in a clustering database

• klai

  SSC Rookie

  Points: 28

  More actions

  July 30, 2002 at 10:13 am

  #63181

  Hi, Brian,

  Thanks for sharing the Clustering experience with us. I have a question for you regarding recovery master database from a good backup (disk) in the clustered (active/active) database environment (Windows 2000 Advanced Server and SQL Server 2000 Enterprise Edition with SP2). Here is the situation: A shared disk (disk 1) which master database reside in failed. SQL Server is not accessible.

  How do you recovery the master database? Does regular restoring process work (i.e. rebuild master device then restore master database from the backup) ? Do you have to uncluster/recluster SQL Server?

  Thank you very much.

• Brian Knight

  One Orange Chip

  Points: 27259

  More actions

  July 31, 2002 at 5:08 am

  #433695

  Hi,

  I dug for a bit and found a support article on MS that covered just that. Hope this helps!

  http://support.microsoft.com/default.aspx?scid=kb;en-us;Q298568

  Brian Knight

  bknight@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/bknight

  Brian Knight
  Free SQL Server Training Webinars