• Jonathan Marshall (7/8/2011)


    Error message

    Msg 954

    The database x cannot be opened because it is acting as a mirror database

    i am able to change the owner at the principal with no issues, however this does not filter through to the mirror. failover manually and change the owner is how i did it eventually

    That error leads me to believe you ran the command against the mirror database

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

    "Ya can't make an omelette without breaking just a few eggs" 😉