![]() Usually, as more databases the MSSQL instance has, the more disk space will be needed by the msdb database. Service Broker and Database Mail) will be used by the MSSQL instance as well the number of jobs executions that will be stored and also the number of backups and restores that will occur in a regular basis. Msdb database disk space requirements depend on what features (e.g. Used to work with a Multiserver Environment.īelow is an image showing all the default database roles for the msdb database after a new MSSQL instance has been installed: Only members of one of these database roles can use SQL Server Agent. Only members of these database roles can administer and use registered server groups. Only members of this database role are able to manage a SQL Server instance Policies. Used to implement the Data Collector Security. Only members of this database role are able to work with SSIS packages. Only members of this database role are able to send emails through SQL Server. Besides the members of the sysadmin fixed server role that is able to perform any operation in the MSSQL instance, only members of the following database roles are able to execute the related operations (for better understanding I have grouped these database roles): Group name One particularity of the msdb is that is the only system database that has pre-defined database roles besides the regular fixed database roles ones.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |