SQL Server Performance

Transction replicationc problems

Discussion in 'Performance Tuning for SQL Server Replication' started by yrnath, Jun 19, 2004.

  1. yrnath New Member


    I apply transactional replication to my database, first time it created snap shote but it take longe time to create snapshots and apply snapshot on the subscriber. This is very time and Resources taking process. So, I want to avoid snapshot in my transactional replication.I can make the subscriber ready by restoring the backup of the publication database.we tried that also but it is giving error at executing the replication procedures. Is there any solution to implement the transactional replication without snapshot or with out transfering the data.

  2. satya Moderator

    What was the error during this process?
    And checkout for any intermittent network errors that may contribute to this issue.

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page