Home Forums SQL Server 2008 SQL Server 2008 Administration Manually failing over a mirror without access to Primary Server RE: Manually failing over a mirror without access to Primary Server<!-- 864 -->

  • arnipetursson (8/21/2014)


    One more question.

    If you do not have access to server B beyond db_owner in the database,

    how do you ensure that the logins (server principals) are synced?

    As db_owner, you cannot do anything except ask someone else to sort it out (e.g. someone with sysadmin or securityadmin priveleges).

    You would already need to be doing that - mirroring does not do anything about logins. Logins are at the server level, database mirroring is at the database level.