Can I shrink MSDB database?

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 my MSDB database so large?

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 make my database smaller?

Shrink a database1In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.2Expand Databases, and then right-click the database that you want to shrink.3Point to Tasks, point to Shrink, and then select Database. Database. ... 4Select OK.Shrink a Database - SQL Server | Microsoft Docs

How do I clean up 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.

What happens when Msdb DB is down?

If Msdb is down, then your sql server agent wont start, hence the jobs will not even run in the first place.

Expert · Answer