SQL Server 2008 Cluster Collation Change

1. First make sure you have all the database backups including system            database.
2. Generate scripts for all the logins, Linked Servers, Server Triggers etc.
3. Generate scripts for all the Jobs exist on server.
4. Reset the SA password if you don’t know. And save it to safe place.
5. To change the collation for SQL Server 2008, If we are changing from same node, First we need to take resources offline (SQL Server, SQL Agent, Fulltextsearch) and run the below syntax on command prompt from SQL Server Setup directory.




C:\SQL>Setup.exe /QUIET /ACTION=REBUILDDATABASE /INSTANCENA
ME=INST1 /SQLSYSADMINACCOUNTS="Domain\Account" /SAPWD=<SA Password> /SQLCOLLATION=<New Collation>