Board index MS SQL Server

Merge Replication Snapshot Agent

Merge Replication Snapshot Agent

Post by Conni » Thu, 28 Feb 2002 01:44:23



Does the Snapshot agent for a Merge Replication need to run every week once
the initial schema is set up?  By default the agent is set to run every
saturday, is this necessary?
 
 
 
Top

Merge Replication Snapshot Agent

Post by raju girdh » Thu, 28 Feb 2002 08:55:02


Hello Connie,
To answer your question, the Snapshot agent technically does not need to
run after the initial synchronization. There is no harm however, in running
the Snapshot agent as per its default schedule as the Snapshot agent would
do no processing unless a new subscription was added or schema change was
made.

Hope this helps.

Raju Girdher MCSE
SQL Support Engineer, Microsoft

Please reply only to newsgroups. When posting, please state the version of

error message text received, if any.

Disclaimer:
This posting is provided AS IS with no warranties, and confers no rights.
You assume all risk for your use. ? 2001 Microsoft Corporation. All rights
reserved.

 
 
 
Top

1. Merge Replication - SNAPSHOT agent fails with sa login

Hi,

Would greatly appreciate a tip on how to troubleshoot this bug
with the signin.

I looked at the properties for the SQL SERVER AGENT and the
user was  domain\sqladmin

In Replication Monitor on the Publishing Server NTSERVER6
Publishers
        NTSERVER6
                Publication1
                Publication2    
                ...
                Publicationn

Each of these levels has a RED X Icon to indicate failure.

Snapshot Agent Error Details

        Publisher: NTSERVER6

        Last Action: The process could not connect to Publisher NTSERVER6

        Full Error Message:  Lgoin failed for user 'sa'

Appreciate some tip on WHERE the sa login is used during this process
or how to resolve this.

Thanks, Paul

2. Resync method: problem with joins

3. Merge Replication - Error for Snapshot Agent

4. Identity Columns as Foreign Keys?

5. SQL Error -- Snapshot Agent in Merge Replication

6. MySQL archiving

7. Snapshot agent failure in Merge Replication

8. Looking for Oracle/SilverStream stored procedure example

9. One of publication listed under Replication Monitor/Agents/Merge Agents was automatically removed

10. snapshot agent error: Another snapshot agent for the publication is running

11. Merge Replication : Merge Agent fails with Garbled sp name errors

12. Merge Agent fails propagating the snapshot

13. snapshot and merge agent


All times are UTC
Board index