0

I am trying to establish a pull transactional replication using SQL Server 2008 R2, I have a local DB and a Remote DB, I am using UNC file share for the snapshot.

All are running with no errors, however the publisher on the remote server is showing:

The initial snapshot for article is not yet available.

I run the View Snapshot Agent Status and it shows:

[100%] A snapshot of 1 article(s) was generated.

What is going wrong?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Hasan Shouman
  • 2,162
  • 1
  • 20
  • 26
  • try starting distributor agent job – TheGameiswar Nov 16 '16 at 11:12
  • The distributor on the local machine(Since I use pull replication)? How can I start it ? – Hasan Shouman Nov 16 '16 at 11:14
  • yours is a push replication,just start distributor sql agent job – TheGameiswar Nov 16 '16 at 11:16
  • Hows it Push ?, the properties show this: Distribution Agent Location: Subscriber – Hasan Shouman Nov 16 '16 at 11:17
  • and how to start the distributor sql agent job? – Hasan Shouman Nov 16 '16 at 11:18
  • Via SSMS connect to the Publisher, Under Replication folder go to Local Publications , expand that and then go to the publication , right click and launch the `Replication Monitor`, In replication monitor go to the Subscribers tab and click on the subscribers you are having issues with, see in the details sections what error it is showing? Its more likely to be permissions error by the sound of it. – M.Ali Nov 16 '16 at 11:18
  • @M.Ali no erros at all ..All status are OK, performance is Excellent – Hasan Shouman Nov 16 '16 at 11:22
  • Make sure your `Log Reader Agent` account and `Snap shot agent` account has full control on the `Snapshot share` also make sure both of these accounts are member of `db_owner` role in `Publisher , subscriber and most importantly in Distribution` databases – M.Ali Nov 16 '16 at 11:22
  • Ah in that case connect to the `Subscriber` from SSMS and see the job history for the log reader agent job, you will probably see an error there saying `cannot connect to the distributor` etc – M.Ali Nov 16 '16 at 11:24
  • @M.Ali The job history is running and says "The replication agent has been successfully started. See the Replication Monitor for more information." – Hasan Shouman Nov 16 '16 at 11:30
  • @TheGameiswar I checked the Job and it is already running – Hasan Shouman Nov 16 '16 at 11:31
  • Why I have this message at the publisher: The initial snapshot for article is not yet available. ( the database is only one table for testing) – Hasan Shouman Nov 16 '16 at 11:32

0 Answers0