November 15, 2013 at 2:30 am
When I install the SQL SERVER 2008R2 SP2 CU1 offline disks fails and leaves the failed instances (clustered).
I roll online and instances discontinuous work well.
When you uninstall CU1 fails in one of the instances, and now on the active node fails to start the agent.
The installation process is as follows:
1. - Active node is updated
2. - Put the disks offline and failed instancioas
3. - Disks are placed online and everything works.
4. - Uninstall CU1 active node fails
5. - In active node fails to start the agent.
The error that leaves the SQLAHENT.OUT:
SQLServer Error: 5597
SQLServer Error: 15281
I need urgent help
November 15, 2013 at 4:40 am
The information you have supplied is not particularly clear.
When patching clustered SQL instances the process you should follow is:
1. Patch the passive nodes of the cluster
2. Failover the active node of the cluster to a passive node, this will begin the upgrade of the system databases etc.
3. Once what was the former passive node is now active patch what was previously the active node.
4. Once this is complete failback to ensure all nodes are running the correct version of SQL.
MCITP SQL 2005, MCSA SQL 2012
November 15, 2013 at 5:30 am
The install of the way you show me ¿is it for loss of service?,
As you show me would be:
1. - Passive Node: install SP2 CU1
2. - Balancing cluster with instances.
3. - Check that the passive node instances are in: 10.50.4260
4. - Active Node: Installing SP2 CU1
5. - Balancing the active node.
6. - Check that the active node instances are in: 10.50.4260
Is it right?
November 15, 2013 at 9:28 am
javirsantos (11/15/2013)
The install of the way you show me ¿is it for loss of service?,As you show me would be:
1. - Passive Node: install SP2 CU1
2. - Balancing cluster with instances. -- What do you mean by balancing as SQL server does not support load balancing?
3. - Check that the passive node instances are in: 10.50.4260 -- You will need the node to be active to check the version, when passive you can only check in the installation log created by the CU update.
4. - Active Node: Installing SP2 CU1
5. - Balancing the active node. -- Same question as above.
6. - Check that the active node instances are in: 10.50.4260
Is it right?
I'm sorry but I am having real difficulty understanding your descriptions. If I am interpreting your question correctly you will only experience downtime of the SQL server during the initial failover to a patched instance, this time will incude the taking offline of the SQL Server and its resources from the active node and bringing them online on the passive node. In addtion once the resources are back online the update process will automatically upgrade the system databases.
There is no exact figure on how long this will take but on our production SQL servers which have approx 15 databases with a total storage of 4TB this took approximately 6 minutes, During this time the server and databases are unaccessible.
When failing back from the now patched active node to a patched passive node the time should be less as the databases have already been upgraded during the first failover.
MCITP SQL 2005, MCSA SQL 2012
November 15, 2013 at 10:06 am
javirsantos (11/15/2013)
When I install the SQL SERVER 2008R2 SP2 CU1 offline disks fails and leaves the failed instances (clustered).I roll online and instances discontinuous work well.
When you uninstall CU1 fails in one of the instances, and now on the active node fails to start the agent.
The installation process is as follows:
1. - Active node is updated
2. - Put the disks offline and failed instancioas
3. - Disks are placed online and everything works.
4. - Uninstall CU1 active node fails
5. - In active node fails to start the agent.
The error that leaves the SQLAHENT.OUT:
SQLServer Error: 5597
SQLServer Error: 15281
I need urgent help
If you patch an active node rather than a passive node then yes the cluster resources will be taken offline by the installer, that is why you patch passive nodes first then failover when you are ready
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2013 at 1:29 am
Ok, perfect everything.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply