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

Need to install ssqlserver service pack sp4 in a cluster server Expand / Collapse
Author
Message
Posted Wednesday, May 15, 2013 11:36 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 10, 2014 11:09 PM
Points: 549, Visits: 1,181
Need to install sqlserver service pack sp4 in a cluster server
1.what are the pre-requesties i have to follow
2.cluster is in Active/Active
also it is running for primary [ DC ] and secondary [ DR ] servers
3. if i install service pack in the DB server [ DC ]is it necessary to install in the AP [ DR ] server also ?

4. logshipping is running in primary server [ DC ]and secondary server [ DR ]

1. in this case we want to install sp4 in [ DR ] sever after monitoring
for few days we want to install in the [ DC ] server.is it possible
2. if we install in [ DR ] server for both AP and DB servers [both nodes ]
is it required to reconfigure the logshipping from DC to DR again ?


Thanks & Regards
NAGA.ROHITKUMAR
Post #1453330
Posted Thursday, May 16, 2013 2:17 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 9, 2014 6:02 AM
Points: 2,674, Visits: 697
I'm assuming you mean sql 2005 here as SQL 2008 is only at sp3.
service packs are cluster aware for the database engine although you'd need to do the nodes for the tools.
we normally patch the secondary server, DR, before the primary as this avoids issues with backups failing due to different builds.


The GrumpyOldDBA
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Post #1453775
Posted Thursday, May 16, 2013 10:43 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 10, 2014 11:09 PM
Points: 549, Visits: 1,181
HI colin
Here we are using sqlserver 2005 and we want to install into the Dr server first and is it required to re assign[configure the logshipping from dc to dr server] or the logshipping which is running remains same.

and also if we install in dr server ithink we have to install sp4 in both datasbase server DB and application server AP i mean in both nodes


Thanks & Regards
NAGA.ROHITKUMAR
Post #1453843
Posted Tuesday, June 4, 2013 9:39 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:50 AM
Points: 6,175, Visits: 13,319
For sql server 2005 run the patch from the active node when you have an agreed period of downtime.

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

"Ya can't make an omelette without breaking just a few eggs"
Post #1459840
Posted Friday, June 7, 2013 5:05 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 10, 2014 11:09 PM
Points: 549, Visits: 1,181
Ok thank you

Active [DB] / Active [Ap]node is running here
if i install in DB active node --- in this log-shipping is configured
if we install the service pack will all the jobs and configurations remains same [or ]need to re-configure ??


Thanks & Regards
NAGA.ROHITKUMAR
Post #1461032
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse