Post reply

Users and Passwd after Failover.

  • July 18, 2016 at 7:42 am

    #328302

    Good Morning,

    I want to execute an store procedure on master before an automatic fail-over take place on the mirrored database

    The script is dbo.sp_help_revlogin for non autenticated users after failover.

    How can I accomplish this ?

    Thanks

    Paul Vidal

    DBA

  • July 18, 2016 at 8:53 am

    #1890619

    I don't think you can do that during an automatic failover.

    I'm pretty sure I wouldn't want to try. Why risk an error that could delay or interrupt the failover process?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • July 18, 2016 at 10:16 am

    #1890651

    For automatic failovers, the master might not be there. So you can't ask for something to run and move logins.

    What you should have is a process to move new logins over every day (hour/week/whatever) to the secondary node.

  • July 18, 2016 at 8:52 pm

    #1890750

    This is why you shouldn't install SQL Server on local hard drives like the C: drive.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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