Create a Server Plan for Amazon RDS for SQL Server

Updated

On this page

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. Choose whether to create a new plan or use a base plan.

  2. In Plan name, enter a name for the server plan.

Backup destinations

  1. Click Add copy.

    The Add copy dialog box appears.

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

  3. From the Storage list, select the storage to use for the backups.

    If you selected storage that uses Distributed Storage, the Optimize for instant clone toggle key appears. By default, this setting is turned on to allow the associated Distributed Storage to optimize backups for clones, using Copy Data Management. To turn off the setting, move the Optimize for instant clone toggle key to the left.

    The setting does not apply to HyperScale solutions that use Distributed Storage.

  4. To specify the start time for backups on a specific date and later, move the Backups On and After toggle key to the right.

  5. For Retention rules, enter the amount of time to retain the backups.

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

  7. Click Save.

  8. To add additional regions to the backup destination, move the Multi-region toggle key to the right, and then select the regions.

    You can also add more regions and associate the storage copy to the region.

RPO

  1. For Backup frequency, click Add.

    The Add backup frequency dialog box appears.

    1. From the Backup type list, select the backup type, and from the for list, select All agents or Databases.

    2. Specify the frequency of the backup.

    3. To specify the client time zone or to add exceptions, move the Advanced toggle key to the right.

      • From the time zone list, select the time zone according to which the backups must run.

      • To add exceptions when backups must not run, click Exceptions and add exceptions for any day or week of a month.

        These exceptions will repeat every month.

  2. For Backup window, specify when you want incremental and differential backups to run.

  3. 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, move the Back up system state toggle key to the right.

    • 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 Windows Server's VSS (Volume Shadow Copy Service) to back up the system state, select the Use VSS for system state check box.

Database options

  1. Under Database options, do the following:

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

    2. To automatically back up the database logs to the MediaAgent cache, do the following:

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

      2. For Commit, enter how often to commit the logs to the CommServe computer.

        Disk caching of database logs applies to the following: Informix, Microsoft SQL Server on Windows, Oracle, Oracle RAC, and SAP HANA.

Override restrictions

  • Leave the Allow plan to be overridden check box cleared.