Create a Service Plan for a SQL database:
1. On the AppSync console, select Copy Management.
2. From the Copies drop-down, select Service Plan.
3. From the Select Application drop-down, select Microsoft SQL Server to display the service plans page.
4. Click CREATE SERVICE PLAN.
5. Click SELECT TEMPLATE and select one of the following options to use as the template to create the service plan and click OK:
Bronze
Gold
Silver
NOTE: User-created service plans are listed in this page. You can also use user-created service plans as templates.
6. In the Define the copy page, configure values for the following options:
a. Specify a name for the service plan in the Service Plan Name field.
b. You can edit the description for the service plan in the Description field.
c. Configure the Service Plan State option to either Enabled or Disabled.
d. Configure the Mount Copy option to No, Yes, Yes - Keep it mounted(Previous copy will be unmounted), or Yes - Mount the copy, but after the post mount scripts run, unmount the copy.
e. Configure the Immutable Copy option is set to No by default. You must change this option to Yes, to create immutable copies of the application. Once you select Yes, the Always Keep _____ Copies option will be disabled, and you must also specify the retention days in Keep Copy for _____ Days.
f. In the Retention field, you can configure the following settings.
1. Always Keep _____ Copies to specify the number of copies to be retained. Older copies will get expired after the copy count reaches the mentioned value.
2. Keep Copy for _____ Days to specify the number of days to retain the copies. AppSync will expire the copy after it crosses the Time to Live period.
Select the Include RecoverPoint copies in expiration rotation policy, if you want to include RecoverPoint copies in the expiration rotation policy.
g. In the Advanced plan settings field, specify the number of sql databases.
7. Click NEXT.
8. In the Create the Copy page, do the following:
a. Configure the SQL Server Backup Type settings to either Full, Copy, Non-VDI, or Crash-Consistent.
b. Configure the Retry Count and Retry Interval settings under Advanced Plan Settings - VSS Retry Options.
c. Select the Skip non-readable secondary database protection option if there are secondary availability group databases in non-readable state that should be skipped from protection.
d. Select the Wait for VMAX3/PowerMAX clone sync to complete option if you want to wait for VMAX3/PowerMAX clone sync to complete. This applies to VMAX3/PowerMAX only.
e. In the Select an Array section, select the preferred array from the list.
NOTE: This is applicable only for SRDF/ Metro.
f. In the Select Storage Groups to be used for VMAX-3 Array(s) section, select the preferred storage groups.
g. In the Select the cluster and arrays in preferred order for metro node | VPLEX configuration section, you can drag and drop the arrays to change array preference.
h. Configure the Copy Priority to settings by dragging and dropping the Snapshot, Clone, and Bookmark options in the required order.
9. Click NEXT.
10. In the Scripts page select the pre-copy or post-copy scripts that you want to run and configure the following fields:
a. Full Path to Script
b. Script Parameters
c. Run as User Name
d. Password
11. Click NEXT.
12. In the Schedule/Run page, select one of the following scheduling options:
OnDemand - Creates a service plan when you click Finish on this wizard.
Schedule - Creates a service plan based on the specified recurrence type. Configure the following fields to schedule the creation of a service plan.
In the Recurrence Type drop-down list, select the desired frequency of creation. Options are:
a. At frequency of...: Run at a frequency of 30 minutes or 1, 2, 3, 4, 6, 8, 12, or 24 hours. Minutes after the hour are set in 1 minute interval. Default is 24 hours.
b. Every day at...: Run every day at certain times: Select different times during the day. Minutes after the hour are set in 1 minute intervals. There is no default selected.
c. On selected days of the week: Run at a certain time on selected days of the week. One or more days of the week (up to all seven days) can be selected. There is no default day of the week selected. Default time of day is 12:00 AM.
d. On specified days of the month: Run at a certain time on selected days of the month. Select one or more days of the month (up to all days). Select one time of day. Available times are at 1 minute interval. Default is the first day of the month. Select Last to select the last day of the month.
e. In the Every drop-down list, select the desired time to create the service plan.
f. Select the Enable Recovery Point Objective to enable the RecoveryPoint objective.
g. In the RPO drop-down list, select the desired time.
13. Click NEXT.
14. Review the Service Plan creation settings, and click FINISH.
NOTE: To edit an already created service plan, select the service plan and click EDIT in the Service Plan Details pane. Repeat steps 6 to 14.
