Circular logging with exchange 2010

Posted on 2014-02-19
Last Modified: 2014-02-28
Hers is my question.. If I have circular logging enabled on the data bases during a migration, will this affect how far back I can go on a backup to do a restore?
I know with it enabled I cant do incremental backups but was not sure say if I need to do a restore from say 2 weeks ago, if my backups will be affected at all with the circular logging enabled?
Question by:vmich
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 22

Accepted Solution

Nick Rhode earned 250 total points
ID: 39870624
Depends on the backup mainly.  With circular logging if you did a backup it flushes the logs out after a successful backup.  So if you backed up yesterday and the server went down today you would most likely lose the email you had today because you cannot truncate the logs for they have been overwritten with circular logging.  So in general with circular logging you most likely will lose the mail after the last successful backup.  Some mail is recovered just not all of it.
LVL 37

Assisted Solution

by:Jamie McKillop
Jamie McKillop earned 250 total points
ID: 39870653

If circular logging was not enabled when the backup was taken, you can restore the full backup and then restore any log files you have backed up between that backup and the next full backup. This would allow you to effectively restore the database to any point in time you want. If circular logging was enabled when the backup was taken, you can only restore that full backup, so you are limited to restoring the database to the exact time of any particular full backup you have.


Author Comment

ID: 39870797
so I should then get the backup job running and have it flush the logs during the migration instead of having circular logging enabled?
Is this correct?"
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

LVL 37

Expert Comment

by:Jamie McKillop
ID: 39870804
If the time to complete your migration is fairly short (couple of days), I would stick with circular logging. Any more than that are you are taking a risk.


Author Comment

ID: 39870810
ok thanks

Author Closing Comment

ID: 39894918

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Scam emails are a huge burden for many businesses. Spotting one is not always easy. Follow our tips to identify if an email you receive is a scam.
Read this checklist to learn more about the 15 things you should never include in an email signature.
In this video we show how to create a Resource Mailbox in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: Navigate to the Recipients >> Resources tab.: "Recipients" is our default selection …
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Suggested Courses
Course of the Month9 days, 4 hours left to enroll

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question