Post reply

stop increasing Log file db_log.ldf

  • August 11, 2009 at 1:20 am

    #156088

    dear all,

    i have aproblem in log file db_log.ldf its size increasing rapidly and i want to avoid its increasing,

    i'm not DBA so, plz i want description for my problem in more details.

    thanks alot.

  • August 11, 2009 at 1:25 am

    #1037267

    Hi,

    log is increaing as there are lots of insert update and delete operation going on the Database. You can shrink log by taking first full backup once a week and then differential backup after every 2 or three hours and log backup evry hour. when take a log backup server automatically truncate commited log entries from the log file and u have only active or uncommited transaction.

    i would suggest u create a maintance plan on DB.

  • August 11, 2009 at 1:55 am

    #1037276

    What recovery model is the database in? Are log backups been done? What's the recovery requirements for this database should something fail (lose a day's daya, lost 5 minutes data, etc)?

    Please read through this - Managing Transaction Logs[/url]

    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 3 posts - 1 through 2 (of 2 total)

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