question

surendra4y avatar image
surendra4y asked

Revers log shipping in 2016 with al ways on

dear all,

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 .

logshipping
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
anthony.green avatar image
anthony.green answered

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.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.