We currently have logging enabled on our databases, but do not use
DBBEGIN and DBEND. We store our databases using Orbit/3000 once a week
and store the log files nightly.
We also have not tested our database recovery procedures in years.... :(
We are going to.
If we were to experience a problem that wiped out a database would the
proper procedure be to restore the database from the full backup
containing the databases and then do a DBRECOVER using the log file from
the nightly partial?
Of course this means we lose a days work at most(too bad we store the
log files on the same volume set as the databases.)
I beg pardon for what is essentially an RTFM question, but it has been
years since I've had to do this. Any manual citations would be
appreciated.
*******************************************
Paul Courry
[log in to unmask]
500 442-0261 (ATT lines only)
http://www.ns.net/~courry/
PGP key kept at PGPKEYS.MIT.EDU
*******************************************