• to modify the Secondary you'll need to perform a LS role reversal to bring the Secondary up. once you complete your actions you'll then need to perform a LS role reversal again to revert back to the original Primary.

    Do you know how to reverse roles in Log Shipping?

    Why not just leave the mirror database as it is for now?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉