Post reply

how to deincrease size of logfile

  • February 9, 2011 at 9:48 pm

    #233381

    I used DBCC SHRINKFILE to truncate logfile after use insert, update,...

    but the data is too big because the logfile increase after insert,..

    how to deincrease size of logfile when use insert, update,...

    please help me

    thanks

  • February 10, 2011 at 6:58 am

    #1285149

    hello,

    not sure what recovery model you are using for the databases but if you use SIMPLE mode it will regularly truncate the transaction log....but beware....this will only allow you to restore the database from the last FULL backup....all data changes since then will be lost

    if you use the FULL model your transaction log will continually grow until you backup the log itself....if this is done every hour the log should stay small....but depends on the size of the database and the level of activity

    what size do you need/want it to be?? do you have disk space problems??

  • February 10, 2011 at 7:51 pm

    #1285551

    thank you for your repply

    i think i dont have to backup the data, because the all data is truncate and update again every day and we have to recalculate after the data is update again

    otherwise the number of record of a table is tens millions and larger

    so logfile is very big after we used insert, update,...statement and so disk pace is in a state near full after the recalculation.

    how to deincrease size logfile when use insert, update,... statement

    please help me

  • February 11, 2011 at 1:48 am

    #1285553

    Can you let us know recovery model of database.

    select name,recovery_model from sys.databases

    M&M

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

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