How to Manage SQL Express Database Size for Entra ID Connect?
Asked by
CleverOcelot84
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?
Answers
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.
Reply to this answer
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.
Reply to this answer
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.
Reply to this answer
Add your answer
Answers are reviewed before publication.
Related Discussions