HP Application Software Suite for Microsoft SQL manual Troubleshooting

Page 77

B Troubleshooting

This appendix is designed to be used like a Frequently Asked Questions section. It will help you find solutions to some of the common issues that might arise when running HP 3PAR Recovery Manager Software for Microsoft SQL Server.

Problem:

Recovery Manager displays error message “VSS_E_PROVIDER_VETO.”

Suggestion:

Check the application event log and VSS provider log from the production server. If you see “Maximum of 28 writable virtual copies per volume is allowed,” your virtual copy capacity might be full.

This error usually occurs when you mount a virtual copy. Unmount several virtual copies and continue the mount procedure.

Problem:

Even though Recovery Manager validated the configuration during operation, Recovery Manager exits without any messages during the check of the HP 3PAR Storage System.

Suggestion:

Validation might fail without proper notification. Restart the RMSql agent service on the backup and production servers.

Problem:

A restore of a backup, which was created using Symantec NetBackup via the Recovery Manager GUI, fails.

Suggestion:

When you use the Recovery Manager GUI to back up a virtual copy using Symantec NetBackup and a directory is specified for backup, you must enter the directory name and path precisely, including the upper- and lowercasing (e.g., MuTenFF). If the names do not match exactly, a restore of this backup will fail as Symantec NetBackup is case-sensitive.

When backing up a directory, specify the directory in exactly the same case as it exists on the file system.

Problem:

When you create a virtual copy on a SAN boot disk, the virtual copy creation fails with error “Error-VSS_E_HOLD_WRITES_TIMEOUT.” The in-box system writer that enumerates all operating system and driver binaries is included as well. The error usually occurs because the I/O cannot hold the system writer.

Suggestion:

HP does not recommend placing a database on the SAN boot disk. Place all important databases on separate SAN disks.

Problem:

As data blocks are copied per the copy-on-write technology, the space for virtual copies on the virtual volume might become 100% full either if virtual copy space was statistically allocated as a percentage of the virtual volume, or if there is no additional space available for the CPG to auto-grow. If the space for virtual copies on a virtual volume becomes 100% full, the virtual copies on the virtual volume may become invalid and subject to the Recovery Manager policy.

Suggestion:

Allocate more virtual copy space when creating virtual volumes during base volume creation, or use CPGs to manage the data generated by copy-on-write technology.

Problem:

You just installed Recovery Manager, but all GUI and CLI commands fail.

Suggestion:

77

Image 77
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 MessagesTypographical Conventions IntroductionRelated Documents 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 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 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 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 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 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 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 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 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 d\3parvv RMSql repositoryRMSql repository -a alter location -r AltLocation RMSql restoreSystemDrive\3parSnapshot by default 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