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 |
|
donjahns
Starting Member
6 Posts |
 Posted - 2007-11-13 : 17:27:14
|
| I'm trying a re-add 2 pull subscriptons, but I continue to get the following errors:The snapshot for this publication has become obsolete. The snapshot agent needs to be run again before the subscription can be synchronized.When i run the snapshot agent it says it can't find the job to run.Any help would be appreciated. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-13 : 23:14:53
|
| Did you see snapshot job under jobs in em? |
 |
|
|
donjahns
Starting Member
6 Posts |
Posted - 2007-11-14 : 09:14:20
|
| There are two jobs, but one is "x"ed out because of the publication obsolete issue. This is pretty confusing ... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-14 : 23:51:19
|
| Seems need recreate replication. |
|
|
|
donjahns
Starting Member
6 Posts |
Posted - 2007-11-15 : 09:13:16
|
| I've tried to recreate the subscriptions several times with same results How else to I recreate replication? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-15 : 23:34:04
|
| Recreate snapshot. |
|
|
|
donjahns
Starting Member
6 Posts |
Posted - 2007-11-16 : 10:15:51
|
| When right-click on one of my publications and explore the latest snapshot folder there is stuff in the folder from over a month ago. I thought the snapshot folder is cleaned-up routinely. So when I drop and re-add subscriptions the subscriptions are pending because the snapshot for the publication is obsolete. Is that the reason? Should I delete the snapshot folder. I don't know what's happening here. I think it has something to do with having no activity from the subscriber(s) as I can't seem to re-add as I've done successfully many times before. Help! |
|
|
|
|
|
|
Replication Snapshot