Solved

should i stop sql service during windows updates install

Posted on 2014-11-19
4
537 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 49

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:Eugene Z
Eugene Z 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
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 …
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

733 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