Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database Mirroring Expand / Collapse
Author
Message
Posted Thursday, October 18, 2007 12:26 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, May 13, 2014 11:42 AM
Points: 214, Visits: 362
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.
Post #412368
Posted Friday, October 19, 2007 1:40 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 12:33 AM
Points: 4,432, Visits: 4,169
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


Markus Bohse
Post #412596
Posted Saturday, October 20, 2007 9:11 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, May 13, 2014 11:42 AM
Points: 214, Visits: 362
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.
Post #413149
Posted Wednesday, July 24, 2013 1:10 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 8:28 AM
Points: 70, Visits: 322
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...
Post #1477230
Posted Friday, July 26, 2013 8:07 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:07 PM
Points: 5,976, Visits: 12,888
change the owner as part of a planned failover or do it should the database fail over of its own accord.

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

Post #1478022
Posted Friday, July 26, 2013 8:18 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 8:28 AM
Points: 70, Visits: 322
So no...
Post #1478027
Posted Friday, July 26, 2013 8:32 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:07 PM
Points: 5,976, Visits: 12,888
yes, no

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

Post #1478040
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse