Solved

should i stop sql service during windows updates install

Posted on 2014-11-19
4
393 Views
Last Modified: 2014-12-01
windows server os 2008 r2
sql server 2012

Im doing a windows update on a sql server.
it has 1.5 gig of updates including service pack II for sql server.

what should I do to make this update as safe as possible?
should I stop the sql server then run the updates?
I was thinking of doing this to kill any active sql session connections.

is there a way to monitor and disconnect sessions to sql through a gui?
0
Comment
Question by:jamesmetcalf74
4 Comments
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 125 total points
ID: 40454615
Here's are two websites with instructions for installing any service pack safely (not just this one):

http://sqlmag.com/database-development/installing-service-pack-2
http://blogs.technet.com/b/beatrice/archive/2009/02/10/best-practices-for-installing-sql-server-service-packs-hotfixes-cumulative-updates.aspx

Definitely: Back up all databases beforehand - and test!

NOTE: There is a regression bug, so there may be a hotfix that you want to install beforehand - see http://sqlblog.com/blogs/aaron_bertrand/archive/2014/06/10/sql-server-2012-service-pack-2-is-available.aspx for more information.
0
 
LVL 18

Assisted Solution

by:x-men
x-men earned 125 total points
ID: 40454668
On SQL Server Configuration Manager, disable TCP, leave Shared memmory enabled. This will prevent any "outside" connections, and allows "in server" connections.
Do not stop the SQL server service, the update will take care of it.

SQL Service packs should be installed separately from windows server updates, and between reboots.
0
 
LVL 46

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 125 total points
ID: 40454737
Do not stop the SQL server service, the update will take care of it.
This is the worst thing to do. The update doesn't know if it's some process running and can kill any important task (migration, massive operations with data, etc...). It might ends with a corruption in a database.

If you know that a Windows Update will reboot the machine (generally it does) then you should stop manually the SQL Server. Before stop a SQL Server instance always check for running activities and wait for all processes to terminate before rebooting. Also check for high number of VLF (virtual log files) because can put a database in restore mode for hours, after reboot.

SSMS has a Activity Monitor option. You can check there for the running processes.
0
 
LVL 42

Assisted Solution

by:EugeneZ
EugeneZ earned 125 total points
ID: 40455008
it depends  on your environment and patches details
Normally, you should not stop sql services unless you are on Windows NT sql 4.21 :)
However, in order to avoid any active processes interruptions resulting after post patch reboot  possible long DB recovery\data-db corruption  you may stop services.
Again: it is up to your server activities and patches
Note: sql patches need to have sql server be up and running..
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

932 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now