1.What is MSDB Database in Sql Server?
Main purpose of msdb
system database is used to store system activities like jobs, mail, service broker, etc. It is used by SQL Server Agent to schedule jobs, alerts, notification and other features such as Service Broker, Database Mail, SSIS package storage.
The below are the restrictions/operations that cannot
be performed on the msdb database
o Changing collation. The default collation is the server collation.
o Dropping the database.
o Dropping the guest user from the database.
o Enabling change data capture.
o Participating in database mirroring.
o Removing the primary filegroup, primary data file, or log file.
o Renaming the database or primary filegroup.
o Setting the database to OFFLINE
o Setting the primary filegroup to READ_ONLYJayakumars, if this helps please login to Mark As Answer. | Alert Moderator