# SQL server 2019 and Cumulative Update : what are best practices? **URL:** \ **Category:** Ignition\ **Tags:** ignition81\ **Created:** [March 30, 2023, 12:51pm UTC](https://forum.inductiveautomation.com/t/sql-server-2019-and-cumulative-update-what-are-best-practices/71824 "2023-03-30T12:51:39Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Stephane\_Boneff](https://avatars.discourse-cdn.com/v4/letter/s/59ef9b/32.png) [@Stephane\_Boneff](https://forum.inductiveautomation.com/u/Stephane_Boneff)\ **Post date:** [March 30, 2023, 12:51pm UTC](https://forum.inductiveautomation.com/t/sql-server-2019-and-cumulative-update-what-are-best-practices/71824/1 "2023-03-30T12:51:39Z")
Hello, We use Ignition with SQL server 2019 standard Enterprise. SQLserver hadn't been updated since it was installed. Now there are 19 Cumulative Update [https://support.microsoft.com/en-au/topic/kb5023049-cumulative-update-19-for-sql-server-2019-b63d7163-e2e7-46f7-b50a-c3d1f2913219](https://support.microsoft.com/en-au/topic/kb5023049-cumulative-update-19-for-sql-server-2019-b63d7163-e2e7-46f7-b50a-c3d1f2913219) They contains a lot of fix. Sqlserver is only used by Ignition app. But there is a problem : we had only one server, which contains 2 instances of SQL server (test and prod). What are the best practices about that ? (I'm not responsible for all the choices above !) Thanks ! ---
**Author:** ![bschroeder](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bschroeder/32/13260_2.png) [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\ **Post date:** [March 30, 2023, 12:55pm UTC](https://forum.inductiveautomation.com/t/sql-server-2019-and-cumulative-update-what-are-best-practices/71824/2 "2023-03-30T12:55:01Z")
Honestly, my approach on most of this is if it isn't broke don't fix it. If that server can't reach the internet, then the attack surface for security updates is pretty small. And if the server is functioning properly, then I would be very hesitant to update. However, IT doesn't usually see things that way, and if they are forcing your hand, I would plan on a backup and update during a maintenance day. ---
**Author:** ![Stephane\_Boneff](https://avatars.discourse-cdn.com/v4/letter/s/59ef9b/32.png) [@Stephane\_Boneff](https://forum.inductiveautomation.com/u/Stephane_Boneff)\ **Post date:** [March 30, 2023, 1:03pm UTC](https://forum.inductiveautomation.com/t/sql-server-2019-and-cumulative-update-what-are-best-practices/71824/3 "2023-03-30T13:03:38Z")
No internet access. There is only a monthly security scan by IT. No security alerts nowadays. But our Ignition app have some issues and one lead is to install the CUs. Maybe it's a wrong lead. ---
**Author:** ![bschroeder](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bschroeder/32/13260_2.png) [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\ **Post date:** [March 30, 2023, 1:13pm UTC](https://forum.inductiveautomation.com/t/sql-server-2019-and-cumulative-update-what-are-best-practices/71824/4 "2023-03-30T13:13:58Z")
Is Ignition support telling you to upgrade? ---
**Author:** ![Stephane\_Boneff](https://avatars.discourse-cdn.com/v4/letter/s/59ef9b/32.png) [@Stephane\_Boneff](https://forum.inductiveautomation.com/u/Stephane_Boneff)\ **Post date:** [March 30, 2023, 1:15pm UTC](https://forum.inductiveautomation.com/t/sql-server-2019-and-cumulative-update-what-are-best-practices/71824/5 "2023-03-30T13:15:44Z")
not yet. ---
**Author:** ![bschroeder](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bschroeder/32/13260_2.png) [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\ **Post date:** [March 30, 2023, 1:22pm UTC](https://forum.inductiveautomation.com/t/sql-server-2019-and-cumulative-update-what-are-best-practices/71824/6 "2023-03-30T13:22:07Z")
What kind of issues are you having that would lead you to update MSSQL Server? ---
**Author:** ![Stephane\_Boneff](https://avatars.discourse-cdn.com/v4/letter/s/59ef9b/32.png) [@Stephane\_Boneff](https://forum.inductiveautomation.com/u/Stephane_Boneff)\ **Post date:** [March 30, 2023, 1:49pm UTC](https://forum.inductiveautomation.com/t/sql-server-2019-and-cumulative-update-what-are-best-practices/71824/7 "2023-03-30T13:49:52Z")
On windows event, a lot of ```auto Fault bucket , type 0 Event Name: SQLException64 Response: Not available Cab Id: 0 Problem signature: P1: sqlservr.exe P2: 0.0.0.0 P3: 0000000000000000 P4: sqllang.dll ``` And about the Gateaway, one of the database (1 server for DB and 1 for the gateaway) is often at statut Faulted. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [March 30, 2023, 2:12pm UTC](https://forum.inductiveautomation.com/t/sql-server-2019-and-cumulative-update-what-are-best-practices/71824/8 "2023-03-30T14:12:36Z")
> [@Stephane\_Boneff](#): > > windows event Eeewww! I think you do indeed need these patches. Make a good **complete** backup first. ---
**Author:** ![bschroeder](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bschroeder/32/13260_2.png) [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\ **Post date:** [March 30, 2023, 2:23pm UTC](https://forum.inductiveautomation.com/t/sql-server-2019-and-cumulative-update-what-are-best-practices/71824/9 "2023-03-30T14:23:50Z")
Yep... I'm with Phil on this one as well. If SQL is causing Windows errors you are up a creek.