Friday, December 28, 2012 5:31 AM
Hi, I am getting this error when I am trying to synchronize subscriber with publisher
SQLServerAgent Error: Request to run job HARI-Hari-snapshothari-Hari\DEV-TestDb-FC2E2F54-9B08-4303-AA0D-B139A369C1F0 (from User sa) refused because the job is already running from a request by User sa.
Changed database context to 'TestDb'. (.Net SqlClient Data Provider)
Friday, December 28, 2012 7:14 AMModerator
Friday, December 28, 2012 9:10 AMit is showing that subscriber is uninitialized.
Friday, December 28, 2012 1:29 PMModerator
It sounds like the snapshot agent is already running. Open up replication monitor, connect with your distributor, then drill down on your publication in the left hand side. On the right hand side, select agents, and then right click on the snapshot agent and select view details - This will tell you the status of your snapshot agent.
Once the snapshot is done it will be deployed to the subscriber via the distribution/merge agent.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941