971201AA.log
consol.db
971201AB.log
consol.log
Abackup command line Thefollowing command line backs up the database using the rename and
restartoption, and also uses an option to rename the transaction log backup
file:
dbbackup -r -k -c "uid=DBA;pwd=SQL" c:\archive
Theconnection string options would be different for each database.
Effectsof the backup Ifyou back up the transaction log to a directory
c:\archiveusingthe rename
andrestart option and the log renaming option, the Backup utility carries out
thefollowing tasks:
1. Renames the existing transaction log file to
971201xx.log
,where
xxare
sequentialcharacters ranging from
AAto
ZZ.
2. Backs up the transaction log file to the backup directory, creating a
backupfile named
971201xx.log
3. Starts a new transaction log, as
consol.log
.
Afterseveral backups, the live directory and also the archive directory
containa set of sequential transaction logs.
C:\Live C:\Archive
consol.dbconsol.db
971201AA.log
971201AB.log
971201AC.log
consol.log
971201AA.log
971201AB.log
971201AC.log
AMessage Agent
commandline Youcan run the Message Agent with access to these log files using the
followingcommand line:
dbremote -c "dbn=hq;..." c:\archive
252