Share via

How to rebuild System Databases on SQL server 2008 in cluster failover

  • Article

When the master, model, msdb, and tempdb system databases are rebuilt, the databases are dropped and re-created in their original location. If a new collation is specified in the rebuild statement, the system databases are created using that collation setting. Any user modifications to these databases are lost.

Step 1: Review the documentation "before Rebuild the System Databases"

Rebuild master in SQL Server 2008
https://msdn.microsoft.com/en-us/library/dd207003.aspx

Step 2: Put off line SQL Server resource by using Failover Cluster Mamagement

Step 3: Go on the node where this clustered instance is owned

Step 4: Then, run the command :

setup.exe
 /Q
 /ACTION=REBUILDDATABASE
 /SQLSYSADMINACCOUNTS="DomaineName\UserAccount"
 /SQLCOLLATION=CollationName
 /INSTANCENAME="OnlyInstanceName"
/SAPWD=StrongPassword

Step 5: Apply the last service pack

Caution

-          The INSTANCENAME parameter takes only the instance name, without any server/virtual server name. For the default instance, enter MSSQLSERVER.
-          If this clustered instance is owned by the current node, the SQL Server resource must be offline or failed.
-          The specified SA password must meet strong password requirements. For more information about strong password requirements, see "Database Engine Configuration - Account Provisioning" in Setup Help or in SQL Server 2008 Books Online.
-         The parameter SAPWD is required if the instance uses Mixed Authentication (SQL Server and Windows Authentication) mode.
-          The collation must be existed (see https://msdn.microsoft.com/en-us/library/ms180175.aspx ).

 

 

Michel Degremont| Microsoft EMEA
Product Support Services Developer -SQL Server Core Engineer |

Comments

  • Anonymous
    March 02, 2016
    "...the databases are dropped and re-created in their original location".Well, that is not true for the tempdb database if it was initially created on a location different than the default created by sql server. I set the tempdb location to another disk at the installation step and with the rebuilt it recreated in the DATA folder created by sql server. Other databases were recreated in their original locations. However I understood your post which is tiny great. Thanks.