HP 7450 Application Software Suite Microsoft SQL Media LTU manual

Page 37

2.From the Select Vendor drop-down list, select the backup software you are using:

Symantec NetBackup

HP Data Protector

3.In the Parameters area, enter the required information, depending on your backup software:

If you are using:

Symantec

NetBackup

Enter these parameters:

Master Server Name: The NBU master server

NBU Policy Name: The name of the policy you are using

NBU Full Schedule Name: The name of the schedule within the policy you are using

For more information, see Symantec NetBackup documentation and “Configuring Backup Software” (page 24).

HP Data

Data List: The name of the data list

Protector

For more information about data lists, see the description of backup specifications in HP Data

 

 

Protector documentation.

NOTE: Recovery Manager saves the information entered in the Parameters area and displays it as the default the next time you create a backup.

4.To automatically remove the newly created virtual copy after backup, ensure the Remove Virtual Copy from InServ after backup checkbox is checked.

5.To immediately create one backup, click Finish.

Recovery Manager creates the backup, names it as its timestamp, and adds it to the Backup Management node under the relevant instance or database in the node tree pane if:

You are using an expiration-based policy, or

You are using a numeric-based policy but either have not reached the maximum number of virtual copies allowed or the policy is configured to remove old copies as necessary (i.e., the Remove the oldest Virtual Copies checkbox is checked).

Recovery Manager does not create the backup if you are using a numeric-based policy and:

The policy is not configured to remove the oldest virtual copies (i.e., the Remove the oldest Virtual Copies checkbox is not checked), and

You have reached the maximum number of virtual copies allowed, and therefore Recovery Manager cannot create a new virtual copy.

For more information, see “Setting the Recovery Manager Policy” (page 29).

Scheduling Automatic Backups of an Instance or Database

To schedule automatic backups of an instance or database:

1.In the node tree pane, right-click the instance or database you want to back up, and select Backup to Media.

2.In the Backup to Media dialog box, enter the appropriate information. For more information, see “Manually Creating Backups at the Instance or Database Level” (page 36).

3.Click Next.

4.In the Task Scheduler, schedule backups as desired. For more information, see “Scheduling Automated Tasks with Task Scheduler” (page 34).

Backing Up a Virtual Copy 37

Image 37
Contents User’s Guide Documentation Contents Using the Recovery Manager GUI Configuring Backup SoftwareRecovery for Microsoft SQL Server Using the Recovery Manager CLIRemote Copy for Recovery Manager Troubleshooting Event MessagesRelated Documents IntroductionTypographical Conventions Advisories System Requirements Overview of Recovery ManagerWindows Server Requirements Additional System 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 Upgrading to Recovery Manager 4.2.0 for SQL Installation and DeinstallationPre-Installation Steps Installing Recovery Manager Understanding the Registry Verifying the InstallationDeinstalling Recovery Manager Configuring the SQL Database Configuring Recovery ManagerConfiguring Recovery Manager Configuring Mount Functionality Configuring Recovery Manager PoliciesGrouping Volumes into Autonomic Groups 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 VlunSetting Up Symantec NetBackup Configuring Backup SoftwareOverview Before You BeginSetting Up the HP Data Protector Backup Specification Configuring HP Data ProtectorSetting Up HP Data Protector Cell Manager Access RequirementsUsing Symantec NetBackup Using Your Backup SoftwareUsing HP Data Protector RM installation location\log\nbulog\databasetimestamp.logOverview of the Recovery Manager GUI Using the Recovery Manager GUIOpening 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 Retention Time Restrictions Setting Recovery Manager PoliciesModifying the Policy for a Virtual Copy Configuring Email NotificationsCreating Virtual Copies Deleting Email ConfigurationsHow Virtual Copy Creation Works Manually Creating a Virtual CopyScheduling Automatic Virtual Copies Creating Remote Virtual CopiesScheduling Automated Tasks with Task Scheduler Automating TasksManaging Automated Tasks with Task Manager Mounting a Virtual CopyUnmounting 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 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 for SQL Server Command Line Interface CLI Using the Recovery Manager CLIRecovery Manager Commands RMSql analyze -s SQL server -sync -f RMSql analyzeSQL Server SyncRMSql 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 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 number -s WindowsHost RMSql portconfigRMSql portconfig -n RMSql portconfig -n 9999 -s WindowsHostRMSql remove -s SQL server -t timestamp RMSql removeRMSql report -s WindowsHost -output OutputDirectory RMSql reportWindowsHost 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 -s server1 -d testdb -t NorecoveryRMSql restore -snap -s server1 -d testdb -t SnapUsing the Recovery Manager CLI RMSql setvc RMSql setvc -s server1 -t 020409162103 -exp 30d RMSql setvc -s server1 -t 020409162103 -exp 2hRMSql timeconfig RMSql timeconfigRMSql timeconfig -prt RMSql timeconfig -bktScheduling an Automated Task in Windows Running Recovery Manager as a Scheduled JobRMSql unmount RMSql unmount -s SQL server -t timestampFor example Microsoft SQL Server Recovery Models Recovery for Microsoft SQL ServerRecovering Data with HP 3PAR Recovery Manager 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 How Remote Copy Works Remote Copy for Recovery ManagerSetting Up Remote Copy Setting Up a Remote Copy Volume Group for Databases Setting Up Remote Copy Volume GroupsSupport for Remote Copy Modes and Policies Support for GeoCluster for Microsoft WindowsSetting 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