November 25, 2009 at 7:59 am
Hi,
Im a noob to the sql world. My question is, it seems like automatic updates have finished applying the updates and it keeps on asking me to restart the server.. is there anything I should keep in mind after it restarts? Just concerned that services will not start up properly. Could someone give me some rule of thumbs of what to do after a server restart, please.
Thanks much!
November 25, 2009 at 8:02 am
Check if your required SQL Server services are set to start automatically or not, if not modify the properties to set it automatic.
November 25, 2009 at 8:04 am
You should check if the SQL Server Service is running fine, the SQL Agent Service is running and if you have installed/enabled other services as SQL Browsing, Reporting, SSIS, etc then all services should start up.
Once it is up, try to connect to master and some user databases to make sure they are working fine.
Generally, there will not be any issue in this restart case.
November 25, 2009 at 8:09 am
thanks for your replies..
and of course with the restart, it should be during off-hours correct?
November 25, 2009 at 8:12 am
dbit (11/25/2009)
thanks for your replies..and of course with the restart, it should be during off-hours correct?
That's obvious, and if it's a production server, inform the application team / owners that there will be a downtime.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 25, 2009 at 8:39 am
Though not in the initial question, I need to ask how you are actually getting the Updates. Is automatic updates configured to receive the updates directly from the website, from WSUS/SUS, or SMS?
Patches should be applied to a test environment prior to rolling to production. For this reason, it is better to not retrieve your updates directly from the website to your server - unless you disable the service and only enable it at the time you wish to update the server. It is more desirable to use WSUS or something like that so you can approve the rollout of updates to the different environments.
Patch test environment, test heavily, then after testing passes - roll to prod during a down time.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply