Link to home
Start Free TrialLog in
Avatar of Chandra Mohan Kanithi
Chandra Mohan KanithiFlag 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
ASKER CERTIFIED SOLUTION
Avatar of lcohan
lcohan
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Chandra Mohan Kanithi

ASKER

Thanks for prompt response.

Regards,
Chandra