HP 7450 Application Software Suite Microsoft SQL Media LTU manual

Page 28

1.Right-click the MS SQL Server node and select Register Server.

NOTE: If your backup server and SQL production servers reside on different networks, the Recovery Manager for SQL Server Register window might not display all of the available SQL servers.

In addition, the displayed list of SQL servers can vary depending on factors such as network traffic, timeouts, routers, lost broadcasted packets, and other network issues.

2.Depending on whether the Recovery Manager for SQL Server Register window displays the SQL server you want to register, do the following:

If the list displays the SQL server you want to register, Recovery Manager discovered the server instance. Continue as follows:

a.Click the Register checkbox for the server instance.

b.Click OK.

If the list does not display the SQL server you want to register, you must manually register the instance. To do so:

a.In the Server Name text box, enter the SQL server name and instance name. Use the format SQLServerName\instanceName as follows:

If you are registering the default instance, either enter the SQL server name only, or enter the SQL server name and default, separated by a backslash.

For example, Aztec or Aztec\default.

If you are registering a named instance, enter the SQL server and instance name, separated by a backslash.

For example: Aztec\Bld2.

b.Click Add. Recovery Manager adds the new SQL server and instance to the list and automatically selects the Register checkbox for the entry.

c.Click OK to start the registration.

NOTE: Depending on your network traffic, it may take up to several minutes for the Recovery Manager GUI to register a SQL server instance.

3.Depending on the success of the registration, do one of the following:

If Recovery Manager displays Update Success in the entry's Status column, Recovery Manager successfully registered the instance. Click OK; you can now use the Recovery Manager GUI to manage the instance.

If Recovery Manager displays UpdateFailed in the entry's Status column, Recovery Manager was not able to connect to the instance. Continue as follows:

a.To fix any connectivity issues, see “Troubleshooting SQL Connectivity” (page 22). The instance must pass the SQL connectivity test before the Recovery Manager GUI can successfully register the instance.

b.Repeat the registration steps for the SQL server until Recovery Manager successfully registers the instance.

Updating Registration after Server Modification

If you modify a registered instance's configuration (e.g., you create a new database under that instance), you must rescan the instance to update the registration.

To rescan an instance:

1.Right-click the MS SQL Server node.

2.Select Rescan Server Configuration.

28 Using the Recovery Manager GUI

Image 28
Contents User’s Guide Documentation Contents Configuring Backup Software Using the Recovery Manager GUIUsing the Recovery Manager CLI Recovery for Microsoft SQL ServerRemote Copy for Recovery Manager Troubleshooting Event MessagesRelated Documents IntroductionTypographical Conventions Advisories Overview of Recovery Manager System RequirementsWindows Server 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 ServerConfiguring Backup Software Setting Up Symantec NetBackupOverview Before You BeginConfiguring HP Data Protector Setting Up the HP Data Protector Backup SpecificationSetting Up HP Data Protector Cell Manager Access RequirementsUsing Your Backup Software Using Symantec NetBackupUsing HP Data Protector RM installation location\log\nbulog\databasetimestamp.logUsing the Recovery Manager GUI Overview of 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 Setting Recovery Manager Policies Retention Time RestrictionsConfiguring Email Notifications Modifying the Policy for a Virtual CopyDeleting Email Configurations Creating Virtual CopiesHow Virtual Copy Creation Works 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 RMSql analyze RMSql analyze -s SQL server -sync -fSQL Server 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 RMSql portconfig -n number -s WindowsHostRMSql portconfig -n RMSql portconfig -n 9999 -s WindowsHostRMSql remove RMSql remove -s SQL server -t timestampRMSql report RMSql report -s WindowsHost -output OutputDirectoryWindowsHost RMSql report -s Grampus -output c\MyReportRMSql repository -a alter location -r RMSql repositoryRMSql repository -a d\3parvv SystemDrive\3parSnapshot by default RMSql restoreAltLocation Norecovery RMSql restore -s server1 -d testdb -tRMSql restore -snap -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 RMSql timeconfigRMSql timeconfig -prt RMSql timeconfig -bktRunning Recovery Manager as a Scheduled Job Scheduling an Automated Task in WindowsRMSql unmount RMSql unmount -s SQL server -t timestampFor example Recovery for Microsoft SQL Server Microsoft SQL Server Recovery ModelsRecovering 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 Remote Copy for Recovery Manager How Remote Copy WorksSetting Up Remote Copy Setting Up Remote Copy Volume Groups Setting Up a Remote Copy Volume Group for DatabasesSupport for Remote Copy Modes and Policies 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