How do I copy a SQL Server maintenance plan?
Answers
- Connect to SQL Server Integration Service.
- Go to Stored Packages -> MSDB -> Maintenance Plans. From there you can right click on your Maintenance Plans and select export.
- Then reimport the Maintenance Plan by importing package in another SQL Server Integration Service.
How do I check my maintenance plan?
You can view the maintenance plan in the Maintenance Plan directory under Management. The SQL Server Agent Service executes the maintenance plan; hence the schedule of the maintenance plan is listed under the Job directory. To view it, Open SSMS, expand SQL Server Agent, and expand Jobs.
How to maintain replication subscriber tables in SQL Server?
In SQL Server Management Studio, navigate to root, “Replication” folder, “Local Publications” folder and then navigate to the Publication. Right click the Publication and select “Properties” then choose the “Snapshot” option in the left pane.
How to maintain custom indexes on replication subscriber tables?
The post restore script references a SQL Server Agent Job on the subscriber SQL Server and the job will call the “prdPOSTREPLCreateIndexes” stored procedure with this logic: “exec prdPOSTREPLCreateIndexes”. The stored procedure will contain a script like the one shown below to manage the needed indexes.
What are the role requirements for SQL server replication?
Pull subscription: db_owner database role in the subscription database at the Subscriber or sysadmin server role on the Subscriber. View replication activity, errors, and history using Replication Monitor. A user cannot modify agent profiles, schedules, and so on, unless the user is a member of the sysadmin server role.
What should the authentication level be for replication?
The following table summarizes the authentication level necessary for common replication maintenance tasks: Modify or drop a Distributor, Publisher, or Subscriber. sysadmin server role on the appropriate server. Modify or drop a publication.