i have created sql server 2016 DR log shipping with primary always on now customer want to use DR for some time to check everything fine or not Basically it DR fail over testing after cupule of day he want to move to primary only now the question is
1) what about my data which is generated during testing i want to make that sync with primary and start using primary
i know we cant do it again with full backup but my database size in 3TB which very huge
is there any mechanism where i can resorted only theses days data i mean only logs which are generated on DR during testing .
Answer by anthony.green ·
If you took the AG replicas offline using a tail log backup. So you forced them into no recovery as part of the DR failover, then as long as you have the correct log chain still you “should” be able to recover.
If your testing as a true DR and the proverbial has hit the fan situation then it’s a backup restore reversion I’m afraid.