Posted by Paul Ibison on 04/17/07 19:09

I'd recommend transactional replication with a nosync initialization. This
is where the initial setup on the reporting server is achieved by using a
restore of the database and after that, only subsequent changes are sent
down. If you are using SQL Server 2005, greater concurrency can be achieved
by using the read committed snapshot isolation level.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

• Next in forum: Re: DB Replication or Table Replication via triggers?
• Prev in forum: DB Replication or Table Replication via triggers?
• Thread view: Re: DB Replication or Table Replication via triggers?

[Reply to this message]