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

P

P_Zeger2016-10-27 21:10:44

High availability

P_Zeger, 2016-10-27 21:10:44

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!