Post reply

NEED to Reduce the space from the Drive in which Transactional log backups generates for every 10 mins

  • August 11, 2012 at 2:02 am

    #392935

    NEED to Reduce the space from the Drive in which Transactional log backups generates for every 10 mins in Tlbackup folder now it is occuping more space how to free the space from the Ls backup please gv reply

    Thanks

    Rohit

    Thanks
    Naga.Rohitkumar

  • August 11, 2012 at 10:49 pm

    #1524815

    You really only need the last 1 or 2 full backups and the t-Log backups for those. Backup everything to tape once every day and delete anything more than 2 full backups old. You can create a maintenance plan that will do this "auto-magically".

    If the company doesn't have a tape backup, tell them to buy one and then ship recorded tapes to a place offsite. Keeping backups locally is a form of corporate suicide especially in bad weather, earthquake, tsunami, and fire zones.

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

  • August 12, 2012 at 12:43 am

    #1524822

    what's the recovery objective/target of this database server in question?

  • August 12, 2012 at 2:59 am

    #1524823

    Please don't post multiple threads for the same problem

    http://www.sqlservercentral.com/Forums/FindPost1343762.aspx

    http://www.sqlservercentral.com/Forums/FindPost1343776.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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