how to apply service pack2 for sql server

I have SQL server 2012 high availability server and it consists of two availability replicas; Srv01 and Srv02 and availability group name:SrvAG1 so in this environment,I would like to apply SQL service pack 2 to this structure so how can I apply the sql service pack 2 of sql server 2012?
Teoman SahinAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
Just run the SP2 file. First on the second replica and then in the first one.
Do it during no activities in the desired replica so nobody will be impacted.
Teoman SahinAuthor Commented:
Availabilty group server name:SrvAG1 (Secondary)

Availabilty replicas:

Srv02 (Secondary)

that means, SP2 will be run firstly on the Srv02(Secondary) and then Srv01... is that right?

will the Failover be made on the nodes when applying service packs as like Mirroring in the SQL Server 2008R2 or Failover Clustering environment(Active/Passive)?
Vitor MontalvãoMSSQL Senior EngineerCommented:
Failover will only occurs when applying on Primary Replica.
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Teoman SahinAuthor Commented:
could you please give me detailed information about that so I haven't apply the service pack on the 2012 Always on high availabitly structure before?
Vitor MontalvãoMSSQL Senior EngineerCommented:
Did you read the MSDN article about applying SPs on AG?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Teoman SahinAuthor Commented:
many thanks..I read that article but I am confused about which node is active on the Failover Cluster
I am looking at the Windows 2012 Server and sql server 2012 is installed on this server.. when I look at the Failover Cluster manager,I see the Cluster name and Current host server there ;see attached file

there are two nodes;


Cluster Name: SQL12CLU
Current Host name: SQL12CLUB

but when I look at the Roles in Failover Cluster management, SQL12CLUA seems to be owner node so why are they different? I think, the server in the Owner Role should be Active node,which is SQL12CLUA but on the other hand, I see the SQL12CLUB as a Current host name..which is the active node in this structure?
Vitor MontalvãoMSSQL Senior EngineerCommented:
I am confused about which node is active on the Failover Cluster
That's because you're seeing this as a MSSQL cluster instance and it's not. Forget the failover cluster.
For AlwaysOn you need to check inside SSMS, under AlwaysOn High Availability folder. In the Availability Groups you'll see which node has the Primary (active) and which one has the Secondary Replica.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.