Post reply

SQL 2000 standby versus 2005 mirror

  • August 14, 2007 at 7:52 am

    #177997

    In SQL 2000 for a standby server, I would just start SQL in single user mode, restore master (permissions), msdb (jobs, DTS packages), user dbs and rename the server to the machine that failed. I would then be off and running.

    I believe with mirroring, I'd have to update logins etc.. on the mirror when I update them on the principal manually? I only add logins maybe once a month or so. DTS are probably similar and relatively simple exports / imports.

  • August 14, 2007 at 11:55 am

    #726881

    In the case of database mirroring once the principal failovers to mirror server you need to sync and recreate the logins by using SSIS to transfer the syslogins table and restoring it and synch it using sp_change_users_login

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

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

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