Chapter 4 Database Administration Utilities
133
Switch Description
–g n Sets the LTM generation number to n
–il
Ignores the LTM truncation offset stored in the
database
–ir
Ignores the SQL Remote truncation offset stored
in the database
–m mirror-name Set transaction log mirror name
–n
No longer use a transaction log or mirror log
–o filename Log output messages to a file
–q
Quiet mode—do not print messages
–r
No longer use a transaction log mirror
–t log-name Set the transaction log name
–x n Set the transaction log current relative offset to n
–z n Set the transaction log starting offset to n
The dblog command line utility allows you to display or change the name of
the transaction log or transaction log mirror associated with a database. You
can also stop a database from maintaining a transaction log or mirror, or start
maintaining a transaction log or mirror.
The utility displays additional information about the transaction log,
including the following:
♦ Version number
♦ Starting offset, for use in replication
♦ Ending offset, for use in replication
♦ Page size
♦ Total number of pages
♦ Number of empty pages
♦ Percentage of the log file in use
$ For more information about the command-line switches, see
"Transaction log utility options" on page 134.
Description
To Next Page
Loading...