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 ]

  • Your plan is mostly good. delete the part about copying logins (that part is bad .... real bad).

    If you want some more details on this failover process, I wrote an article on it for SQL Server Pro magazine: 3 Log shipping Techniques and have a demo of it on my website.

    For the login stuff, bcp'ing or copying syslogins will not work in SQL 2005+. Just so happens, i have a script for this. In fact this script is even better because it syncs passwords and SIDs for SQL logins and also handles role assignments and explicitly granted server level permissions. You can find that script here: Copy Logins script


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]