We have setup a new SCCM secondary site which also hosts SUP SUSDB role configured on the SQL express edition which gets installed along with secondary. The problem is on monthly software update synch the SUSDB size crosses 10 GB limit & synch fails. Server is running on windows 2016 OS & SQL expression edition version is 2016.
I have 3 other SCCCM secondary sites which are running in the same way as mentioned above but the only difference is that servers are on Windows 2012 R2 OS & SQL expression edition version 2012. Here i dont see this SUSDB growth behaviour.
Is there some change when it comes to SQL express edition version 2016 & 2012 when it comes to SUSDB?
Appreciate if someone answers.