I'm having an issue where my local SQL Express database keeps exceeding the 10GB limit. Even though the total objects in my tenant are less than 25% of the 100K object limit for SQL Express, the database size keeps growing. What can I do to prevent the SQL Express database from getting so large in relation to the number of objects being synced?
3 Answers
I’m not sure what’s preventing you from using a full SQL database locally on each server. The process we use across multiple data centers works well, and our local databases can handle substantial sizes. Staging servers ensure that all changes from the primary servers are replicated without needing to connect to remote databases, helping you achieve better performance.
One option you can consider is shortening the retention period for your run history data, although this might just be a temporary solution. Ultimately, you might need to migrate to a full SQL database if the size issues continue.
I recommend checking out Cloud Connect Sync. If you're not dealing with a lot of large groups, it should simplify things quite a bit. For hybrid setups, you might want to keep using Entra Connect for device sync while transitioning user sync to Entra Cloud Connect.
Related Questions
Can't Load PhpMyadmin On After Server Update
Redirect www to non-www in Apache Conf
How To Check If Your SSL Cert Is SHA 1
Windows TrackPad Gestures