Announcement

Collapse
No announcement yet.

Transaction logs folder filling up

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

  • Transaction logs folder filling up

    Please excuse, I never set this up so looking for pointers

    We had one DB so I created another and noticed the transaction logs folder for 2nd DB was eating disk space.

    Having compared both DB's setup, neither had circular logging but cannot fathom out why DB1 has 1.7gb (files seem to go back several days) of DB files and DB2 had 57gb.

    As a quick fix I've enabled circular logging on DB2 but is there something I'm missing.

    Having looked at the log files, DB1 seems to go back far longer that the approx 7 mins of DB2

    Is there a time retention policy that I'm not seeing?

    Thanks

  • #2
    Re: Transaction logs folder filling up

    Think I've sorted this will update tomorrow

    Comment


    • #3
      Re: Transaction logs folder filling up

      This is all to do with backups (and how you are doing them!)

      Circular logging is not recommended in most scenarios, and basically disables differential and incremental backups.

      If your log files are a few days old it basically means the backups have not been run, when a backup is taken the log files are played into the database, and thus cleared down.

      How are you doing exchange backups?

      Topper
      * Shamelessly mentioning "Don't forget to add reputation!"

      Comment


      • #4
        Re: Transaction logs folder filling up

        I sorted it Topper, would have helped if the Backup tape had been inserted the night before.

        Comment


        • #5
          Re: Transaction logs folder filling up

          Cool, glad you got it sorted!
          * Shamelessly mentioning "Don't forget to add reputation!"

          Comment


          • #6
            Re: Transaction logs folder filling up

            Originally posted by marcopolo View Post
            I sorted it Topper, would have helped if the Backup tape had been inserted the night before.








            Tom Jones
            MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
            PhD, MSc, FIAP, MIITT
            IT Trainer / Consultant
            Ossian Ltd
            Scotland

            ** Remember to give credit where credit is due and leave reputation points where appropriate **

            Comment

            Working...
            X