Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Replication--Command Line Snapshot.exe Parameters

0 views
Skip to first unread message

Curtis

unread,
Jun 25, 2003, 5:46:29 PM6/25/03
to
Could someone tell me why the snapshot agent doesn't start using the
following command?? [REMOTESERVER] is just a fill in...

-- Running the snapshot for replication
use [Master]
exec xp_cmdshell '"C:\Program Files\Microsoft SQL
Server\80\Com\snapshot.exe"
-Publisher [REMOTESERVER]
-PublisherDB [CartonLabel]
-Distributor [REMOTESERVER]
-Publication [Tracker_062003]
-DistributorSecurityMode 0'
GO

It creates the agent just fine but I have to go to EM and manually
start the agent...

BOL states "The Replication Snapshot Agent utility configures and
begins the Snapshot Agent, which prepares snapshot files containing
schema and data of published tables and database objects, stores the
files in the snapshot folder, and records synchronization jobs in the
distribution database."


Thanks,
Curtis

0 new messages