Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
| Enabled for | Public preview | General availability |
|---|---|---|
| Users by admins, makers, or analysts | - | 
Apr 1, 2025 |
Business value
Proactive offline database size management helps reduce the time and effort spent managing database size. Automatic recovery of offline databases that exceed the size limit helps to reduce downtime for point of sale (POS) devices and save the cost and time spent on manual recovery.
Feature details
Dynamics 365 Commerce customers use the offline capabilities of the Store Commerce app to maintain business continuity during network or service interruptions. Additionally, most customers using Store Commerce offline use SQL Server Express for their offline database, which has a limit on the database size.
With automatic, proactive compression and removal of large indexes, you can prevent the Store Commerce offline database from exceeding the SQL Server Express size limit. By using index compression with extension tables, you can further reduce the size of the offline database.
Automatic index compression and removal capabilities also help speed up and ease the recovery of offline databases that have exceeded the size limit.
Administrators can use the feature management workspace to enable the capabilities for their organization.