March 17, 2014 at 3:20 am
TITLE: View Snapshot Agent Status
------------------------------
The agent could not be started.
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
SQLServerAgent is not currently running so it cannot be notified of this action.
Changed database context to 'NDP'. (Microsoft SQL Server, Error: 22022)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.3128&EvtSrc=MSSQLServer&EvtID=22022&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
March 17, 2014 at 3:30 am
It sounds like your SQL Agent service is offline. First, I'd attempt to restart it. Was it ever online? If so, have you recently made changes to the security settings on the server? Frequently when Agent can't start, it's security related. If it's never been run before, try starting it. If it won't start, check the Agent error log (for more details on how to do that, read here[/url]).
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 17, 2014 at 3:53 am
Is this production server?
First of all check the history of Snapshot Agent.
If snapshot agent failed collect the information why it failed from history and log.
Also check the schedule of Snapshot agent. what is the schedule of the snapshot agent job?
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply