When I try to restart my SQL server, I get the following error:
Why this error happens and how to solve this?
migrated from stackoverflow.com Jan 1 '12 at 18:14
This question came from our site for professional and enthusiast programmers.
When the Windows GUI starts a service, it displays a progress box for 60 seconds. After that, it will display the error "Service failed to resond in a timely fashion".
The message means no more than that the service didn't start in 60 seconds. This is not necessarily a problem: especially after a system halt, SQL Server can take a long time to start up, as it is rolling transactions backward and forward to get the databases in a consistent state.
Ignore the GUI error message, and check for details in the SQL Server error log.