NOTE: this operation can cause a significant workload on the database and growth of the database transaction log. Make sure you do not have mission-critical databases on this server.
- Shrink the database to reduce its size.
Note that SQL script above only purges records, it does not reduce the database file size-on-disk.
- The script provided above purges records of the oldest month stored in the database. If you need to reduce the database further or clean more records (2, 3, or more months), you will need to repeat steps 3 & 4 several times.
- Change the Startup Type of the Veeam ONE Monitoring Service and Veeam ONE Reporting Service back to Automatic, and start them.
NOTE: If you decide to continue using SQL Server Express Edition, it is recommended that you adjust the Retention policy settings to store less data.