HP XP Command View Advanced Edition Software - Manual (Page 162)

In a cluster environment, however, this file should be stored in a shared directory that can be accessed
from both servers.
Contents of the transaction log list file
The contents of the file must follow these coding rules:
• Enter the name of the database, followed by the name of the transaction log file.
• Enclose the name of the database in square brackets "[" and "]".
• Enter the transaction log files for each database in the order in which they are to be applied.
• Each transaction log file name must be specified on one line.
• Each transaction log file name must be specified using the absolute path name.
• A transaction log file name must be left justified with no leading spaces.
• Lines beginning with a hash mark ( # ) are assumed to be comment lines.
Example of entries in a target definition file:
# Application Agent 7.0
# Log Backup Files
[SQLDB001]
C:\MSSQL\BackupLog\SQLDBLog001.bak
C:\MSSQL\BackupLog\SQLDBLog002.bak
C:\MSSQL\BackupLog\SQLDBLog003.bak
[SQLDB002]
C:\MSSQL\BackupLog\SQLDB2Log001.bak
C:\MSSQL\BackupLog\SQLDB2Log002.bak
C:\MSSQL\BackupLog\SQLDB2Log003.bak
Creation of a transaction log list file
You can use a redirect file created by specifying the - v option for the drmsqllogbackup command
as a transaction log list file. By using a redirect file, you can create a transaction log list file more
efficiently than by manually creating one.
When you specify the - v option for the drmsqllogbackup command, you can display the log
backup information even when no backup catalog exists. Therefore, there is no need to manually
create a transaction log list file while the
drmresync command is being executed or when the backup
catalog has been deleted by executing the drmresync command.
To create a transaction log list file (redirect file), use the following command:
PROMPT> drmsqllogbackup instance-name -target database-name -v > transaction-log-list-file-name
(absolute path)
For example, if you want to create a transaction log list file in C:\temp\SQLTXLOG.txt when the
SQL Server instance name is SQL1 and the database name is DB1 , execute the command as follows:
PROMPT> drmsqllogbackup SQL1 -target DB1 -v > C:\temp\SQLTXLOG.txt
Preparation for using Application Agent 162