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?
2 Tim 3:16
SSCarpal Tunnel
Points: 4541
More actions
June 24, 2009 at 7:18 am
#1014628
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