Post reply

how to deincre logfile

  • February 9, 2011 at 7:11 pm

    #234725

    i used DBCC SHRINKFILE to truncate logfile

    but the logfile is big after insert,...

    i want to deincrease size of logfile when use insert, update,..

    please help me

    Hai Thanh

  • February 9, 2011 at 8:39 pm

    #1284930

    if you asking for decreasing the log file then the only thing you can do is more frequent log backup and execute small chunk of update/insert/delete statement.

    Also Shrinking is never the solution for reducing the size....for more understanding of log file have a read of article from Gail:- http://www.sqlservercentral.com/articles/64582/.

    Also familiarise yourself about :-

    Dbcc sqlperf(logspace)

    DBCC loginfo()

    select name, log_reuse_wait_desc from sys.databases

    ----------
    Ashish

  • February 9, 2011 at 11:46 pm

    #1284955

    thank you for supports, i will think about it more then

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

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