Snapshot agent Agent

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Kristy (pleasereplyby_at_posting.com)
Date: 02/28/05 

Date: Mon, 28 Feb 2005 11:18:34 -0500

Does the snapshot agent have to run if I already have a copy of the database
on the subscriber? We are doing a push subscription on transaction
replication.
I don't remember it running before, but today it is.

--Kristy

Relevant Pages

  • Re: Best way to worj with replication
    ... When i sed the push subscription to work immediatly when the chages are done ... be the publisher, the changes are being done on the subsciber in 3 seconds, ... if i will run the replication on the entire database, ...
    (microsoft.public.sqlserver.replication)
  • Error 208 adding a push subscription to a merge publication.
    ... I am having a slight issue with adding a push subscription to a merge ... I have enabled replication and created the publication on the ... server that is going to act as the publisher. ... The source database does not contain this view either. ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL Server replication with remote access database
    ... > Looking for a book on SQL Server replication? ... >> I am trying to perform database replication between the SQL and access ... When I perform push subscription, ...
    (microsoft.public.sqlserver.replication)
  • Error 21060 with SQL Server / MS Access Replication
    ... I am trying to establish replication between a SQL Server ... database and a Microsoft Access 2003 database. ... When using the Push Subscription Wizard, ... Server Subscriber 'ODBC1' does not support parameterized ...
    (microsoft.public.sqlserver.replication)
  • Re: Real Time Backup Practises
    ... I recommend you to perform a transactional level backup every 10 minutes ... have the most recent data backed up in a real time system with less cost. ... Transactional replication with PUSH Subscription. ... > The best I can provide right now is a 1 hour interval transaction log ...
    (microsoft.public.sqlserver.server)