Monday, March 12, 2012

MS SQL Server 2008 R2에서 Collation 변경하기

setup.exe
/QUIET
/ACTION=REBUILDDATABASE
/INSTANCENAME=instance_name
/SQLSYSADMINACCOUNTS= accounts
[/SAPWD=password]
[/SQLCOLLATION=collation_name]

setup /ACTION=REBUILDDATABASE /QUIET /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS=Bongsub /SAPWD=P@ssword /SQLCOLLATION=Korean_Wansung_CS_AS

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

주의)master 데이터베이스 변경작업이기 때문에 Backup은 필수... 테스트 해보니 모든 데이터베이스가 훌라당 날아감!

No comments: