HP Application Software Suite for Microsoft SQL manual Mounting a Virtual Copy

Page 35

Weekly - Schedules automated virtual copies by the day of the week.

In the right pane, enter the number of weeks you want to pass between automated copies and check the checkbox for each day of the week on which a virtual copy is to be created.

Monthly - Schedules automated virtual copies by day or date of the specified months.

Day - To schedule copies on a specific date at a specific monthly interval, enter the date (as a number) and the number of months between copies. For example, if you enter Day 24 of every 2 months, Recovery Manager automatically creates a virtual copy every 24th day of every other month.

The (first Sunday) - To schedule copies on a specific day and in specific months, use the drop-down lists to specify the day and the checkboxes to specify the exact months to create copies. For example, if you enter The first Sunday of every month and check the Jan, Apr, and Aug checkboxes, Recovery Manager automatically creates a virtual copy the first Sunday in January, the first Sunday in April, and the first Sunday in August.

7.Click Finish.

You can use the Task Manager to edit, run, delete, and view details of scheduled tasks. For more information, see “Managing Automated Tasks with Task Manager” (page 35).

NOTE: All tasks created in Task Scheduler and their associated script files are not automatically removed when you deinstall Recovery Manager. Retention of tasks allows you to upgrade your version of Recovery Manager without losing scheduling information.

Managing Automated Tasks with Task Manager

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

1.In the node tree pane, ensure a node is selected.

2.Select Scheduled TasksTask Manager.

Recovery Manager lists all scheduled tasks in the Task Name column of the Task Manager dialog box, prefixing Recovery Manager for SQL Server tasks with RMS.

3.To manage a scheduled task, select it and click one of the following buttons:

Edit - Opens the Task Scheduler, with which you can modify the task. To save your changes, you must enter your password. For more information, see “Scheduling Automatic Virtual Copies” (page 33).

Detail - Displays task information in the Task Detail dialog box.

Delete - Deletes the task and its associated script file.

Edit Script - Displays the task script and enables you to modify it.

Run Now - Performs the selected task immediately (in addition to its scheduled run time).

Refresh - Updates the list and status of scheduled tasks.

4.To exit the Task Manager dialog box, click OK.

Mounting a Virtual Copy

You can use Recovery Manager to mount a virtual copy at the instance or database level.

1.In the node tree pane, right-click the timestamp for the virtual copy you want to mount and select Mount.

2.In the Mount Virtual Copy dialog box, ensure the Target Server text box displays the server name to which you want the virtual copy mounted.

3.In the Mount Point Only text box, select the mount point.

Mounting a Virtual Copy 35

Image 35
Contents User’s Guide Documentation Contents Using the Recovery Manager GUI Configuring Backup SoftwareTroubleshooting Event Messages Using the Recovery Manager CLIRecovery for Microsoft SQL Server Remote Copy for Recovery ManagerTypographical Conventions IntroductionRelated Documents Advisories Additional System Requirements Overview of Recovery ManagerSystem Requirements Windows Server RequirementsRunning Recovery Manager on a Japanese OS Recovery Manager RequirementsFeatures Supported Microsoft Volume Shadow Copy Service Features Not SupportedHow HP 3PAR VSS Software Works with Microsoft SQL Server Supported VSS ComponentsRecovery Manager Layout Overview of Recovery Manager Pre-Installation Steps Installation and DeinstallationUpgrading to Recovery Manager 4.2.0 for SQL Installing Recovery Manager Understanding the Registry Verifying the InstallationDeinstalling Recovery Manager Configuring Recovery Manager Configuring Recovery ManagerConfiguring the SQL Database Grouping Volumes into Autonomic Groups Configuring Recovery Manager PoliciesConfiguring Mount Functionality Volume Sets Testing SQL ConnectivityTroubleshooting SQL Connectivity Configuring the Host Computer and the HP 3PAR Storage SystemWindows Server Formatting Partitions on a New HP 3PAR VlunBefore You Begin Configuring Backup SoftwareSetting Up Symantec NetBackup OverviewRequirements Configuring HP Data ProtectorSetting Up the HP Data Protector Backup Specification Setting Up HP Data Protector Cell Manager AccessRM installation location\log\nbulog\databasetimestamp.log Using Your Backup SoftwareUsing Symantec NetBackup Using HP Data ProtectorClosing the Recovery Manager GUI Using the Recovery Manager GUIOverview of the Recovery Manager GUI Opening the Recovery Manager GUIUpdating Registration after Server Modification Unregistering a SQL Server Instance Setting the Recovery Manager PolicyHow Recovery Manager Policies Work Retention Time Restrictions Setting Recovery Manager PoliciesModifying the Policy for a Virtual Copy Configuring Email NotificationsManually Creating a Virtual Copy Deleting Email ConfigurationsCreating Virtual Copies How Virtual Copy Creation WorksScheduling Automatic Virtual Copies Creating Remote Virtual CopiesScheduling Automated Tasks with Task Scheduler Automating TasksManaging Automated Tasks with Task Manager Mounting a Virtual CopyBacking Up a Virtual Copy Manually Creating Backups at the Instance or Database LevelUnmounting a Virtual Copy Scheduling Automatic Backups of an Instance or Database Creating a Backup of a Virtual Copy Removing a Backup from the RepositoryRestoring Instances, Databases, and Volumes Restoring an Instance or Database with File Copy Restore Restoring an Instance or Database with Volume RestoreAnalyzing and Synchronizing the Repository Restoring an Instance or Database from a BackupViewing Event Message Descriptions Removing a Virtual CopyRecovery Manager Commands Using the Recovery Manager CLIRecovery Manager for SQL Server Command Line Interface CLI Sync RMSql analyzeRMSql analyze -s SQL server -sync -f SQL ServerRMSql backup Example RMSql create RMSql create -s SQLVirtualServer -d test RMSql create -s SQLServer -d testUsing the Recovery Manager CLI RMSql deletebackup -s server1 -d db1 -t RMSql deletebackupRMSql display -s server1 RMSql displayRMSql listbackup RMSql mount Instance virtual copy limit RMSql policyDatabase virtual copy limit RMSql policy -exp 30d -s SQL server Retain timehHdDRMSql policy -n 5 -s SQL server Recovery Manager Commands RMSql portconfig -n 9999 -s WindowsHost RMSql portconfigRMSql portconfig -n number -s WindowsHost RMSql portconfig -nRMSql remove -s SQL server -t timestamp RMSql removeRMSql report -s Grampus -output c\MyReport RMSql reportRMSql report -s WindowsHost -output OutputDirectory WindowsHostRMSql repository -a d\3parvv RMSql repositoryRMSql repository -a alter location -r AltLocation RMSql restoreSystemDrive\3parSnapshot by default Snap NorecoveryRMSql restore -s server1 -d testdb -t RMSql restore -snap -s server1 -d testdb -tUsing the Recovery Manager CLI RMSql setvc RMSql setvc -s server1 -t 020409162103 -exp 30d RMSql setvc -s server1 -t 020409162103 -exp 2hRMSql timeconfig -bkt RMSql timeconfigRMSql timeconfig RMSql timeconfig -prtRMSql unmount -s SQL server -t timestamp Running Recovery Manager as a Scheduled JobScheduling an Automated Task in Windows RMSql unmountFor example Preparing for the Recovery Process Recovery for Microsoft SQL ServerMicrosoft SQL Server Recovery Models Recovering Data with HP 3PAR Recovery ManagerRecovering All Data with Point-of-Failure Recovery Performing a Point-of-Failure Recovery Recovering All Data with Point-of-Failure Recovery How Remote Copy Works Remote Copy for Recovery ManagerSetting Up Remote Copy Support for GeoCluster for Microsoft Windows Setting Up Remote Copy Volume GroupsSetting Up a Remote Copy Volume Group for Databases Support for Remote Copy Modes and PoliciesSetting Up a Remote Copy Volume Group for Instances Recovering a SQL Database from a Remote Copy Backup ServerVMWare and Egenera Server Virtualization EnvironmentsTroubleshooting Installpath\NetBackup\db\altnames\No.Restrictions Installpath\NetBackup\db\Event Messages Event ID Event ID Event ID Event ID Provcfg conn -syncrc Yes