데이터베이스

서버 데이터 정렬 COLLATION 변경 - MSSQL

Jinwookoh 2014. 8. 18. 23:41

--backup database master to disk = 'c:\master_bak';
--backup database model to disk = 'c:\model_bak';
--backup database msdb to disk = 'c:\msdb_bak';
--backup database mydatabase to disk = 'c:\mydatabase_bak';
select name, COLLATION_name from sys.databases;


SQLManagementStudio_x86_KOR.exe /action=rebuilddatabase /instancename=SQLEXPRESS /SQLSYSADMINACCOUNTS=아이디 /SQLCOLLATION=Korean_Wansung_CS_AI /SAPWD=암호