New answers tagged


This is already mentioned in the documentation at Microsoft site as below: By default, msdb uses the simple recovery model. If you use the backup and restore history tables, we recommend that you use the full recovery model for msdb. For more information, see Recovery Models (SQL Server). Notice that when SQL Server is installed or upgraded and ...


For me, large growths in MSDB are from adding and deleting the table entries within the backupset tables. Do you have a history purge or anything running?

Top 50 recent answers are included