Lotus Notes Transactional logging
Can we use transactional logging for backing up the mail databases of the user. We have around 1500 users and there is requirement of backing their mails. Can transactional logging be used for the same. How does it actually works?
Software/Hardware used:
Software/Hardware used:
ASKED:
April 27, 2011 1:07 PM
UPDATED:
May 2, 2011 6:19 PM
Answer Wiki:
Here is a link that will tell you about Domino and Transactional logging.
https://www-304.ibm.com/support/docview.wss?uid=swg27003543
Things to Notes....
Archive transactional logging will be needed to allow for a backup schedule to use that..... This will give you a point in time backup ability.
I have added a link to another forum entry that gives some more information......
http://itknowledgeexchange.techtarget.com/itanswers/imapct-of-transaction-logging/
To see all answers submitted to the Answer Wiki: View Answer History.
Please note you need a backup solution that is Archive transaction logging aware….. this is so that transactional logging can be over written after being backed up.
Basically all DB’s are given an ID (DBIID) and any action that is done to the DB is logged as a transaction. I hope you are following me at this point because this is where I get to make tea…..
Circular tranacional loggin – speeds up restarts after a crash because it runs all transaction on open DB’s to the point of the crash reducing the time needed to run the fixup task on all DB’s (circular because you restrcit the size of the log and the older logs are over written as the size limit is reached).
Archive tranaction logging – this is where the transactions are done for as long as it taken for you to back them up…. ie only backup the transaction logs each night and the full DB once a week. This will grow and grow unless your backup solution has the ability to mark a transaction log as archived (backed up). It is at this point that Domino will overwrite this infromation.
best practices – and allot more informaiton aswell
https://www-304.ibm.com/support/docview.wss?uid=swg27009309
Now if you are using Domino version 8 etc and wish to use DOAS please be aware that you need to be running transaction logging….
Yes, u may use transactional logging for back up the databases of any user. and not only that, also disaster recovery is possible by store in transaction log may supplement to full system recovery so data is not lost. The admin enables TL for all databases on server. He / she may select the archived logging style so that there is plenty of room for the transaction logs; uses a separate & installs a backup utility to recover from any corrupted databases.