Announcement

Collapse
No announcement yet.

Manually deleting transaction logs

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Manually deleting transaction logs

    Hi all,

    This concept what I want to rectify is usually not advisieable, but I want to have this implemented. So please it would be appreciated if u can provide some information on this.

    Enviornment : exchange server 2003 r2 Enterprise Edition on windows server 2003 r2

    I want to manually delete transaction logs and enable circular logging and want the log file numbering to start form scratch or to be reset.

    I have the following set of files in my mdbdata folder apart from the .edb and .stm files tmp.edb, res2.log, res1.log, E00.log, E00.chk, 26-87185588-5DF2452.IFS and some transaction log files like E00XXXX.

    My database is in a clean shutdown state and log required is 0-0.

    So let me know the following

    1. what files along with the transaction logs should I move / delete so that the numbering of logs start from the beginning
    2. should the database be dismounted for circular logging ?
    3. when should I enable circular logging i.e. before moving the logs or after moving the logs ?

    thanks,
    Hussain

  • #2
    Re: Manually deleting transaction logs

    If the database is clean, just turn on circular logging.
    The logs will be deleted by Exchange over the next couple of hours.

    You realise that with circular logging enabled you have no recovery available for the store at all?

    Simon.
    --
    Simon Butler
    Exchange MVP

    Blog: http://blog.sembee.co.uk/
    More Exchange Content: http://exchange.sembee.info/
    Exchange Resources List: http://exbpa.com/
    In the UK? Hire me: http://www.sembee.co.uk/

    Sembee is a registered trademark, used here with permission.

    Comment


    • #3
      Re: Manually deleting transaction logs

      Thanks for the information. I do agree with you that recovery is not possible. what i wanted to know is

      1. Should the database be dismounted to enable circular logging ?
      2. if I move/delete all the transaction logs includeing the latest log along with the check poiny file will the log numbering sequence start off again from E00 ?

      Comment


      • #4
        Re: Manually deleting transaction logs

        You can reset the transaction logs numbering with moving / deleting logs from Storage Groups logs directory.

        Please go through below article, which will help you....


        http://technet.microsoft.com/en-us/l...CHG.80%29.aspx

        Comment


        • #5
          Re: Manually deleting transaction logs

          Originally posted by Hussain View Post
          Thanks for the information. I do agree with you that recovery is not possible. what i wanted to know is

          1. Should the database be dismounted to enable circular logging ?
          2. if I move/delete all the transaction logs includeing the latest log along with the check poiny file will the log numbering sequence start off again from E00 ?
          It seems you didn't read Simon's answer. Take another look at it and follow his recommendation.

          Comment


          • #6
            Re: Manually deleting transaction logs

            Sorry for the confusion...

            After enabling Circular logging information store need to be restarted, it means downtime required. But I am not sure whether transaction logs will get reset or not? As per my understanding it won't.

            Comment


            • #7
              Re: Manually deleting transaction logs

              http://support.microsoft.com/kb/314605

              Comment


              • #8
                Re: Manually deleting transaction logs

                After activating circular logging and restarting the information store, transaction logs will get reseted, it might need some time, but it works.

                Comment

                Working...
                X