Post reply

SQL 2000 Failover/Failback procedure

  • July 23, 2007 at 9:48 am

    #75164

    Hello,

    We are in the process of verifying our failover and failback procedures. Here is the situation:

    1. We are performing a failover on one of our SQL 2K server DBs located in the default instance. Currently log shipping is active on it and the logs are applied every 15 minutes to the standby server.

    2. We need to make the backup server as primary and point the application to access that server.

    3. After 48 hours we need to failback to the original server and then point the application back to the original server.

    What are the steps I need to perform to do a successful failover/failback?

    Thanks

  • July 23, 2007 at 11:48 am

    #721591

    just backup the tail end of the tran log using with norecovery option......so that the primary will be in restoring state and further tran logs cud be applied.........restore it in secondary using with recovery option so that the secondary will be in R/W mode.......ensure that your syslogins in sec and sysusers are in sync else users cant connect......use dts or bcp to transfer the syslogins from primarys master db.....and use sp_change_users_login to sync the same....also use the sp_change_primary_role,sec_role,monitor_role sps to perform role change.........

    refer http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship2.mspx

    for more detail......cool 

    [font="Verdana"]- Deepak[/font]

  • July 24, 2007 at 7:50 am

    #721915

    If you are not confident on doing the role change and wanted to avoid unnecessary hussles then you can perform this

    1. bring the database in the secondary server up after running the last tlog backup

    2. make your application to point to the secondary

    3. after 48 hours take a backup of the secondary and restore in the primary

    4. then reconfigure log shipping

    though this is not the way that role changing is defined this is the safer method that i have followed and have found no issues till today even the junior dba here was able to do DR as documneted without any of our help.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

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

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