Home Forums SQL Server 2008 SQL Server 2008 Administration Log space full 100% RE: Log space full 100%

  • October 29, 2012 at 6:28 am

    #1553695

    Mac1986 (10/28/2012)

    Yes I bet its the run away query. The log sizes are 90 and 85 GB. the data file sizes are. 1.4 TB and 900 GB.

    the delta run job might have caused the issue.

    what can be done here. I'm unable to change the DB to FULL and take a FULL Backup.

    What Am I supposed to do to create some space on disk. I need like 70 GB space on disk so that I can increase the log file space and CDC Job will do the rest.

    Please suggest...

    Gail is right. I've got TempDB on my mind lately. She's also got more knowledge about CDC than I'll likely ever have so I'm going to defer to the master.

    --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)