Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: Transaction Logs

    Has anyone ever had the problem of the IT department not backing up thier transaction logs simply because they didnt find it necessary??

  2. #2
    Join Date
    Oct 2003
    Location
    Greensboro, NC
    Posts
    8

    sigh.

    Yes. It is an important issue that you need to be deliberate about. Either you store the logs and back them up because you need to, or you put the database in simple recovery mode (no log) and you back up the whole thing.

    We had databases that were in full recover mode (because the backup software gave an "error" if they weren't in that mode) but they were never backed up. IT couldn't figure out why their database server kept running out of storage when the database had only 200 MB of data in it. The log was over 20 GB!

    If you aren't backing up the log, then it isn't doing you much good. There's the odd chance that the server crashes before a log entry can be commited to disk, but really it's a huge storage price to pay for very little effect.

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    I've seen this problem before. This is a common flaw in shareware or beta versions of IT Department.

    Unfortunately, there is no patch for this issue. The only solution is to wipe your current IT Department, and then download and install a new one.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Talking Rofl

    Blindman Cracks me up...that was funny

Posting Permissions

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