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

    Unanswered: Transaction Logs are huge

    Hi all our It Admin is having issues with the backups. He was doing full backups every 4 hours with backupExec, which means thats way too much. But now hes trying to do a simple recovery now, because obviously the transaction logs have not been truncated. Its a big mess, I'm not involved in this part, they handle the backing up and permissions. Transaction logs are huge??

    Any suggestions??

  2. #2
    Join Date
    Jun 2007
    Location
    Ohio, USA
    Posts
    142

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Do not walk away. Run.

  4. #4
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789
    Oh man, are you telling me that this is going to turn into a huge nightmare?? Man that's way to much backing up. Full backup every 4 hours, GOOD GRIEF.

  5. #5
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    It should more properly be a transaction log backup every four hours, instead of a full backup every four hours. But if the SQL DBA(s) there don't know the difference, I would be very concerned.

    If it is a Transaction log backup every four hours, then they would be getting stuck on either a transactional replication failure, or a user transaction that has been open for way too long.

  6. #6
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789
    Quote Originally Posted by MCrowley
    It should more properly be a transaction log backup every four hours, instead of a full backup every four hours. But if the SQL DBA(s) there don't know the difference, I would be very concerned.

    If it is a Transaction log backup every four hours, then they would be getting stuck on either a transactional replication failure, or a user transaction that has been open for way too long.

    He was doing a full backup not just a back up of the transaction logs, a FULL BLOWN BACK UP

  7. #7
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Ok, you apparently understand the problem. How can we help?

    -PatP

  8. #8
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789
    GOOD GRAVY HES TRYING TO TRUNCATE THE TRANSACTION LOGS, ITS NOT WORKING

    AND I JUST WANT TO PULL MY HAIR OUT!!!!!!!!!!!!!!!!!!!!

    He needs to change the recovery modle to SIMPLE


    OH WHY??!!!!!!!!!!!!!!!!!!!! I NEED TO GO TAKE A WALK AND COUNT 400

    LOL

  9. #9
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789
    Quote Originally Posted by Pat Phelan
    Ok, you apparently understand the problem. How can we help?

    -PatP
    Hi all I just got back from a meeting with our IT, problem solved I explained the problem with a full backup every 4 hours. Also that the recovery on the databases need to be changed to Simple. He was able to Truncate the Transaction logs, the back ups are now at 16.5 Gig rather then 99.5 Gig. Good grief what A DAY. Was nice cause he actually thanked me for my help, I AM SO HAPPY. I explained with the trans logs so bloated like that, there's going to be some serious performance issues. '



    THANK YOU AGAIN GUYS

  10. #10
    Join Date
    Jun 2007
    Location
    Ohio, USA
    Posts
    142
    FWIW: There is nothing wrong with a full backup every 4 hours if you have sufficient requirements for recoverability and resources to do so. I've been in environments where a full backup was done every hour, and a transaction log backup every 5 mintues. Disk resources were high, sure, but our speed to recovery was phenomenal.

    I'd say the bigger issue here was the wrong backup strategy for the recovery model's requirements. Glad to see that's been sorted.

    Take care.

    -D.

  11. #11
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789
    Space is not something we have allot of right now, and since the tribe is trying to save money for this expansion they are not going to be in favor of more hardward.

    Now since the backups have drastically dropped from 99.5 to 18.0 the problems is obviously resolved.

  12. #12
    Join Date
    Feb 2004
    Location
    Burbank & Santa Cruz de la Sierra
    Posts
    3,716
    Hey Des....what reservation do you work for? I am just up the coast from you an hour or two, and like to spend money in casinos *LOL* We should get together sometime for a night of hard bourbon/tequila slamming!
    aka "Paul"
    Non est ei similis.

    I just read "100 Things To Do Before You Die". I was surprised that "Yell for help!!" wasn't one of them

  13. #13
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789
    Hi Cowboy, how was your weekend

    I work for Viejas Tribal Gaming Commission
    in Alpine, sorry I dont drink and gambling is such a waste of money. Eat at the Buffet or catch a show. We got concerts here
    you wouldnt wnat to come and waste your money on a casino
    Last edited by desireemm; 03-28-08 at 18:21.

Posting Permissions

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