Avatar of Chandra Mohan Kanithi
Chandra Mohan Kanithi
Flag for India asked on

To change SQL Server 2014 Default Instance Collation

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
Microsoft SQL Server

Avatar of undefined
Last Comment
Chandra Mohan Kanithi

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
lcohan

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
David Todd

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Chandra Mohan Kanithi

ASKER
Thanks for prompt response.

Regards,
Chandra
Your help has saved me hundreds of hours of internet surfing.
fblack61