This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 55.00000000000001%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Hello Guys,
On a server with large databases, should we stop sql server services before installing service pack?
Or should stoped the database utilizations?
Thanks
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Hi @Alessandro Kiffer ,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Seeya
Hi @Alessandro Kiffer ,
In order to benefit all community members who are having this similar issue, please choose an answer to accept or vote for the answer you think is useful to you. Your contribution is highly appreciated.
Best regards,
Seeya
You don't need to stop SQL Server. Setup will take care of that. But, yes, you should announce to users that the database(s) will be unavailable for some time, and make sure that they are disconnected. If you have users connected when Setup runs, they will be kicked out and it will not be a very good userr experience.
Hi @Alessandro Kiffer ,
It is generally recommended to stop database utilization before installing a service pack on a SQL Server instance. This will ensure that no transactions are being processed during the installation process and that the databases are in a consistent state after the installation is complete.
Stopping the SQL Server service itself is not necessary, but it may be useful to stop any other applications or services that are using the SQL Server instance to avoid potential conflicts during the installation.
Additionally, it is always a good practice to back up all databases and configuration settings before applying any service pack or update to ensure that you have a reliable restore point in case any issues arise during or after the installation process.
Best regards,
Seeya
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".