Solved

should i stop sql service during windows updates install

Posted on 2014-11-19
4
500 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 48

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

809 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