What is true about Msdb?

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.

What are the extra roles that are available in Msdb?

Group nameDatabase role nameData Collectordc_operator dc_admin dc_proxyPolicy-Based ManagementPolicyAdministratorRoleServer GroupServerGroupAdministratorRole ServerGroupReaderRoleSQL Server Agent Fixed Database RolesSQLAgentUserRole SQLAgentReaderRole SQLAgentOperatorRole

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.

Where is the MSDB database located?

The msdb database file (msdb. mdf) and msdb log files (msdb. ldf) are located in the Program Files\Microsoft SQL Server\Mssql\Data directory. Due to the amount of configuration information stored in the msdb database, the database should be routinely backed up.