Wednesday, March 28, 2012

Need Help about Initial Snapshot

i have created a publication whereas i have provided a network path to its snapshop folder e.g ( \\server\folder ) at time of creating. When i try to make a Pull Subscription and follow all steps of wizards, it gives me following error "The initial snapshot for publication '' is not yet available". can you guide me what are causes of this problem and how may i solve it?

Thanks for help.
Regards,

After you create the publication, you need to start the snapshot agent. The snapshot agent is what creates the files available for subscriptions to use.|||

Dear Greg,

I did the same but when i try to pull the subscription it gives me the error that it can not take the initial snapshot. I also prefer to get snapshots from FTP but it never works. Please help me if you can.

Lookng forward to your reply.

Regards,

|||

Is this merge replication? If so, is it dynamically filtered, which may require a dynamic snapshot to be run?

If you want to use FTP, follow the steps for Configuring a Publication to Allow Subscribers to Retrieve Snapshot using FTP.

|||

Dear Greg,

I am facing the same problem, I am using Merge Replication. After creation of publication when i m trying to connect the server, it gives error of the initial snapshot is not yet available.

|||Just ran into this myself. Once you have everything good, make sure you run the distribution agent. This might fix it. If not, bring up the replication monitor, expand the publications on the left, right-click on the "trouble" server on the right, and check "mark for reinitialization". Then it'll grab the snapshot. You might also need to start the snapshot agent - expand "replication->local publications", right-click on the publication, and select "monitor snapshot agent". Once it comes up, click start.sql

No comments:

Post a Comment