Groups | Blog | Home
all groups > sql server replication > november 2004 >

sql server replication : snapshot files are obsolete


Martin
11/18/2004 6:11:23 PM
Why can I make publications not to show this error. "You must rerun snapshot
because current snapshot files are obsolete." I want them to start
automatically and to generate the new snapshot file automatically.

thnx for your time



Martin

fvargas NO[at]SPAM onlinemicrosoft.com
11/19/2004 9:52:56 AM
The obsolete snapshot meesge is thrown if the distribution/merge agent is
trying to apply the snapshot but found that it is older than the retention
periof.

You need to reinitialize in the order:
reinitialize your subscriptions (sp_reinitmergesubscription)
re-run the snapshot agent to create a new snapshot (you can do this by
running sp_start_job ...)
re-run distribution/merge agent to apply the new snapshot

sp_reinitmergesubscription does not automatically run the snapshot for you.
AddThis Social Bookmark Button