Veeam database size approaching limit
Problem:
My Veeam configuration was over 10,000mb approaching the MS-SQL express 10gb hard-limit.
Veeam: Configuration Database Issue The configuration database size
is approaching the limit. if this limit is exceeded, the backup server
will stop functioning.
Tentative Solution:
This worked for me, but may not be an official solution. I shrunk and rebuilt the indexes, no less than twice. I was able to shrink it half the size.
- Backup the database manually, even if you have scheduled backups. “Hamburger” Menu>Configuration Backup>Backup Now.
- Install and run SQL Server Management Server Studio.
- Connect to the local Veeam database
- Find and right click the “VeeamBackup” database, choose Tasks>Shrink>Database. Enable “Reorganize files before releasing…”>OK.
- Copy and paste the rebuild-indexes SQL script from: https://www.mssqltips.com/sqlservertip/4470/script-to-manage-sql-server-rebuilds-and-reorganize-for-index-fragmentation/ to a new local script.
- Edit the script’s SET parameters to suit your needs:
SET @reportOnly = 0;&SET @fragmentationThreshold = 5;. Execute the script. This may grow your database too large, so… - Perform #4 again!
- Perform #6 again!
- Check the size of the database (This can be done by the shrink database menu or by viewing the database properties)
