The Transaction Log utility
132
The Transaction Log utility
With the Transaction Log utility, you can 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.
A transaction log mirror is a duplicate copy of a transaction log, maintained
by the database in tandem.
The name of the transaction log is first set when the database is initialized.
The Transaction Log utility works with database files or with write files. The
database server must not be running on that database when the transaction
log filename is changed (or an error message appears).
You can access the Transaction Log utility in the following ways:
♦ From Sybase Central
♦ From the system command line, using the
dblog
command-line utility
Changing a log file name from Sybase Central
v To change a transaction log file name:
1 Open the Utilities folder in the left panel.
2 Double-click Change Log File Information in the right panel. The
Transaction Log wizard appears.
3 Follow the instructions in the wizard.
Tip
You can also access this wizard by clicking Tools➤Adaptive Server
Anywhere➤Change Log File Information.
The dblog command-line utility
dblog [
switches
]
database-file
Syntax
To Next Page
Loading...