HP 7450 Application Software Suite Microsoft SQL Media LTU manual Automating Tasks

Page 34

1.In the node tree pane, right-click the instance or database for which you want to create a virtual copy, and select one of the following:

Create Virtual Copy

Create Remote Virtual Copy

2.Click Next in the Create Virtual Copy dialog box.

The Task Scheduler appears. For more information on using the Task Scheduler, see “Scheduling Automated Tasks with Task Scheduler” (page 34).

Automating Tasks

You can use the Task Scheduler to schedule Recovery Manager to automatically create virtual copies, remote virtual copies, and one-click backup.

You can use Task Manager to manage all your scheduled virtual copies and backups for all Recovery Manager products running on your servers.

Scheduling Automated Tasks with Task Scheduler

To schedule automatic virtual copies and backups:

1.Set up a virtual copy creation or backup creation task as desired. For more information, see:

“Scheduling Automatic Virtual Copies” (page 33)

“Scheduling Automatic Backups of an Instance or Database” (page 37)

2.In the Task Scheduler dialog box, check the Schedule this task checkbox.

3.In the Password text box, enter a local user password for the backup server.

4.In the Password (confirm) text box, re-enter the password.

5.From the Start Time drop-down list, select the hour at which you want Recovery Manager to start creating automatic virtual copies.

6.To specify the frequency with which the automatic virtual copies are to be created, select the appropriate radio button in the left pane of the Schedule Pattern area.

The right pane of the Schedule Pattern area displays a calendar with which you can specify exactly when Recovery Manager is to automatically create virtual copies. The type of calendar displayed depends on the frequency of the automatic virtual copies selected in the left pane of the Schedule Pattern area.

Once - Schedules one automated virtual copy.

In the right pane, select the month and year in which to create the virtual copy from the drop-down list above the calendar view, then select the day on the calendar.

Hourly - Schedules automated virtual copies multiple times a day at the interval you specify.

From the drop-down list in the right pane, select the number of hours you want to pass between automated copies.

Daily - Schedules automated virtual copies on a daily basis at the interval you specify.

To schedule copies at regular intervals during the week, select the radio button for Every day in the right pane and enter the number of days between copies.

To schedule copies on a daily basis, select the radio button for Every weekday in the right pane and, in the Start Date text box, enter the start date or use the Calendar icon to select a start date.

34 Using the Recovery Manager GUI

Image 34
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 MessagesRelated Documents IntroductionTypographical 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 Upgrading to Recovery Manager 4.2.0 for SQL Installation and DeinstallationPre-Installation Steps Installing Recovery Manager Verifying the Installation Understanding the RegistryDeinstalling Recovery Manager Configuring the SQL Database Configuring Recovery ManagerConfiguring Recovery Manager Configuring Mount Functionality Configuring Recovery Manager PoliciesGrouping 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 How Recovery Manager Policies Work Setting the Recovery Manager PolicyUnregistering 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 ManagerUnmounting a Virtual Copy Manually Creating Backups at the Instance or Database LevelBacking Up a Virtual Copy Scheduling Automatic Backups of an Instance or Database Restoring Instances, Databases, and Volumes Removing a Backup from the RepositoryCreating 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 DescriptionsRecovery Manager for SQL Server Command Line Interface CLI Using the Recovery Manager 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 Database virtual copy limit RMSql policyInstance virtual copy limit RMSql policy -n 5 -s SQL server Retain timehHdDRMSql 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 -a alter location -r RMSql repositoryRMSql repository -a d\3parvv SystemDrive\3parSnapshot by default RMSql restoreAltLocation 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