Subject | firebird transaction logging |
---|---|
Author | avian_rand |
Post date | 2003-08-10T21:08:49Z |
MS SQL Server creates a log file of every transaction (a separate
file that
you usually put on a separate drive or machine than the actual db
file) that
can be rolled forward in the event of a disaster. You go back to your
latest backup and then roll the log forward to the point of the
disaster.
Is there a similar feature in Firebird? I read something about
logging
taking place in the fbd file itself. This seemed like a bad idea to
me. Of
course if your fbd file gets trashed somehow, then you have to go
back to
your latest backup. Can anyone give me a brief explanation of how
all this
is done in FB?
Thanks,
Avian
file that
you usually put on a separate drive or machine than the actual db
file) that
can be rolled forward in the event of a disaster. You go back to your
latest backup and then roll the log forward to the point of the
disaster.
Is there a similar feature in Firebird? I read something about
logging
taking place in the fbd file itself. This seemed like a bad idea to
me. Of
course if your fbd file gets trashed somehow, then you have to go
back to
your latest backup. Can anyone give me a brief explanation of how
all this
is done in FB?
Thanks,
Avian