October 25, 2002 at 8:04 am
I keep seeing alot of this stuff in SQL Server Error Log:
Starting up database 'Coroma_RD'.
Opening file C:\MSSQL7\data\Coroma_RD_Data.MDF.
Opening file C:\MSSQL7\data\Coroma_RD_Log.LDF.
Closing file C:\MSSQL7\data\Coroma_RD_Data.MDF.
Closing file C:\MSSQL7\data\Coroma_RD_Log.LDF.
Why does this keep occurring?
October 25, 2002 at 8:27 am
Check your database option 'auto close' is enabled or not.
When set to ON, the database is closed and shut down cleanly when the last user of the database exits and all processes in the database complete, thereby freeing any resources. By default, this option is set to ON for all databases when using Desktop Engine, and OFF for all other editions, regardless of operating system. The database reopens automatically when a user tries to use the database again.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply