Service Pack on SQL cluster?

Lanz · 3 Feb 2010 at 14:51

Hi

Just wondering whats the best way to do a SP3 upgrade to a SQL2005 SP2 active/passive cluster?

I've read that the installer is cluster aware and will do it all for you, is this true? Or do I have to do anything special?

Cheers

a1ex2001 · 3 Feb 2010 at 15:48

http://www.db-staff.com/index.php/microsoft-sql-server/87-upgrade-sql-2005-cluster-to-sp3

Lanz · 3 Feb 2010 at 15:56

Thanks!

Lanz · 4 Feb 2010 at 10:56

Well what a nightmare that was....

The method above didnt work for me. I had to do each node on its own, and it took about 90 mins each.

katana6434 · 5 Feb 2010 at 17:11

You would usually do the passive node, failover and then do the other node. If neccessary fail back again.

sounds like thats what you did in the end.