P
P
P_Zeger2016-10-27 21:10:44
High availability
P_Zeger, 2016-10-27 21:10:44

How to create a database archive with an existing Always On group?

Good evening!
The client has the following topology: an Always On group of four servers (primary replica, secondary automatic replica 1, secondary automatic replica 2, secondary manually replica).
It is necessary to copy one of the databases in the group to another server in such a way that an archive is obtained. That is, DML queries of type DELETE must be avoided and records accumulated on another remote server, but in such a way that DELETE queries are executed in the same database in the AO group.
I will be glad to any idea!
Thank you!

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question