Database Mirroring

  • 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.

  • 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]

  • 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.

  • 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...

  • change the owner as part of a planned failover or do it should the database fail over of its own accord.

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

  • So no...

  • yes, no

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

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply