How to do you install service pack 3 on SQL Server 2005 in cluster environment?

• Motomoto

  Right there with Babe

  Points: 799

  More actions

  March 15, 2011 at 4:16 pm

  #233248

  Could you anyone please provide me instructions on how to do you install service pack 3 on SQL Server 2005 in cluster environment?. I have never done it before and I have perform this in our production environment this week. Thank you in advance for you help.

  Kind Regards,

  Abdul

• george sibbald

  SSC Guru

  Points: 104210

  More actions

  March 15, 2011 at 4:50 pm

  #1299163

  run this search on http://www.google.com/microsoft

  service pack 3 sql2005 cluster

  and select instructions that apply to you.

  basically stop connections, backup databases, disable ddl triggers, apply to active node from a location both nodes can see.

  warning - back out is a reinstall

  ---------------------------------------------------------------------