I've never relied on Auto_Shrink. What happens if you manually shrink the TLog with DBCC SHRINKFILE()?

-Mike

>So, even though I have a full backup plan specified for a database the log will auto shrink as long as I back it up, either with a maintenence plan or manually? Or do I have to manually shrink the files?
>
>>The performance monitory exposes a counter that indicates when the logfile is shrunk via auto_shrink. Use this to determine whether the autoshrink is running.
>>
>>-Mike