Post reply

ldf of main db and tempdb keep increasing

  • July 13, 2015 at 4:14 am

    #298454

    Hi, I have a full backup every night , differential backups every 2 hours and trans log shipping.

    Suddenly I see a huge increase in the backup sizes turns out the log files are getting massive.

    Any ideas what could suddenly cause this?

    Many thanks

  • July 13, 2015 at 4:53 am

    #1811909

    dbcc opentran

    showed an old transaction , killed it

  • July 13, 2015 at 5:42 am

    #1811923

    Edward-445599 (7/13/2015)

    dbcc opentran

    showed an old transaction , killed it

    You should now try to figure out what data is missing because of the rollback you just caused and who to notify that you just trashed their data. Let's hope it wasn't info on your next pay raise. 😉

    Stop killing things until you know just exactly what it is that you're killing and who to contact both before and after the kill.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply