troubleshooting Question

To change SQL Server 2014 Default Instance Collation

Avatar of Chandra Mohan Kanithi
Chandra Mohan KanithiFlag for India asked on
Microsoft SQL Server
3 Comments2 Solutions151 ViewsLast Modified:

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.

Database Analyst

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros