HP 7450 Application Software Suite Microsoft SQL Media LTU manual Configuring Email Notifications

Page 31

4.Click Finish.

The virtual copy policy is effective immediately for all future virtual copies.

NOTE: You can also use the Recovery Manager CLI command RMSql policy to set Recovery Manager policies. For more information, see “Using the Recovery Manager CLI” (page 42).

Modifying the Policy for a Virtual Copy

To modify the retention time or the expiration time or both for a virtual copy:

1.In the node tree pane, right-click the virtual copy you want to modify, and select Edit Time Constraints.

2.To set a new retention time, check the Retention Time checkbox and enter a new value.

3.To set a new expiration time, check the Expiration Time checkbox and enter a new value.

For more information on setting the retention and expiration time, see “How Recovery Manager Policies Work” (page 29).

4.Click Ok.

NOTE: You can also use the CLI command RMSql policy to modify Recovery Manager policies. For more information, see “Using the Recovery Manager CLI” (page 42).

Configuring Email Notifications

You can configure Recovery Manager to automatically send an email when:

You create a virtual copy or remote virtual copy, or Recovery Manager automatically creates a virtual copy or remote virtual copy according to the task schedule.

You create a backup or Recovery Manager automatically creates a backup according to the task schedule.

You restore a volume, instance, or database.

In addition, you can configure the email to notify you only when an operation completes, only when an error message displays, or when either occurs.

NOTE: For more information about scheduling automatic virtual copies and remote virtual copies, see “Scheduling Automatic Virtual Copies” (page 33). For more information about scheduling automatic backups, see “Scheduling Automatic Backups of an Instance or Database” (page 37).

To configure email notifications:

1.In the node tree pane, right-click the instance for which you want to configure email notifications, and select Email Config.

2.In the Email Configuration pane, enter the appropriate information in the following text boxes:

Email Type - Type of email server (e.g., SMTP)

SMTP Host Name - Name of the email server

Port - Port of the email server

Sender Email Address - Email address of the sender

Password - Password for the sender’s email address

Receiver Email Address - Email address of the person to be notified of task activity and/or errors

3.To send email notifications via the Secure Sockets Layer protocol, ensure the SSL checkbox is checked.

4.To make sure the email configuration works, click the Test Connection button.

Configuring Email Notifications

31

Image 31
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 ManagerRelated Documents IntroductionTypographical Conventions 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 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 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 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 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 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 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 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 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 alter location -r RMSql repositoryRMSql repository -a d\3parvv SystemDrive\3parSnapshot by default RMSql restoreAltLocation 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