SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Need to install ssqlserver service pack sp4 in a cluster server


Need to install ssqlserver service pack sp4 in a cluster server

Author
Message
naga.rohitkumar
naga.rohitkumar
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1578 Visits: 1378
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
Naga.Rohitkumar
colin.Leversuch-Roberts
colin.Leversuch-Roberts
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12373 Visits: 715
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/
naga.rohitkumar
naga.rohitkumar
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1578 Visits: 1378
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
Naga.Rohitkumar
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)

Group: General Forum Members
Points: 55057 Visits: 17697
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" ;-)
naga.rohitkumar
naga.rohitkumar
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1578 Visits: 1378
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
Naga.Rohitkumar
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search