May 6, 2008 at 8:16 am
We are looking to upgrade our SQL 2005 Cluster to SP2 but I cannot find any documentation or threads of anyone that has done this. We have 3 Windows 2003 Enterprise Edition SP2 running 2 instances of SQL (INST01 and INST02). There are two resource groups running on one node and one running on another leaving the third for failover.
We recently installed Windows 2003 SP2 we had to install on each node individually, we paused the node in cluster admin, moving the resource(s) off the server before installing the SP2, rebooting then resuming the node moving the resource group back and testing.
Does anyone know what we would need to do for SP2 for SQL Server 2005 in this situation?
May 6, 2008 at 8:31 am
We recently installed Windows 2003 SP2 we had to install on each node individually, we paused the node in cluster admin, moving the resource(s) off the server before installing the SP2, rebooting then resuming the node moving the resource group back and testing.
Does anyone know what we would need to do for SP2 for SQL Server 2005 in this situation?
No need for this with SQL Server SP2. When you start SP2 on one node it will detect all instances installed. It will also detect if it's a clustered instance and in that case aplly the service pack to both nodes. BUt keep in mind that for the non-clustered features like SSIS , RS, NS and client tools you still have to install the SP2 manually on each node.
Also from the readme file from SP2:
Installing SQL Server 2005 SP2 on a Failover Cluster Instance
Note the following information before you install SP2 on a failover cluster instance:
*Do not stop the cluster service before you run the SP2 Setup program, or while the installation program is running.
*Do not end any running processes before you run the SP2 Setup program.
*Do not take the SQL Server service off line before you run the SP2 Setup program. The SP2 Setup program will stop and start the SQL Server service.
*Run the SP2 Setup program on the primary node of the failover cluster instance.
*You must restart all failover cluster nodes after SP2 is finished installing.
[font="Verdana"]Markus Bohse[/font]
May 6, 2008 at 8:48 am
Excellent thanks a lot.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply