Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Replication not working

Unanswered Replication not working

  • Friday, December 28, 2012 5:31 AM
     
     
    Sign In to Vote
    0

    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)

     

All Replies

  • Friday, December 28, 2012 7:14 AM
    Moderator
     
     
    Sign In to Vote
    1

    What is the status showing in Replication Monitor?  The error is stating the job is already running.

    Right-click the job in SQL Server Agent jobs -> Stop Job.  Then try to synchronize.

    Brandon Williams (blog | linkedin)

     
  • Friday, December 28, 2012 9:10 AM
     
     
    Sign In to Vote
    0
    it is showing that subscriber is uninitialized.
     
  • Friday, December 28, 2012 1:29 PM
    Moderator
     
     
    Sign In to Vote
    1

    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

    • Marked As Answer by hari ballamudi Friday, December 28, 2012 2:58 PM
    • Unmarked As Answer by hari ballamudi Friday, December 28, 2012 2:58 PM
    •