"How will you detect and prevent logical corruption in an active database copy from replicating to the passive copies of the database? What
is your recovery plan for this situation? How frequently has this scenario occurred in the past? If logical corruption occurs frequently in your organization, we recommend that you factor that scenario into your design by using one or more lagged copies, with
a sufficient replay lag window to allow you to detect and act on logical corruption when it occurs, but before that corruption is replicated to other database copies."
In all of my years i have never once restored a db from backup due to logical corruption, but this very question came up in a Sales meeting yesterday. "How do we mitigate logical database corruption?" We are currently running with three
copies and using Exchange Native Protection, but now I'm starting to question our decision, and to add a 4th lagged copy would require an extensive amount of rework and additional hardware.
So the question:
Has anyone running a large 2010 installation experienced a a corruption issue that was replicated to all copies of the db?