SQL Server database constantly restarting

Posted by Michael Itzoe on Server Fault See other posts from Server Fault or by Michael Itzoe
Published on 2010-06-01T16:23:39Z Indexed on 2010/06/01 16:34 UTC
Read the original article Hit count: 203

We have SQL Server 2008 Express installed on a Windows 2003 server. Looking at the event log, one of the databases appears to be restarting anywhere from every couple seconds to every 15 to 30 minutes.

This server hosts about half a dozen databases; the problem is with only one. This database is also the onle one comprised of multiple schemas (not just dbo).

There are thousands of events going back several months. There doesn't seem to be any affect on the website using the database, nor does any data appear to be corrupted or compromised. I'm not a DBA, so I don't even know where to look for causes to this. Any suggestions?

© Server Fault or respective owner

Related posts about sql-server

Related posts about sql-server-2008