Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DeepGround
Yak Posting Veteran
73 Posts |
 Posted - 2008-11-10 : 17:46:58
|
| Hello,I have always had my Mode set to Simple for databases and that has prevented our log files from growing, they usualy stay around 2 Meg.Recently they have been growing to infinity causing HDD to fill up. I have tried setting restricted file growth and that stops the database from functioning because it has not room to fill the log. How do I get it back to stop using logs again? I really do not care about having a log of the transactions, in fact it is nothing but trouble. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-10 : 18:35:36
|
| Do you huge logged operation like Bulk insert,Massive delete,reindex running? How about shrinking log file with desired size? |
 |
|
|
DeepGround
Yak Posting Veteran
73 Posts |
Posted - 2008-11-10 : 19:07:52
|
| I have tried shrinking them with DBCC Shrink and it works, but then they grow again, some of them can grow 10GB in 3 days. One of the developers mentioned the fact that the auto shrink may not work if a transaction goes into an endless loop, but that we would have no idea of knowing if that was happening to a database. |
|
|
|
DeepGround
Yak Posting Veteran
73 Posts |
Posted - 2008-11-10 : 19:09:57
|
| Well I take that back, we could profile it, though it would take a long time to weed out normal transactions from a bad one. |
|
|
|
|
|
|
My Log Files are blowing up