Create a server plan that you can use for Amazon RDS for SQL Server. If you already have a server plan that you can use, you can skip this step.
Procedure
-
From the navigation pane, go to Manage > Plans.
The Plans page appears.
-
Click Create plan, and then click Server backup.
The Create server backup plan dialog box appears.
|
Settings
|
Steps
|
|
Plan name
|
- Enter a name for the server plan.
Click Next.
|
|
Backup destinations
|
-
Click Add.
The Add backup destination dialog box appears.
-
In Name, enter a name for the backup destination.
-
From the Storage list, select the storage device to store the backups on.
-
For Retention period, enter the amount of time to retain the backups.
-
To specify additional backups, such as weekly full backups, move the Extended retention rules toggle key to the right, and then add rules.
-
Click Save.
|
|
RPO
|
-
For Backup, specify how often and when to run incremental backups.
-
To run full backups, move the Add full backup toggle key to the right, and then specify how often and when to run full backups.
-
For Backup window, specify when you want incremental backups to run.
-
For Full backup window, specify when you want full backups to run.
|
|
Folders to back up
|
-
To back up only some content, in Content to back up, enter the content to back up.
By default, all content is backed up.
-
To exclude folders or files from the backup, in Exclude - files/folders/patterns, enter the content to exclude.
-
Specify whether to include the system state in backups:
-
To include the system state in all backups, select the Back up system state check box.
-
To include the system state only in full backups, select the Back up system state check box and the Only with full backup check box.
-
To use VSS (Volume Snapshot Service, also called Shadow Copy) to back up the system state, select the Use VSS for system state check box.
|
|
Database options
|
-
For Log backup RPO, enter how often to run log backups.
-
To use the disk cache of the logs to the MediaAgent for backups, do the following:
-
Move the Use disk cache for log backups toggle key to the right.
-
For Commit every, enter how often to commit the logs to the CommServe computer.
Disk caching of database logs applies to the following agents: Microsoft SQL Server on Windows, Oracle (but not Oracle RAC), and SAP HANA.
|
|
Override restrictions
|
- Leave the Allow plan to be overridden check box cleared.
|