Hp XP Command View Advanced Edition Software Manuale Utente Scaricare il pdf (Pagina 162)

100

101

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 Agent162

1 2 ... 157 158 159 160 161 162 163 164 165 166 167 ... 573 574

Commenti su questo manuale

Nessun commento

Hp XP Command View Advanced Edition Software Manuale Utente Pagina 162

Commenti su questo manuale

Prodotti e manuali riguardandi Magazzini Hp XP Command View Advanced Edition Software