Solved

SQL Agent stopping each night

Posted on 2010-08-12
2
421 Views
Last Modified: 2012-05-10
Our SQL server seems to stop the agent each night around the same time with this error:

SQLSERVERAGENT service stopping due to a stop request from a user, process, or the OS...
0
Comment
Question by:biotec
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 8

Accepted Solution

by:
dba2dba earned 500 total points
ID: 33423257
Please check the SQL Agent.OUT file (Default path is - C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG) for some more information on this error. Also, what are the events logged in event viewer during this time. Please post the error messages.
0
 

Author Comment

by:biotec
ID: 33424087
We think it might be related to Backup Exec running on that server. It seems to be shutting down the agent and not starting it.
0

Featured Post

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question