Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2010
    Posts
    2

    Unanswered: huge transaction log backup

    Greetings,

    I've attached an image of my backup directory to help explain my question. Every Monday at 2am my transaction log backup is Huge. It's 3x the size of my backup taken an hour earlier. What can cause this?

    It's a sql server 2000 machine.

    Thank you,
    Darcy
    Attached Thumbnails Attached Thumbnails CarpeDir.jpg  

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    A load script. Do you get a data feed from anywhere? Do any updates to the data in that time?

  3. #3
    Join Date
    Mar 2010
    Posts
    2

    huge transaction log

    I run an optimization to change free space to 30%.

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    That would be it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •