149 reputation
9
bio website cybergeneration.com
location Mascouche, Canada
age 34
visits member for 4 years, 11 months
seen Sep 25 at 18:04

Currently principal developer of Cyberimpact (white hat mass mailing web app) at Cyber Generation. Expertise in

  • PHP
  • CodeIgniter
  • SQL Server, TSQL
  • PostgreSQL
  • Regex
  • javascript, AJAX, jQuery, prototype.js
  • Classic ASP (no comments...)

Jan
7
awarded  Editor
Jan
7
revised SQL Server 2008 log file grow ultra huge even in simple recovery
Reformulate ending question
Jan
7
comment SQL Server 2008 log file grow ultra huge even in simple recovery
As we did not know the first time it occured that the logfile would get that big, and did not know also that shrinking from 37GB to 1MB was a matter of a few seconds, we waited until the next day before running the Shrink command, and the next day the logfile was still 37GB. Autoshrink is not turned on for that DB, which I think explains why it remained 37GB. My question turns out more like how can we avoind to get it up to 37GB, we though that simple recovery would prevent that.
Jan
6
comment SQL Server 2008 log file grow ultra huge even in simple recovery
That would be something worth to try, but it does not explain why the log file keeps its huge size after the Stored Procedure finishes, why don't it shrinks back automatically to 1MB.
Jan
6
awarded  Supporter
Jan
6
asked SQL Server 2008 log file grow ultra huge even in simple recovery
Nov
16
awarded  Autobiographer