.ldf file is very big

Question

.ldf file is very big

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

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

Carolyn Richardson SSCrazy Eights Points: 8357 More actions · Answer 1

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]

steveb. SSC-Forever Points: 46733 More actions · Answer 2

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

newbie_dev SSCommitted Points: 1916 More actions · Answer 3

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?

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 4

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