Home Forums SQL Server 2008 SQL Server 2008 High Availability Dear All this post is about logshipping DC- DR Drill [switch over and switch back (or)failover and failback ] RE: Dear All this post is about logshipping DC- DR Drill [switch over and switch back (or)failover and failback ]

  • Hi Robert

    Ineed one confirmation for the alternative step about removing bcp steps suggested by you for [delete the part about copying logins]

    where should i execute this script for mapping the logins after

    SWITCH OVER COMPLETE whether in primary server or in secondary server

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

    EXEC sp_change_users_login'report'

    and

    Exec sp_change_users_login'auto_fix',users

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

    Thanks
    Naga.Rohitkumar