Troubleshooting 101 – Services failed to start

One that happened a while ago, as I’m a bit swamped with reality at the moment…

So I got into work one Monday morning to be greeted by one of the tech support team saying “your database server isn’t working”.

Hmm.  OK, let’s have a look.  First thing – is SQL server responding at all?  No.

Windows Event Viewer shows the following:

Event Viewer error message from SQL Server's failed attempt to start. - EventID 17204

Event Viewer error message from SQL Server's failed attempt to start. - EventID 17204

Can you guess the problem?

Windows Explorer gave us:

Windows Explorer - No additional storage.

Windows Explorer shows us the way

Time to figure out the basic problem from start to finish: 30 seconds.

Time for my non-techie wife to figure out the problem: maybe a minute.

The server had been up & down all weekend, while the infrastructure team did some patching – not that we DBAs knew that that was going on…  The worst bit, apart from the complete lack of communication?  The comment from the tech manager: “What kind of picky services are these?”

Advertisements
This entry was posted in SQLServerPedia Syndication, Uncategorized and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s