Service Pack Updates for SQL 2012(Denali)
-
Greetings Everyone!
We have a production server running with RTM, no service pack applied, the environment is setup in cluster as one node active and other as passive.
Now current SP for SQL 2012 is Service pack 3 can i directly update RTM to SP3 + CU3 without applying SP1 and SP2.
In cluster if we are running how can we run service pack without stopping the database, Correct me from below process
On passive node:
-------------------
1) Stop all SQL services on the passive node .(Do we need to check preferred or possible owner for single active-passive cluster mode)
2) Run the SP3.exe file
3) After apply SP3 again run CU3
4) Restart the windows server
5) Bring all the services online
6) check the cluster services and validating them
On active node:
---------------------
1) Making node as Passive from Active
and repeat from step 2 to 6 as above
Please correct me if i am wrong, and please let me know do we require any downtime by doing above process
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Save a tree... Please don't waste paper unless you really need to!
When life puts into problem don't say 'God Why Me' say:w00t: 'Try Me'
-
Yes, you have the basic steps, I usually follow these steps:
1) Place the SP on both nodes
2) Upgrade the passive node first by running the SP executable on it - ensure all sql instance(s) are on one node (the active one) prior
3) Reboot the passive node after the SP is applied successfully
4) Failover the sql instance(s) to the just upgraded node making it the active one - the database are upgraded at this point
5) Apply the SP to the new passive node
6) Fail back over the instance(s) to the original active node
7) done
-
So i can apply most recent SP3 to my RTM SQL Server, do i need to stop SQL Server services(SQL Server and SQL Agent, Browser Service etc..) when i am doing SQL Server Service pack update.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
When life puts into problem don't say 'God Why Me' say:w00t: 'Try Me'
-
Correct, they are cumulative, so, you only need to apply the latest. No, you do not need to stop the Sql Services when applying the SP.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply