Home Forums SQL Server 2005 SS2K5 Replication In a snapshot replication, users will be able to connect to the replica while replication is running? RE: In a snapshot replication, users will be able to connect to the replica while replication is running?

  • June 23, 2009 at 3:14 pm

    #1014294

    Snapshot Replication might no be a good solution. Since it drops all objects and re-create them, I am sure the users will get disconnected somehow. Not only that, you may encounter some locking/blocking issues on the source server while the snapshot is generating.

    Ed