Configuration - Maintaining a Rapidly Growing SQL Database
DESCRIPTIONSQL database is growing rapidly, occupying a large pile of available space.
COMMENTSStoring shadow files in SQL Server makes the SQL database growing exponentially.
RECOMMENDATIONS1. Store data on the disk, so only links to binary data and some additional information is stored in SQL database. To do so, uncheck the ‘Store shadow files on SQL Server’ flag in DeviceLock Enterprise Server’s options.
2. In case it is preferable to store data in SQL Server (not recommended), increase the maximum file size parameter for the transaction log of the database specified in Database name.