Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 10
Impact
~8k people reached

  • 0 posts edited
  • 0 helpful flags
  • 27 votes cast
Feb
25
comment How to revert the compressed attribute on files in Windows for a whole drive
That was done by mistake by a sysadmin that does not work here anymore ;-) Other sysadmins did not know how to revert this, that's why I'm asking here.
Feb
24
awarded  Student
Feb
24
asked How to revert the compressed attribute on files in Windows for a whole drive
Jan
8
awarded  Scholar
Jan
8
accepted SQL Server 2008 log file grow ultra huge even in simple recovery
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