July 20, 2010

AUTO_CLOSE option for the SQL database should be turned off

New issue with MS SQL Server 2005 Express Edition has been discovered by us. We noticed that the SQL Server service logs a lot of "Starting up database bcs30" messages with event ID #17137 to Event Log. This occurs only on SQL Server 2005 Express Edition and may cause problems with Bopup Communication Server performance and stability. This issue doesn't appear if the communication server was installed with built-in MSDE 2000 (Microsoft SQL Desktop Engine).

We found that in order to avoid closing and starting up the database we must use AUTO_CLOSE option set to OFF. This bug fix will be included to the next release of Bopup Communication Server.

More information on this issue: SQL Server Best Practices: AutoClose Should be Off

No comments:

Post a Comment