asked on

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?

Vitor Montalvão

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 Sahin

ASKER

Availabilty group server name:SrvAG1 (Secondary)

Availabilty replicas:

Srv01
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ão

Failover will only occurs when applying on Primary Replica.

Teoman Sahin

ASKER

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?

ASKER CERTIFIED SOLUTION

Vitor Montalvão

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Teoman Sahin

ASKER

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;

SQL12CLUA
SQL12CLUB

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?
Cluster1.jpg
Cluster2.jpg

Vitor Montalvão

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.