One of our SQL Server 2014 clusters was installed and after the install, my client told me that we are supposed to change the SQL Server collation setting. In this post I will show a procedure to change the collation settings of a clustered SQL Server instance.
To change the default SQL Server collation you have to rebuild the system databases. Before you rebuild the system databases, review the Microsoft MSDN documentation regarding backup of your system databases and logins.
- https://msdn.microsoft.com/en-in/library/ms190190(v=sql.120).aspx
- https://support.microsoft.com/en-in/kb/918992
When you rebuild the master, model, msdb and tempdb system databases are actually dropped and recreated in their original location.
No comments:
Post a Comment