Hi,
I need to change SQL Server 2014 Default Instance Collation and find the Server details.
User Databases : 15
Size of Databases : Below 10 GB - 10 Databases
: 10 GB to 15 GB - 2 Databases
: Remaining Three are 36 Gb, 71 GB and 100 GB
Note: Transaction Log files drive have 135 GB free space out of 200 GB.
I have successfully applied following solution on Test Server.
1. Stop SQL Server Services.
2. Open a Command Prompt and Navigate to the Binn Directory
C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn
3. Apply a New SQL Server Collation
sqlservr -m -T4022 -T3659 -s"MSSQLSERVER" -q"SQL_Latin1_General_CP1250_CI_AS"
4. Start SQL Services and verify collation
Please provide precautions regarding log space during collation change (indexes are restoring during this activity) and more pre-requisites.
Thanks,
Chandra