This elevation of privilege can occur because these roles can modify Integration Services packages these packages can be executed by SQL Server using the sysadmin security context of SQL Server Agent. Members of the db_ssisadmin and dc_admin roles may be able to elevate their privileges to sysadmin. You must create and maintain the multiserver maintenance plans on the master server. To create a multiserver maintenance plan, you must configure a multiserver environment with one master server, and one or more target servers. This allows you to perform various database administration tasks, including backups, database integrity checks, or database statistics updates, at specified intervals. The Maintenance Plan Wizard creates a maintenance plan that Microsoft SQL Server Agent can run on a regular basis. This topic describes how to create a single or multiserver maintenance plan using the Maintenance Plan Wizard in SQL Server. Applies to: SQL Server (all supported versions)
0 Comments
Leave a Reply. |