Chandra Mohan Kanithi
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\Bin n
3. Apply a New SQL Server Collation
sqlservr -m -T4022 -T3659 -s"MSSQLSERVER" -q"SQL_Latin1_General_CP12 50_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
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
3. Apply a New SQL Server Collation
sqlservr -m -T4022 -T3659 -s"MSSQLSERVER" -q"SQL_Latin1_General_CP12
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Regards,
Chandra