Can I shrink Msdb?

Question

Can you shrink the database and transaction log for the MSDB database? The data and log files for the MSDB database can be resized. Like any other database, this isn't an operation that should be needed very often. 31 мар. 2020 г.

Why is Msdb so big?

MSDB stores backup and restore history. Imagine a server with 2000 databases that takes a log backup of all of them every 15 minutes. That's 192,000 new rows into the backupset and backupmediaset tables EVERY DAY! Keeping a few weeks or months of history can cause the size of MSDB to get very large.

How do I rebuild Msdb?

Using the Windows Notepad, open the instmsdb. out file and check the output for any errors. Re-apply any hotfix installed on the instance. Recreate the user content stored in the msdb database, such as jobs, alert, etc.

What is Msdb used for?

The msdb database is used by SQL Server Agent for scheduling alerts and jobs and by other features such as SQL Server Management Studio, Service Broker and Database Mail. For example, SQL Server automatically maintains a complete online backup-and-restore history within tables in msdb.

How do I clean my MSDB database?

You could use the database maintenance plan – Cleanup History task and configure it to clean up backup tables automatically. Select the Cleanup History task in the maintenance plan and click Next. On the next page, select the value for the “Remove historical data older than” parameter.

Expert · Answer