Check DB Owner Name

We have successfully setup the mirroring between our primary site SQ1 and SQ02 servers. We have also configured the log shipping from our primary site to our secondary/DR site. It is working fine and we equal no of DBs available on DR site SQL server. These DBs are read only as per the log shipping configuration.

Now, at primary site user “A” is the owner of DBs but at DR site user “B” is the DB owner. seems this attribute is not getting replicated to DR site and we are not able to change the owner manually as DB is read only.
Is there any way to change the DB owner name at DR site without stopping the log shipping ?Yes,As shown in this query you can get owner name.
SELECT SUSER_SNAME(owner_sid) as Owner,* FROM sys.databases


0 comments:

Comment On Facebook