2005 Collation Change

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

MannySingh SSChampion Points: 12465 More actions · Answer 1

on a Clustered Environment, Did you detach the nodes and stop the cluster services before attempting this:

butter0612 SSC Enthusiast Points: 198 More actions · Answer 2

If I detatch the nodes or stop the cluster service I loose the resources, i.e. no disk access and will not be able to see the system databases.

MannySingh SSChampion Points: 12465 More actions · Answer 3

check to see this post if it is useful:

BTW: if you want to change the collation of one database use ALTER database.

butter0612 SSC Enthusiast Points: 198 More actions · Answer 4

Thanks for the useful command...

Would it be as simple as adding the VS= command since I have them setup as A/A... Virtual Server = PSQLA, Instance = INST1..

So alter the command to add:

start /wait setup.exe /qb VS=PSQLA INSTANCENAME=INST1 REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD= SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS

?

MannySingh SSChampion Points: 12465 More actions · Answer 5

your command should work but before starting the install:

some more info:

butter0612 SSC Enthusiast Points: 198 More actions · Answer 6

Thanks for all the links for information. I reviewed them and found that the only thing I was missing was the VS= command... so far... HAHA

We opened a ticket with M$ a couple hours ago, I will update when a solution is found...