Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 182
  • Last Modified:

sql2008 sqlservr and sqlagent startup type change to manual

I wonder, how do I check who and when service above the startup type got change from automatic to manual? anyway I can check this in sql2008  on windows 2008
1 Solution
This will be an event in your Event Viewer.  Issue is going to be determining how much of your logs are kept (they are auto-truncated after a certain amount of time).

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now