HP 10400 Application Software Suite for Microsoft SQL Media LTU Setting Recovery Manager Policies

Page 30

Retention Time Restrictions

If you have a Virtual Lock license, you can set a retention time for virtual copies. The instance or database and the associated virtual copies created within the retention period cannot be removed during the retention period.

When setting a retention time, keep in mind the following restrictions:

You must have a Virtual Lock license to set retention times.

The minimum retention time is 1 hour; the maximum is 43,800 hours/1,825 days (5 years). The default maximum retention time is 336 hours (14 days).

You can set a retention time for both numeric-based and expiration-based policies.

The retention time cannot exceed the default maximum retention time set for the Storage Server.

The retention time cannot be longer than the expiration time (if the policy is expiration-based).

If you create a remote virtual copy and Remote Copy is set up in asynchronous periodic mode, the retention time is applied to the remote copy on the Remote Copy backup server only. If Remote Copy is set up in synchronous mode, the retention time is applied to both the remote copy on the Remote Copy backup server and the virtual copy on the primary server.

After the retention time is set, it can be increased, but it cannot be removed or reduced.

Setting Recovery Manager Policies

1.In the node tree pane, right-click the instance you want to configure and select Policy.

2.Depending on whether you want to set a maximum number of copies or you want to set an expiration time frame, do the following in the Policy Setup dialog box:

To set:

Maximum number of virtual copies

Expiration time frame for virtual copies

Follow these steps:

1.Select the Numeric radio button.

2.In the Maximum Instance level Virtual Copies and Maximum Database level Virtual Copies text boxes, enter the desired maximum for each as a number between 1 and 500.

3.To remove the oldest virtual copy each time a copy above the maximum is created, check the Remove the oldest Virtual Copies checkbox.

To keep the oldest virtual copy (and therefore prevent new virtual copies from being made after the maximum number is reached), uncheck the Remove the oldest Virtual Copies checkbox.

1.Select the Expiration radio button.

2.In the Expire In text box, enter the number of hours or days after which you want Recovery Manager to remove each virtual copy. The maximum expiration period is 43800 hours/1825 days (5 years).

3.In the drop-down list, select either Hours or Days.

3.To modify the default retention time for the instance and its virtual copies, enter the number of hours or days you want to keep the instance and its contents.

The minimum retention period is 1 hour; the maximum is 43,800 hours/1,825 days (5 years). For more information about retention time restrictions, see “How Recovery Manager Policies Work” (page 29).

30 Using the Recovery Manager GUI

Image 30
Contents User’s Guide Documentation Contents Configuring Backup Software Using the Recovery Manager GUIRemote Copy for Recovery Manager Using the Recovery Manager CLIRecovery for Microsoft SQL Server Troubleshooting Event MessagesIntroduction Related DocumentsTypographical Conventions Advisories Windows Server Requirements Overview of Recovery ManagerSystem Requirements Additional System RequirementsRecovery Manager Requirements Running Recovery Manager on a Japanese OSFeatures Supported Features Not Supported Microsoft Volume Shadow Copy ServiceSupported VSS Components How HP 3PAR VSS Software Works with Microsoft SQL ServerRecovery Manager Layout Overview of Recovery Manager Installation and Deinstallation Upgrading to Recovery Manager 4.2.0 for SQLPre-Installation Steps Installing Recovery Manager Verifying the Installation Understanding the RegistryDeinstalling Recovery Manager Configuring Recovery Manager Configuring the SQL DatabaseConfiguring Recovery Manager Configuring Recovery Manager Policies Configuring Mount FunctionalityGrouping Volumes into Autonomic Groups Testing SQL Connectivity Volume SetsConfiguring the Host Computer and the HP 3PAR Storage System Troubleshooting SQL ConnectivityFormatting Partitions on a New HP 3PAR Vlun Windows ServerOverview Configuring Backup SoftwareSetting Up Symantec NetBackup Before You BeginSetting Up HP Data Protector Cell Manager Access Configuring HP Data ProtectorSetting Up the HP Data Protector Backup Specification RequirementsUsing HP Data Protector Using Your Backup SoftwareUsing Symantec NetBackup RM installation location\log\nbulog\databasetimestamp.logOpening the Recovery Manager GUI Using the Recovery Manager GUIOverview of the Recovery Manager GUI Closing the Recovery Manager GUIUpdating Registration after Server Modification Setting the Recovery Manager Policy How Recovery Manager Policies WorkUnregistering a SQL Server Instance Setting Recovery Manager Policies Retention Time RestrictionsConfiguring Email Notifications Modifying the Policy for a Virtual CopyHow Virtual Copy Creation Works Deleting Email ConfigurationsCreating Virtual Copies Manually Creating a Virtual CopyCreating Remote Virtual Copies Scheduling Automatic Virtual CopiesAutomating Tasks Scheduling Automated Tasks with Task SchedulerMounting a Virtual Copy Managing Automated Tasks with Task ManagerManually Creating Backups at the Instance or Database Level Unmounting a Virtual CopyBacking Up a Virtual Copy Scheduling Automatic Backups of an Instance or Database Removing a Backup from the Repository Restoring Instances, Databases, and VolumesCreating a Backup of a Virtual Copy Restoring an Instance or Database with Volume Restore Restoring an Instance or Database with File Copy RestoreRestoring an Instance or Database from a Backup Analyzing and Synchronizing the RepositoryRemoving a Virtual Copy Viewing Event Message DescriptionsUsing the Recovery Manager CLI Recovery Manager for SQL Server Command Line Interface CLIRecovery Manager Commands SQL Server RMSql analyzeRMSql analyze -s SQL server -sync -f SyncRMSql backup Example RMSql create RMSql create -s SQLServer -d test RMSql create -s SQLVirtualServer -d testUsing the Recovery Manager CLI RMSql deletebackup RMSql deletebackup -s server1 -d db1 -tRMSql display RMSql display -s server1RMSql listbackup RMSql mount RMSql policy Database virtual copy limitInstance virtual copy limit Retain timehHdD RMSql policy -n 5 -s SQL serverRMSql policy -exp 30d -s SQL server Recovery Manager Commands RMSql portconfig -n RMSql portconfigRMSql portconfig -n number -s WindowsHost RMSql portconfig -n 9999 -s WindowsHostRMSql remove RMSql remove -s SQL server -t timestampWindowsHost RMSql reportRMSql report -s WindowsHost -output OutputDirectory RMSql report -s Grampus -output c\MyReportRMSql repository RMSql repository -a alter location -rRMSql repository -a d\3parvv RMSql restore SystemDrive\3parSnapshot by defaultAltLocation RMSql restore -snap -s server1 -d testdb -t NorecoveryRMSql restore -s server1 -d testdb -t SnapUsing the Recovery Manager CLI RMSql setvc RMSql setvc -s server1 -t 020409162103 -exp 2h RMSql setvc -s server1 -t 020409162103 -exp 30dRMSql timeconfig -prt RMSql timeconfigRMSql timeconfig RMSql timeconfig -bktRMSql unmount Running Recovery Manager as a Scheduled JobScheduling an Automated Task in Windows RMSql unmount -s SQL server -t timestampFor example Recovering Data with HP 3PAR Recovery Manager Recovery for Microsoft SQL ServerMicrosoft SQL Server Recovery Models Preparing for the Recovery ProcessRecovering All Data with Point-of-Failure Recovery Performing a Point-of-Failure Recovery Recovering All Data with Point-of-Failure Recovery Remote Copy for Recovery Manager How Remote Copy WorksSetting Up Remote Copy Support for Remote Copy Modes and Policies Setting Up Remote Copy Volume GroupsSetting Up a Remote Copy Volume Group for Databases Support for GeoCluster for Microsoft WindowsRecovering a SQL Database from a Remote Copy Backup Server Setting Up a Remote Copy Volume Group for InstancesServer Virtualization Environments VMWare and EgeneraTroubleshooting Installpath\NetBackup\db\ Installpath\NetBackup\db\altnames\No.RestrictionsEvent Messages Event ID Event ID Event ID Event ID Provcfg conn -syncrc Yes