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_ONLY
Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif
Jayakumars, if this helps please login to Mark As Answer. | Alert Moderator