March 26, 2015 at 1:01 am
After setting up log shipping I have noticed the DB owner of the secondary DB is myself (rather than "sa").
I did a manual restore into No Recovery mode before log shipping.
I am not sure if this is a big deal for the Stand-By / Read-Only database?
Is there anyway to change the DB owner now (the DB is Read-Only of course).
If I stop log shipping, and Restore the DB with Recovery, and then change the DB owner, then is there any way to get it back to Stand-By / Read-Only state ready to start log shipping again without a full initialisation?
March 27, 2015 at 7:00 am
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" 😉
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply