SQL server on EC2 policies

Once a protection policy is enabled for a host, immediately starts the backup seeding process to synchronize data between the host and . The initial backup seeding process creates a full SecureVault Backup of the host and saves it to Clumio.

Policies can be configured to schedule backups to occur at different frequencies throughout the year, with yearly backups retained for up to seven years. Backups can be restored at anytime during the retention period.

Point-in-Time Recovery

Point-in-Time Recovery allows you to recover a database to a specific point in time. This requires log backups. Log backups can be scheduled every 15, 30, 45 minute intervals and retained for up to 31 days.
Point-in-Time recovery is only available for SQL Server databases using the Full Recovery model, which includes log backups. It is not available for databases using the Simple Recovery model. The recovery model is set by your MS SQL database admin (DBA).

Full Database Recovery

A full database backup allows you to recover a database to the time the last backup finished or to a point in time provided backup is complete to Up to four scheduled backup policy frequencies can be configured: hourly, daily, monthly and yearly.

  • Hourly: Enable the first check box to generate backups every few hours. After the initial seeding, subsequent backups are generated every day at 12:00 AM UTC and then at the frequency specified. For example, if a policy has been configured to take backups every 7 hours, backups will always occur at 12:00 AM, 7:00 AM, 2:00 PM, and 9:00 PM every day. Each backup is retained for the specified number of days. If you are using hourly backups, the Backup Window option is not supported.
  • Daily: Enable the second check box to generate backups every few days. Daily backups are enabled by default and cannot be disabled. After the initial seeding, subsequent backups are generated at the frequency specified, calculated from the first of every month. A backup is also taken on the 1st of every month. For example, if a policy has been configured to take backups every 10 days, backups will always occur on the 1st, 11th, 21st, and 31st days of each month. Each backup is taken at 12:00 AM UTC and retained for the specified number of days.
  • Monthly: Enable the third check box to generate backups every few months. After the initial seeding, subsequent backups are generated at the frequency specified, calculated from the 1st of January every year. A backup is also taken on January 1st each year. For example, if a policy has been configured to take backups every 5 months, backups will always occur on January 1st, June 1st, and November 1st of each year. Each backup is taken at 12:00 AM UTC and retained for the specified number of months.
  • Yearly: Enable the fourth check box to generate backups once per year. When enabled, a backup is generated on the first of the year, and then again on the first of the following year. Each backup is taken at 12:00 AM UTC and retained for the specified number of years. If multiple backups are generated on the same day, only one copy is retained. For example, if monthly and yearly backups are generated on January 1st, only one copy is saved.

On days that multiple backups are generated, only one copy is saved for each of those instances. For more information about backup policy settings, see the section Recurring Backups in Policies.

Advanced Policy Options

The Advanced tab provides additional options for full backups of Availability Group databases. These options do not apply to seeding backups, which are always taken from the primary replica.

Preferred Replica—The preferred replica for MS SQL database backups. You can choose either Primary or Sync Secondary. Clumio tries to back up data from this (preferred) replica first. If this replica is unavailable, Clumio switches to the alternative replica.

Alternative Replica—The alternative replica for MS SQL database backups if the preferred replica is unavailable. You can choose Primary, Sync Secondary, or Stop. Clumio tries to back up data from the preferred replica first. If the preferred replica is unavailable, Clumio switches to this (alternative) replica.

If set to Stop, then Clumio does not attempt to switch to this replica if the preferred replica is unavailable and the backup task fails.

Create MS SQL on EC2 SecureVault Backup policy

  1. Select Policies. The Policies window displays.
  2. Click Create. The Create Policy dialog displays.
  3. In the Policy Name field, type a name for the new policy. The policy name is a global name with the ability to define different policies for each asset type. For example, HR-Resources-Master.
  4. Click the dropdown next to AWS, and click the MS SQL on EC2 slider to enable Microsoft SQL databases. The Basic tab displays by default.
  5. In the Point in Time Recovery section, set the log backup schedule. Point in time recovery is available for the Full Recovery model only.
  6. In the Full Database Recovery section, enable and set up to four separate backup and retention schedules. Daily backups are enabled by default. Each Microsoft SQL policy can include up to four backup frequencies.
  7. In the Database Backup Window section, select the Specify a backup window check box and specify the time zone and start and end times of the backup window. When the backup window is enabled, backups will only occur between the stated start and end times. In-progress backups that exceed the window end time will finish through to completion. You cannot define a backup window if you enabled backups to occur in hourly increments. If you do not specify a window, the backup window will be for 24 hours.
  8. If you specified a backup window, optionally select the Honor backup window for backup seeding check box to schedule backup seeding jobs to also run within the specified backup window only. If not selected, backup seeding will occur as soon as the policy is applied to a SQL asset.
  9. Click Create Policy. Select Policies to see the newly created policy. After the policy is created, use it to protect Microsoft SQL assets.

Create MS SQL on EC2 backup policy for Availability Groups

On the Advanced tab of the Create policy dialog box, choose the preferred replica and the alternate replica for availability group database backups. These options do not apply to the seeding backup, which is always taken from the primary replica.

  1. From the first dropdown, choose the preferred replica. The options are Primary or Sync Secondary. This is the replica that Clumio will try to back up data from first.
  2. From the second dropdown, choose the alternate replica. This is the replica from which Clumio will try to back up data, if the preferred replica is unavailable. The options depend on the choice you make for the preferred replica. Choose Stop if you do not want Clumio to attempt a backup from an alternate replica.
  3. Click Create Policy. A confirmation message displays.