Can I add a delay to sql server transactional replication ?

Posted by Brann on Stack Overflow See other posts from Stack Overflow or by Brann
Published on 2010-05-04T15:59:21Z Indexed on 2010/05/04 16:08 UTC
Read the original article Hit count: 254

I've got transactional replication configured from a database called DBProd to another database called DBWarehouse ; everything works fine, and transaction are usually replicated instantaneously to the warehouse .... which is my problem.

I'd like to add a slight delay to the replication (something like 10 minutes), so that the replicated database can be used to access a previous version of the database (in case a bug occurs for example)

Is there a simple way to achieve this ?

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server-2008