Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ex
Posting Yak Master
166 Posts |
 Posted - 2005-04-25 : 23:06:35
|
| Hey all,just a little question I just created a working replication well at least i think i didI get the publisher setup fineI pushed a subscription fine, howeverAfter I when through the push subscription wizard (all worked)my subscription status is Pending?? the tutorial i followed http://ouriran.com/snapshot.cfm says it should be active and i followed it sep by step why would the status be pending? or how can I make it active?P.S it is a snapshot replication |
|
|
Ex
Posting Yak Master
166 Posts |
Posted - 2005-04-26 : 00:24:52
|
| just a side note even after i start the agent i still got status pending under (enteprise manager -> replication -> publications (my publication) |
 |
|
|
JamesH
Posting Yak Master
149 Posts |
Posted - 2005-04-26 : 07:37:28
|
| Unless you select the checkbox to start the initialization process immediately you will have to wait until the scheduled job fires off. You can also go to the job in SQL Server Agent and fire it off manually.It is in the step Push Subscription Wizard.Set Distribution Agent Schedule on the tutorial you listed. Remember, this is for snapshot replication which is not a continuous update, if you need that then your best bet would be Transactional Replication.HTH,JamesH |
|
|
|
JamesH
Posting Yak Master
149 Posts |
Posted - 2005-04-26 : 07:41:50
|
| Forgot,Make sure you fired off the right agent, initially, the snapshot agent. After that is done, you'll need to make sure your distribution agent is successfully started.JamesH. |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-04-26 : 07:58:05
|
| Note: If you do use a push subcription do not try to push it out to the subcriber untill the snapshot completes on the publisher.JimUsers <> Logic |
|
|
|
Ex
Posting Yak Master
166 Posts |
Posted - 2005-04-26 : 19:07:03
|
| ah its ok all good now :) after playing with it my understand is better, thanks all it was working fine just didn't realise it said pending for my snapshot and active only when it actually runs :) though it should say active as soon as i turned on the agent and keept active as long as the agent was scheduled to repeat :)Thanks for ya help guys |
|
|
|
|
|
|
Replication Pending?