.ldf file is very big

  • 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

  • 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]

  • 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..

  • 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?

  • 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