SQL Server Performance Forum – Threads Archive
Log file get Full every hour
the database size is 28 Gig, the log file goes to 65Gig every hourI backup the log file and shrink it down to 100 MB, after one hour it goes
to 65 GIG again…
somebody knows what’s going on?
thanks
What is you recovery model, and what backup plan?
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS†with no warranties for accuracy.
are you doing any bulk insertion !?
Regards Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami
Check your application if all transactions are properly committed. I’ve seen this issue before and I know there is a KB article related to this. But unfortunately I can’t seem to find it right now. Probably a massive dose of coffeine will get my memory running and I’ll post the link when I find it. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
KBAs
http://support.microsoft.com/?kbid=873235
http://support.microsoft.com/default.aspx?scid=kb;en-us;230785 To keep your inserts from increasing the transaction log file so much, execute the inserts in smaller transactions based on an ordering key. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Thanks satya. I’ll add this one:http://support.microsoft.com/default.aspx?scid=kb;EN-US;110139 —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
Probably a massive dose of coffeine will get my memory running
.. good for a friday to have dose of coffee…unless you’re really busy all the week [8D]. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>