Top menu

Configuration - Maintaining a Rapidly Growing SQL Database

DESCRIPTION

SQL database is growing rapidly, occupying a large pile of available space.

COMMENTS

Storing shadow files in SQL Server makes the SQL database growing exponentially.

RECOMMENDATIONS

1. 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 Servers 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.