Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In the SQL Server Management Studio in Management I can view the SQL Server Logs.

I "inherited" a server where this Log is always empty. I'd guess my predecessor somehow disabled the SQL Server Log.

How do I enable this Log again?

share|improve this question
I'm not following you. What version/edition of SQL are you working with? Are you referring to the SQL Server Configuration Manager? Are you referring to Shared Memory, Named Pipes, TCP/IP, and VIA? – joeqwerty Jun 22 '11 at 11:35
Ah, sorry, I refer to SQL Server Management Studio (at least that's the name in the german edition). I wrote "tools" above. It's SQL Server 2005, but I guess the source would be the same for 2008. – Sam Jun 22 '11 at 13:10
Here, this software I refer to: - it is contained in the SQL Server package as optional install. – Sam Jun 22 '11 at 13:13
Here's a screen cap of mine, where are you having the problem? – RateControl Jun 22 '11 at 13:21
Ah, ok, the menu item is called "management > SQL Server logs" in the english version (I guessed my translation wrong). Thanks!! – Sam Jun 22 '11 at 13:34

Your Answer


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

Browse other questions tagged or ask your own question.