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:
Can you guess the problem?
Windows Explorer gave us:
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?”