Re: SP3a on cluster...help please
From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 06/23/04
- Next message: Maurizio Camurati: "SQLAgent crash"
- Previous message: Josephine: "Re: SP3a on cluster...help please"
- In reply to: Josephine: "Re: SP3a on cluster...help please"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: SP3a on cluster...help please"
- Reply: anonymous_at_discussions.microsoft.com: "Re: SP3a on cluster...help please"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 23 Jun 2004 16:39:55 -0400
The article specifically talks about resources in the same SQL resource
group Additional physical disks and IP addresses don't count. It is a good
idea to disable monitoring apps during a service pack install, even if they
aren't in the same resource group. That way, they cannot interfere with the
SP. As for replication, you can stop the log reader and distribution tasks
for the same reason (assuming transactional replication). The main reason
to disable anything that is in the resource group OR that constantly
connects to SQL is to make sure that the service pack installer always gets
the one connection when the server is started in single-user mode.
-- Geoff N. Hiten Microsoft SQL Server MVP Senior Database Administrator Careerbuilder.com I support the Professional Association for SQL Server www.sqlpass.org "Josephine" <anonymous@discussions.microsoft.com> wrote in message news:2037701c4595c$e0e6c560$a601280a@phx.gbl... > So what it means basically is any applications that are > dependent on the databases in that cluster need to be > stopped? Or just things like Director or MOM need to be > stopped? Or both? > Do I need to do anything to the Replication? It mentions > stopping the updates. Just disable it? It replicates once > a week. > Thanks again, I really appreciate the knowledge > Josephine. > > >-----Original Message----- > >The article refers to non-SQL resources such as a third- > party monitoring > >tool that needs to live in the SQL virtual server. If > you have added more > >disks and SQL is dependant on them (necessary if you want > to store data on > >them), then leave your setup alone. Setup wants all > nodes active since it > >must do a binary-only upgrade to all the nodes. Note > that service packs are > >applied to an instance, not a node. You will have to run > the service pack > >once for each instance. > > > >-- > >Geoff N. Hiten > >Microsoft SQL Server MVP > >Senior Database Administrator > >Careerbuilder.com > > > >I support the Professional Association for SQL Server > >www.sqlpass.org > > > >"Josephine" <anonymous@discussions.microsoft.com> wrote > in message > >news:2001801c45925$42ddca30$a601280a@phx.gbl... > >> I'm a newbie with a big load, and I would appreciate > some > >> insight. > >> In my environment, I have an active/active cluster, that > >> also has Snapshot Replication from the slave node to the > >> master node. > >> Can someone offer some guidance how to apply the SQL > SP3a > >> service pack? > >> In the Service Pack 3a readme.htm, section 3.10 #1, says > >> if any resources have been added with dependencies on > SQL > >> Server Resources those dependencies must either before > >> removed or taken offline. I understand how to do his, > but > >> say, if I take a physical drive that offline from the > >> instance, how can it work if it also says all nodes must > >> be active? > >> I'm a little confused, and want to get this upgraded for > >> obvious reasons. > >> Thanks for your help, > >> Josephine. > > > > > >. > >
- Next message: Maurizio Camurati: "SQLAgent crash"
- Previous message: Josephine: "Re: SP3a on cluster...help please"
- In reply to: Josephine: "Re: SP3a on cluster...help please"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: SP3a on cluster...help please"
- Reply: anonymous_at_discussions.microsoft.com: "Re: SP3a on cluster...help please"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
