Post reply

how??

  • February 4, 2012 at 7:32 am

    #256188

    HI,

    Im configuring mirroring for shrepoint 2010.

    loged in through windows auth.

    took bakups.

    restored in mirror.

    configured mirroring .

    but issue im facing is , im not able to change he DB owner in mirror server,Its showing the dbowner as my login not the actual owner.

    How can i change owner to actual owner?

  • February 4, 2012 at 8:16 am

    #1442749

    You cant do this whilst in a read only state. You will need to resync the mirror doing a fresh restore whilst connected as SA.

  • February 4, 2012 at 9:47 am

    #1442760

    Have you tried failing over the mirroring so that the DB you want to change is the principal and seeing if you can change it there?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 6, 2012 at 5:06 am

    #1443018

    Every thing about Mirroring here

    http://technet.microsoft.com/en-us/library/cc917680.aspx

Viewing 4 posts - 1 through 3 (of 3 total)

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