Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Upgrading SQL Server 2008 R2 SP1 to SP3 on a cluster is an outage required

Posted on 2016-08-08
2
Medium Priority
?
155 Views
Last Modified: 2016-08-08
Heyas,

I am running SQL Server 2008 R2 on Vmware Windows Server 2008 R2 cluster (2 node cluster) I want to upgrade the service pack from SP1 to SP3.  My query  twofold is an outage required and if it is can I failover my SQL Server to the second node?

Any advice is appreciated.

Thank you.
0
Comment
Question by:Zack
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 52

Accepted Solution

by:
Vitor Montalvão earned 2000 total points
ID: 41748299
Upgrade first in the passive node. When finished wait for a period with no activity (or less possible activity) in the SQL Server instance and failover it to the passive node. Now the passive become active and you can upgrade the other node.
You can failback the SQL Server instance to his original node after both nodes upgraded. Again, try to perform this operation in a less activity period.
0
 

Author Closing Comment

by:Zack
ID: 41748303
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Resolving an irritating Remote Desktop connection that stops your saved credentials from being used.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

661 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question