Almost every time I restart the machine hosting a SQL Server 2008 R2 express server, the database goes through the restore process. Most of the time, the database will become stuck in the restore process.
This error was found in the windows event log:
The SQL Server (__NAMEHERE__) service terminated unexpectedly. It has done this 1 time(s).
This was found in the sql logs:
2011-12-09 10:12:51.16 Server SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
2011-12-09 10:13:18.86 spid13s Service Broker manager has shut down.
2011-12-09 10:13:18.86 spid13s Error: 17054, Severity: 16, State: 1.
2011-12-09 10:13:18.86 spid13s The current event was not reported to the Windows Events log. Operating system error = (null). You may need to clear the Windows Events log if it is full.
Any obvious reason as to why I cannot restart the system without the database needing to go through a restore.