MSDB Database

MSDB database stores all sql server agent related information. It contains all information about Jobs, Alerts, backup details, replication tables, log shipping tables, database maintenance plans and database mail details.

·         The max size of ‘msdb’ log file is 2 TB. (SQL 2k5/2k8).

·         This DB cannot be kept in Emergency mode.

·         This DB cannot be removed directly from SSMS as we shouldn't not detach any of system DB’s directly.   We have to do it from cmd prompt incase needed.

Ref:

http://technet.microsoft.com/en-us/library/ms187112(SQL.100).aspx

To rebuild msdb:

http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/06/06/619304.aspx

http://msdn.microsoft.com/en-us/library/ms345408.aspx