What causes log files to be unnecessary? -
03-22-2006
, 02:01 PM
Hi,
Can someone tell me how the DB code determines that a log file is no
longer necessary? I expected that if you checkpoint a database that
has no running application, all the log files would be deletable
according to db_archive. This doesn't seem to be the case. If the log
transactions have been comitted to the database, what is in the log
files that is still necessary?
Thanks for any info,
-- Andrew Bell
andrew.bell.ia (AT) gmail (DOT) com |