Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a SQL Server 2008 Standard instance running under Windows Server 2008 Standard. The SQL Server service is configured to start automatically (under the Network Service account); but occasionally when I come in to work and try to run something that uses the DB I discover that it's not running.

What do I need to look at to find out why it's either shutting down or not restarting after IT reboots the VM?

share|improve this question
    
Queue the Ren & Stimpy "Log Song". –  Tim Dec 12 '11 at 15:51
    
@Tim is that something I should refrain from Googling until I'm home and don't have big brother monitoring my HTTP traffic? –  Dan Neely Dec 12 '11 at 15:59

1 Answer 1

up vote 1 down vote accepted

Event logs will probably be your best place to start. There should be at the very least service start/stop logs.

share|improve this answer
    
What do I look under to filter the logs down to something reasonable? SqlServer isn't listed under Applications and Service Logs-Microsoft, and the Filter Current Log dialog doesn't appear to have anywhere I can enter plaintext to search for events mentioning MSSQLSERVER in the general field. –  Dan Neely Dec 12 '11 at 15:58
    
look for mssql or the instance name of your sql server. –  TheCompWiz Dec 12 '11 at 16:02
    
Where? I was able to find the startup event since I remembered roughly when I did so, but nothing in the default listview row (Information; 12/12/2011... ; Service Control Manager Event;7036;None) is enlightening. I tried adding the keyword column but "Classic" isn't helpful either. –  Dan Neely Dec 12 '11 at 16:06
    
I just right click the application log click find & search for mssql. –  TheCompWiz Dec 12 '11 at 16:07
    
My context menu choices are: Open Saved Log, Create Custom View, Import Custom View, and Help. CCV gives me a dialog with lots of checkboxes and dropdowns but no text field to enter mssql into. Am I clicking in the right place? –  Dan Neely Dec 12 '11 at 16:10

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.