Home Forums SQL Server 2008 SQL Server 2008 Administration Growing Log Files RE: Growing Log Files

  • April 4, 2013 at 7:33 pm

    #1603784

    mp5387 (4/4/2013)

    I am intermediate in database admin. Please give me your solution for this issue.

    Size of my db is growing about 5M every 2 weeks. Now its size is 118G. my db is in full recovery mode, and I do not have log backup.

    Is this a good solution?

    1- Perform a full backup

    2- execute checkpoint

    3-Perform full Backup

    4- Perform transactional log backup

    5- shrink log file type

    6- schedule transactional log backup

    Also, can I do these processes during users are connected ?

    Skip steps 2 and 3. Move step 6 to the new step 1.

    And if your log file is truly too big then do step 5.

    So the new order would be:

    1. Create tlog backup schedule

    2. Perform Full backup

    3. Shrink log file if too large.

    Doing this will allow the schedule to take care of the tlog backups.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events