HP XP P9000 Replication Manager Software 7.6.1-00 Application Agent CLI Reference Guide

drmsqllogbackup instance-name -d
[ -s log-backup-ID ] [ -e log-backup-ID ]
To display the detailed information of transaction log files in the log backup catalog:
drmsqllogbackup instance-name -lsn
Description
The drmsqllogbackup command backs up the transaction log file of a SQL server database that
was backed up by using the drmsqlbackup command. Use the drmsqlinit command to set the
directory to which this file is to be backed up. The backup file of the transaction log file will be named
as follows:
database-name_yyyymmddhhmmss_log-backup-ID.bk
This backup ID is used to identify the number of times that the transaction log file has been backed
up, for the backup data specified by the backup ID. This value is expressed as a four-digit number in
decimal format (for example, 0001 or 1000).
The preconditions to execute this command are as follows:
• The instance to be backed up is running.
• The contents of the transaction log have not been destroyed.
• The recovery model of the database is Full or Bulk_Logged. (The recovery model Simple of the
database is not included.)
• None of the transaction log backup functions provided by SQL Server (such as BACKUP LOG and
the log distribution function) are being used.
Arguments
instance-name
Specify the name of the SQL Server instance to be backed up. If the SQL Server instance to be backed
up is the default, specify DEFAULT.
backup-ID
When deleting or displaying a transaction log file or backing up transaction logs, use this option to
specify its backup ID.
Specify the latest backup ID when you back up a transaction log.
When the backup catalog that you want to specify is deleted and you cannot specify a backup ID,
you can specify an original ID. Add O: before the original ID and specify the command arguments
as well as the backup ID. The following shows examples:
• In this example, the command views information on the backups of the transaction log backup
files with the original ID 0000000001:
PROMPT> drmsqllogbackup O:0000000001 -v
• In this example, the command deletes information on the backups of the transaction log backup
files with the original ID 0000000001:
PROMPT> drmsqllogbackup O:0000000001 -d
Basic commands172