What is stored in MSDB database SQL Server?

What is MSDB database in SQL?

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.

Are all SQL Server Agent configurations stored in the MSDB database?

The msdb database is mostly known as “the SQL Server Agent database” because it stores information of all SQL Agent jobs as their configuration and their execution history. But it is not dedicated mainly to SQL Server Agent. Features like the Service Broker or the Database Mail also stores data in msdb database.

What is stored in master database SQL Server?

The master database records all the system-level information for a SQL Server system. This includes instance-wide metadata such as logon accounts, endpoints, linked servers, and system configuration settings.

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.