October 18, 2007 at 12:26 pm
I came across DB Mirroring where the owner of the database is different in principal & mirror. So i hav e to Sync up Database owner of MIRROR with Principal. Can i change on the fly the owner of Database in Mirror or i have to break the mirror or i have to redo mirror from scratch.
any input is appreciated. thanking in advance.
October 19, 2007 at 1:40 am
I don't think you can change the database owner of a mirror database. The mirror is in a non-recovered state so you can't run any statements against it.
You could change the owner of your primary database if that's an option or just leave it. As far as I remember it's not required that both databases have the same owner and the simple fact that to setup mirroring you have to restore a backup on the mirror server, will cause in most cases that the owners are different.
On my servers I always have "sa" as the owner of all databases, but when I restore a database initially I will become the owner, because we never logon as "sa".
Markus
[font="Verdana"]Markus Bohse[/font]
October 20, 2007 at 9:11 pm
finally after doing test i was successfull to change DB Owner for Mirror DB.
My DB Mirror is setup for High Performance(No Witness)
For each DB, did following steps.
1> Backup DB on Principal server
2> On principal server, change High Performance to High Saftey-- cLick OK
3> On Principal, Manual Failover to Mirror Server
4> sp_changedbowner on Mirror Server for that DB---will encounter error msg 10054--- run
sp_changedbowner again & that will change\fix.
5> After Changing owner, failover back to Principal
6> On Principal, Change High Saftey to High Performance-- cLick OK
Was able to do the same for all remaining DB.
I hope this will help others for there future reference.
July 24, 2013 at 1:10 pm
So is there a way to do this on the mirrored database without failing over first?
Our principal has a different owner then our mirror. The principal is the correct owner already, so I ran both the sp_changedbowner and alter authorization commands with success. However the mirror still says a different owner. I thought this information would be replicated to the mirror.
We can't fail over at the moment, CLR's don't work as this other owner so I need to change it on the mirror. Thanks...
July 26, 2013 at 8:07 am
change the owner as part of a planned failover or do it should the database fail over of its own accord.
---------------------------------------------------------------------
July 26, 2013 at 8:18 am
So no...
July 26, 2013 at 8:32 am
yes, no
---------------------------------------------------------------------
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply