Scenario You need to schedule full, differential and t-log database backups on several servers and automate backup cleanup according to your company’s retention policy. |
You are going to create a maintenance plan on one SQL Server instance and then simply copy it to the other server instances.
To automate backups on server instances
Click and select User databases (excluding master, model, msdb).
NOTE: This scenario describes how to back up all user databases. Similarly, you can configure maintenance plans to back up system databases and databases matching wildcard or regular expressions.
Double-click every subplan in the plan. Enter the name and description. Click to set schedule properties. Each subplan should have its own reoccurring schedule. For example,
When you are done editing the subplan properties, select Enabled and click Ok.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Termini di utilizzo Privacy Cookie Preference Center