"Matt Hyne" wrote:
Quote:
Has anyone actually tried setting up the transaction logging to a unix
file (NFS mount) so that in the even of a system failure, a full
restore and then transaction log restore results in a system that was
as it was just prior to the outage.
We can't justify another D3 licence for redundancy but if I can get all
transactions logged to a unix file I could have a recovered backup
system in 1/2 hour that has updated date up and until the point of the
crash, not just as of last night. |
Unfortunately, the answer to whether txlog is stable is subject to
re-evaluation with each D3 release. At least it used to be that way,
just check the Enhancements and Resolutions docs (E&R). At some point
they hat it pretty rock stable, but I don't know if that's still the
case. So my answer is to not trust what anyone here says, make up
your own mind after some testing.
The best way to prepare for using a critical feature like this is to
have your VAR beat the blanks out of it when RD announces each new
beta or patch release - that's what Value-Add Resellers are supposed
to do for you before you load the software and everything goes boom.
Having end-users load patches right after they're issued is just
silly, patching up for one issue might just break something else that
you need more. Ever notice all of the patches that are superceded by
other patches? Those are the fixes that had to be re-fixed after they
went production and got the real testing. So for things like indexing
or txlogging, beta early and beta often.
If you don't have a VAR then you could schedule some downtime and do
your own testing. Get a full save, start the logger, crash the box,
then go through the restore process. When you're all done restore
from the initial save, start the txlog, and let your users back on.
Or to test while users are still on, you can install another D3
virtual machine on the same system. Do this testing before loading
any new patches to your production environment. You can't do this
with monitor patches, only ABS patches. Patch a test environment, do
your save and txlog testing there with lots of restores, and when
you're satisfied that it "should" work, apply the latest patches to
your production environment. Check with RD about licensing I have no
clue how they'd manage that. If this sounds like a plan, call Support
and ask them for the VitMach document.
If you feel more daring, then sure, txlogging is fine, just turn it on
and use it!
T