Sync_Type = none Versus Automatic

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  February 10, 2003 at 1:39 pm

  #80823

  Hi to all:

  I'm administering the central SQL Server witch replicates to another 74 SQL Servers, and also is subcribed to 3 publications of each server.

  Last weekend, because of a big storm, we loose some SQL servers. once the servers are ready, i'm planning to re subscribed the servers with sync_type = none, to avoid aplying snapshots. I know that I will have replication errors because some things that are in the central won't be in the subscribers, but i prefer that than aplying the snapshot. The snapshot can be very big, and I think that it's going to be better this way. They are all SQL Servers 2000, with Transactional replication with no updates.

  Any advice?

  Thanks

• February 13, 2003 at 8:00 am

  This was removed by the editor as SPAM