Circular Logging in Disaster Recovery
Best Practice (Litmus Test)
Professionals: Think of disaster recovery, they disable circular logging 99% of the time
Amateurs: Think Circular Logging is best practice for database logs
Why is Circular Logging NOT Best Practice?
During disaster recovery, if you have over-written the transaction logs then you can only restore as far as the last backup. When all the logs are available, Exchange automatically replays the logs and recovers all the transactions.
What is Circular Logging?
Exchange, SQL and Active Directory databases all rely on transaction or write-ahead logs. Events can be quickly written to the logs, then later 'committed' to the main database file. Circular logging over-writes these transaction logs to save disk space.
How Transaction Logging Works
When a new piece of mail arrives, a transaction is written to the log. If the server is busy there will be a delay before the information is committed to the main EDB database file. A separate pointer called a checkpoint file maintains a record of how much of the log has been written into the EDB database.
Disaster Recovery of Exchange Stores
Each Exchange Storage Group has one log for up to five individual stores. The best practice of having multiple stores is to reduce the time needed to restore in disaster recovery conditions.
When disaster strikes and you have to restore an exchange store you need a full backup of the EDB database and all the logs since the the last backup. So if you allow circular logging to over-write some of the logs, then you lose all data since the last backup. However, if you disable circular logging, then you Exchange magically replays all the logs and brings back the Exchange store to how it was before the disaster. This re-reading the logs is called a hard recovery and happens automatically.
Kiwi CatTools is a free program for backing up configuration settings on hardware devices. Here is Guy's challenge. If you download CatTools, then it will not only take care of backups, but also it will show you something new about the hardware on you network. I could give you a money back guarantee - but CatTools is already free! Thus, I just make a techie to techie challenge, you will learn more about your network if you:
Where do you check the circular logging setting?
Why does such a potentially harmful setting exist?
The one time you may need circular logging is if your disk is full. When you first install a database you always think 'no way will the disk ever get full' - experience teaches it will!
Over 40 of Guy's litmus tests. Have fun while you learn about aspects of computing. Stacks of ideas to check your servers, networks and security.
Your eBook has printer friendly pages and lots more screen shots.
Guy's Litmus test is a concept that you can apply anywhere. Each test gives you an instant answer to the simple question:- 'Are you dealing with a professional, or are they an amateur? Is this the real deal, or is it a turkey?' The Litmus Test concept is rather like Best Practice, but it reduces a 27 page report to one sentence.
Learn about Windows 8