/*      --------------------------------------------------

        master db rebuild

--------------------------------------------------   */

http://blogs.msdn.com/b/psssql/archive/2008/08/29/how-to-rebuild-system-databases-in-sql-server-2008.aspx


USE MASTER

GO

 

-- COLLATION_NAME 확인

SELECT NAME, COLLATION_NAME FROM SYS.DATABASES

 

-- SQL 서비스 중지

cmd > SETUP.EXE /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS=윈도우계정명 /SQLCOLLATION=KOREAN_WANSUNG_CI_AS /SAPWD=sa비밀번호

 

 

+ Recent posts