Just Code‎ > ‎

Could not start the Snapshot Agent to generate a new snapshot

posted Sep 5, 2011, 6:54 AM by Peter Henell   [ updated Sep 5, 2011, 6:56 AM ]
PROBLEM:
TITLE: Microsoft SQL Server Management Studio
------------------------------

Microsoft SQL Server Management Studio could not start the Snapshot Agent to generate a new snapshot. 
You must start the Snapshot Agent manually before the subscription(s) can be reinitialized.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1&EvtSrc=Microsoft.SqlServer.Management.UI.ReplicationDialogErrorSR&EvtID=CantStartSnapshotAgentForReinit&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

SQLServerAgent Error: Request to run job CYD-DB-01-sam_backoffice_db_02-sam_backoffice_db_02_publica-1 
(from User NET\peter.henell) refused because the job has been suspended.
Changed database context to 'sam_backoffice_db_02'. (Microsoft SQL Server, Error: 22022)

For help, click: 
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600&EvtSrc=MSSQLServer&EvtID=22022&LinkId=20476

Solution:

I just had to restart the SQL Server Agent to get it to work

Comments