| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-11-12 : 08:52:08
|
| Douglas writes "I am trying to setup a snapshot replication between sql2000 and msde. I am trying to accomplish this through a VB.Net program. Everything appears to be working....the snapshot is generated on the publisher and when the distributor attempts to get it to the subscriber, I get the following error: "The subscription to publication 'TestSnapshotPublication' has expired and does not exist." How can a subscription expire...if I just set it up? In fact, I checked the box on the publication to not Expire....so, am I missing something else?Thanks...." |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-11-12 : 12:50:09
|
| May be the VB.net proggy your using.Although my first question would be, which machine are you running as the distributor? is it the standard one machine is publisher/distrib and the other is the subscriber? It's also possible that you got the snapshot replication as a one time thing to setup soemthing such as merge or transactional replication. I'm kinda shooting in the dark though... I'll need more info about what you have got going there before I can give a more definative answer. Could even be permissions.Email me or post on this board... whatever you feel more comfortable doing.-----------------------SQL isn't just a hobby, It's an addictionEdited by - m.e. on 11/12/2002 12:58:08 |
 |
|
|
dhw
Constraint Violating Yak Guru
332 Posts |
Posted - 2002-11-12 : 14:12:15
|
| Thanks for the response!I can post or send via email the vb.net program if that would help.The topology is: Server #1 = SQL2000 Publisher and Distributor Machine #2 = MSDE SubscriberThe snapshot publication was only setup as a snapshot...there are no other publications even defined on the server.Permissions...hmmmm....I suppose that is possible too. But I just don't have enough experience with replication to figure that one out. When I set up the publication, I defined it to all for pull subscriptions and the user name/password I am passing via the program has been entered into the PAL.Besides the .net program...what other information can I provide that might help you troubleshoot this problem?Thanks again,Douglas |
|
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-11-13 : 12:36:29
|
| Hmm, kinda drawing blanks on this one actually. I'll keep looking around for you, but that is kinda strange/obscure. It may be the vb.net thats doing it, but I couldn't be sure. I'll keep looking around and will contact you if I find anything... But I'm outa ideas on this one.. srry man-----------------------SQL isn't just a hobby, It's an addiction |
|
|
|
dhw
Constraint Violating Yak Guru
332 Posts |
Posted - 2002-11-13 : 16:59:00
|
| Well...thanks for trying!At this point, I don't know what to do. I have gone through the process (twice) of disabling and removing all my replication configuration on the server and still the same result. And...the fact that no one else on any of the other newsgroups and forums have even attempted to answer me (you're the first and only one) I gotta' believe that no one else has encountered this before and doesn't even know where to begin to look.Thanks again,Douglas |
|
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-11-14 : 11:44:56
|
| I'd consider ditching the vbnet proggy and doing it using just sql (got enterprise manager?)Other then that.. I still haven't found anything...-----------------------SQL isn't just a hobby, It's an addiction |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-11-14 : 12:56:17
|
| I found this - would give the link but I can't find it again so don't even know whether it was about v2000.You need to increase the transaction retention on your distribution database. You can do this by selecting the server your distribution database is on, selecting replication from the tool menu, and then configure publishers, subscribers, and distribution, and click on the properties button on the distributor tab. The subscriptions never expire option is a little misleading. Another possibility is that a different one of your subscriptions isn't set up for never expire. I have found that if one subscription expires, all the subscriptions are expired. ==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
dhw
Constraint Violating Yak Guru
332 Posts |
Posted - 2002-11-14 : 13:34:17
|
| Hey, thanks for the info! I'll try that out - and I'll see if any other publications still exist that have a different expiration setting.douglas |
|
|
|
Tim
Starting Member
392 Posts |
|
|
dhw
Constraint Violating Yak Guru
332 Posts |
Posted - 2002-11-15 : 15:50:53
|
| Tim...Hey, thanks for the links to those articles. I'll check them out and see they can help.regards,..Douglas |
|
|
|
|
Replication: Subscription expires? 