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: 256
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