Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error installing SP2 CU1 sqlserver 2008 R2 SP1 CU1 Expand / Collapse
Author
Message
Posted Friday, November 15, 2013 2:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 04, 2014 7:06 AM
Points: 3, Visits: 117
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
Post #1514637
Posted Friday, November 15, 2013 4:40 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 4:24 AM
Points: 286, Visits: 539
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
Post #1514664
Posted Friday, November 15, 2013 5:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 04, 2014 7:06 AM
Points: 3, Visits: 117
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?
Post #1514678
Posted Friday, November 15, 2013 9:28 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 4:24 AM
Points: 286, Visits: 539
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
Post #1514775
Posted Friday, November 15, 2013 10:06 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:15 PM
Points: 5,951, Visits: 12,822
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"
Post #1514786
Posted Monday, November 18, 2013 1:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 04, 2014 7:06 AM
Points: 3, Visits: 117
Ok, perfect everything.
Post #1515128
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse