HP Application Software Suite for Microsoft SQL manual RMSql backup

Page 44

RMSql backup

SYNTAX

RMSql backup -s <SQL server> [-i <SQL instance>] [-d <database>] [-t <timestamp> -r ] [-ts <target server>][-p <policyName> -u <ScheduleName> -M <masterServer>] [-noemail] [-dl <DataListName>]

DESCRIPTION

The RMSql backup command backs up a virtual copy to the specified media. The backup can be an existing virtual copy, or it can be a new virtual copy created by this command.

PARAMETERS

The following options are supported:

-s <SQL Server>	The SQL server associated with the database.
-i <SQL instance>	Optional. The SQL server instance associated with the database.
	If not specified, MSSQLSERVER (local) is used as the default value.
-d <database>	Optional. The database for the virtual copy. If not specified, the
	instance for the virtual copy is used as the default value.
-t <timestamp>	Optional. The timestamp of the virtual copy to back up. If not
	specified, the system creates a point-in-time virtual copy, uses it to
	create the backup, and then removes this virtual copy after the
	backup is complete. If specified, the system retains this timestamp
	value after the backup is complete.
-r	Optional. Retain the virtual copy. Valid only if you do not use the
	-toption. If not specified, the virtual copy is deleted after backup
	is complete.
-ts <target server>	Optional. Target Server for the backups if the -roption is not
	specified. To use this option, the following must be located at the
	secondary site:
	• Recovery Manager Backup Component server, with Recovery
	Manager for SQL Server installed
	• Symantec NetBackup client or HP Data Protector
	If not specified, the local system is used as the default value.
-p <policyName>	Symantec NetBackup policy name. Only valid if Symantec
	NetBackup software is in use.
-u <ScheduleName>	Name of the NetBackup backup schedule. Only valid if Symantec
	NetBackup software is in use.
-M <masterServer>	NetBackup master server name. Only valid if Symantec NetBackup
	software is in use.
-noemail	Optional. Do not send an email notification even if configured for
	this operation. If not specified, Recovery Manager sends an email
	notification of the backup if configured. For more information, see
	Configuring Email Notifications.
-dl <DataListName>	Specifies the data list name (aka the backup specification name)
	and indicates the backup software in use is HP Data Protector.
	Optional: If not specified, Recovery Manager proceeds as if the
	backup software used is Symantec NetBackup.

44 Using the Recovery Manager CLI

Image 44

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 MessagesTypographical Conventions IntroductionRelated Documents 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 Pre-Installation Steps Installation and DeinstallationUpgrading to Recovery Manager 4.2.0 for SQL Installing Recovery Manager Verifying the Installation Understanding the RegistryDeinstalling Recovery Manager Configuring Recovery Manager Configuring Recovery ManagerConfiguring the SQL Database Grouping Volumes into Autonomic Groups Configuring Recovery Manager PoliciesConfiguring Mount Functionality 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 Unregistering a SQL Server Instance Setting the Recovery Manager PolicyHow Recovery Manager Policies Work 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 ManagerBacking 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 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 Commands Using the Recovery Manager CLIRecovery Manager for SQL Server Command Line Interface CLI 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 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 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 d\3parvv RMSql repositoryRMSql repository -a alter location -r AltLocation RMSql restoreSystemDrive\3parSnapshot by default 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