HP StorageWorks P9000 Command View Advanced Edition Suite Software 7.0 Mainframe Agent Installation and Configuration Guide (TB581-96014, November 2010)

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.)
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
-v
Specify this option to display a list of the transaction log files that were backed up. Information on
the backups of the transaction log files acquired after the backup ID specified together will be displayed.
CLI Reference Guide 167