SQL Server Performance

restart transactional replication from cmd line

Discussion in 'Performance Tuning for SQL Server Replication' started by pommer452, Jan 4, 2007.

  1. pommer452 New Member

    hi,

    i set up transactional replication on sql server 2000. It works fine for example for a table. Now my destination db is refreshed everynight, and i want then the replication to be immediatly rebuilt (meaning a new snapshot) just after. the issue i have is that i don't know how to do it from script , only selecting initializing again from the sql entreprise manager. If i don't do this , my replication is still broken.

    Tks for your help

  2. satya Moderator

    Check the SQLAgent job scheduling in this case to perform such updation.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  3. pommer452 New Member

    tks , i found how to do it :

    EXEC sp_reinitsubscription
    @subscriber = 'servername',
    @destination_db = 'dbname',
    @publication = 'publication name';

Share This Page