Maystyle :
Admin : New post
Guestbook
Local
media
Catergories
Recent Articles
Recent Comments
Recent Trackbacks
Calendar
Tag
Archive
Link
Search
 
  Rebuild Master Database in SQL Server 2005 with Clustered Environment. 
작성일시 : 2008. 12. 17. 14:34 | 분류 : SQL Server/Cluster

-. Start the SQL Server in Single User Mode 
You can skip the this step.

1. Run the SQL Server Configuration Manager
image

2. Changing SQL Server Startup Parameters
Add "-m;" in Startup Parameters
image

3. Restart the SQL Server Service.

- Rebuild the Master database.

start /wait <CD or DVD Drive>\setup.exe /qn VS=<VSName> INSTANCENAME=<InstanceName> REINSTALL=SQL_Engine REBUILDDATABASE=1 ADMINPASSWORD=<StrongPassword> SAPWD=<NewStrongPassword> SQLCOLLATION=<NewSystemCollation> SQLACCOUNT=<domain\user> SQLPASSWORD=<DomainUserPassword> AGTACCOUNT=<domain\user> AGTPASSWORD=<DomainUserPassword>

If you want to change collation, add SQLCOLLATION=<Collation>.
"ADMINPASSWORD=" means current logon account.

- Attach the user databases.

http://msdn.microsoft.com/en-us/library/ms143719(SQL.90).aspx

|