We have pieces of our own in house developed equipment which connect to our website regularly, the website connects to a SQL Database. Both the website and database are on Windows server 2008 running SQL Express 2008.
Every 7-8 days we get an issue where the SQL database can't be written to for exactly 60 seconds each time, the time of day this happens is also random.
I have auto close turned off now but it was enabled, is there a way to force a database to auto close for testing purposes? to see if this could be the cause, so I don't have to wait for another week to find out or is it possible to log when the database
auto closes?
Any suggestions on what could cause this or troubleshooting tips would be appreciated
...
Go to the complete details ...