Create a Server Plan for Amazon RDS for SQL Server

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

  1. From the navigation pane, go to Manage > Plans.

    The Plans page appears.

  2. Click Create plan, and then click Server backup.

    The Create server backup plan dialog box appears.

Settings

Steps

Plan name

  1. Enter a name for the server plan.

Click Next.

Backup destinations

  1. Click Add.

    The Add backup destination dialog box appears.

  2. In Name, enter a name for the backup destination.

  3. From the Storage list, select the storage device to store the backups on.

  4. For Retention period, enter the amount of time to retain the backups.

  5. To specify additional backups, such as weekly full backups, move the Extended retention rules toggle key to the right, and then add rules.

  6. Click Save.

RPO

  1. For Backup, specify how often and when to run incremental backups.

  2. 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.

  3. For Backup window, specify when you want incremental backups to run.

  4. For Full backup window, specify when you want full backups to run.

Folders to back up

  1. To back up only some content, in Content to back up, enter the content to back up.

    By default, all content is backed up.

  2. To exclude folders or files from the backup, in Exclude - files/folders/patterns, enter the content to exclude.

  3. 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

  1. For Log backup RPO, enter how often to run log backups.

  2. To use the disk cache of the logs to the MediaAgent for backups, do the following:

    1. Move the Use disk cache for log backups toggle key to the right.

    2. 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.

Loading...