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 2008http://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
Michel Degremont| Microsoft EMEAProduct Support Services Developer -SQL Server Core Engineer |