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?

  • I think a log shipping solution may be a little faster. Yes, the users will be knocked off when you restore the tran log (same as snapshot replication) but you're only restoring the tran log and not the entire DB.

    Tim White