Zksod (11/26/2013)
I figure this is sorted... but just check that auto close is not set to ON.
Autoclose doesn't set the database to the OFFLINE state. A database closed by Auto_Close remains in the ONLINE state and just has the is_cleanly_shutdown column set to 1 in sys.databases.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability