Post reply

.ldf file is very big

  • April 27, 2009 at 8:48 am

    #220604

    Hi

    I have a database that has a very big log file. It is 5 time bigger than the .mdf file. How can I make the log file smaller.I don't want to shrink it because the ocupied space will still be big.I'm sure that not all the log information is usefull.What should I do?

    10q

  • April 27, 2009 at 9:00 am

    #984410

    Are you taking transaction log backups? These are what will start reducing the log file size, it will not reclaim the space though.

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

  • April 27, 2009 at 9:00 am

    #984411

    You should be backing up your transaction log at regular intervals, this will mark the space for re-use and should stop it from growing too large..

    Also it allows you to do point in time restores in case of a disaster..

  • April 27, 2009 at 9:28 am

    #984429

    and if the space is reused, at the first transaction the size of the log will be minimal or it will be constant the size before the backup.And if I make a full backup, the log reuse behaviour is the same?

  • April 27, 2009 at 9:34 am

    #984437

    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 5 posts - 1 through 4 (of 4 total)

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