snap shot agent refuses to snap new articles.

Hot Topic

SQL Server 2000 Enterprise Manager View Creation error.
how to retrieve inserted rows in sql server 2000
Can't drop trigger assembly
Line Graph One Data Point
Merge Replication Weird Scenario?
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance
SQL Server 2005 Express Installation Problem: Incompatible components from beta version of .NET Framework
Convert MS Access(*,mdb) to SQL Server Database
Error when restoring database
Using SQL Profiler to trace sp_executesql statement

SQL Server

Some kind of row versions in triggers?
Express cannot convert different data types automaticly????
SQL2005: Reource database
What is the best way for users to view cubes?
How to retrieve data from query and link the data to a data number?
SSIS Foreach loop stress testing problem.
I hate this
SQLConnect to SQL Server fails when connection intialized from a service
SQL Server 2005 data export wizard did not transfer stored procedures
help , please ,problems with sql 2005 expresse

snap shot agent refuses to snap new articles.

Hi There

This refers to SS2000.

I have the following problem.
I added 3 new articles to a publication, then i normally start the snapshot agent which snaps over the 3 new articles.
I did this on 2 other servers before this one with identical publications , distributors etc, everything exactly the same and it all worked 100%.

After the snapshot agent copies them over they replicate as per normal.

With the 3rd server it refuses to create a snapshot of the 3 new articles when a start the agent.
BUT the distribution agent now fails because it is trying the exeute the replication stores procedure for the articles, but they were never created because the snapshot agent will not run (and it creates the sp's for the new articles on the subscriber).

PLEASE HELP ! All i need is for the snapshot agent to kick in and snap the 3 new articles but it wont.
It simply says a snapshot was not generated cos no subscription needed re-initialization, but this does not apply as when new articles are added it snaps them over, and that is exactly what it did for the other 2 servers

There are no errors that iu can find either .


Thanx




Answer this question

snap shot agent refuses to snap new articles.

  • Gary Cabana

    Hi Sean,

    My guess is that you haven't added the subscription for the three new articles (use sp_addsubscription if you can't find out how to do it through the UI). Can you try that and let us know how that goes  Thanks.

    -Raymond 

  • gift

    Hi Sean,

    It sounds like you have inadvertently added no-sync (do not require schema and initial data hence snapshot will not be generated) subscriptions for the new articles. Was your orignal subscription created with "no schema & data" option In any case, you can probably get out of the current state by dropping the (no-sync ) subscriptions that you already have and re-add them with a sync_type of 'automatic'.

    HTH

    -Raymond

  • Secrets

    Hi Raymond

    If this were true way would the distribution agent at the subscriber be failing due to the fact that it cannot insert a row to the new article because the snapshot has no created the necessary sp_MSins stored procedures.Seems as though the subscriber is fully aware of the articles but because the snapshot has not occurred the neccesary sp's for replication at the subscriber have not been created

  • snap shot agent refuses to snap new articles.
Answer this question