locked
Always ON High Availabilty RRS feed

  • Question

  • Hi Everyone,

        In AlwaysOn HighAvailabilty if any problem or disaster will happen in Primary Server.It got failover to sencondary replica.

        But in the secondary replica we have give read option only.Not write option.Then how to if we want write anything in the       DB. 

    Thanks Everyone,

    RamKarthik

    Thursday, June 26, 2014 7:24 AM

Answers

  • Hey RamKarthik,

    There are a number of options related DR (disaster recovery), you should read more link below:
    http://support.microsoft.com/kb/822400
    http://technet.microsoft.com/en-us/library/ms179344(v=sql.105).aspx

    If you choose for example the following type,
    it requires three servers but will give you a good answer and safe. 

    first server is active, MIRROR second and third listen the first 2 server (witness)
    so the transition will be automatic and smooth. 


    High-Safety Mode with Automatic Failover

    Automatic failover provides high availability by ensuring that the database is still served after the loss of one server. Automatic failover requires that the session possess a third server instance, the witness, which ideally resides on a third computer. The following figure shows the configuration of a high-safety mode session that supports automatic failover.

    The witness and two partners of a session


    Please Mark This As Answer if it helps to solve the issue

    Tzuri Ben Ezra | My Certifications: CompTIA A+ ,Microsoft MCP, MCTS, MCSA, MCITP |
    FaceBook: Tzuri FaceBook | vCard: Tzuri vCard | 
    Microsoft ID: Microsoft Transcript 
     |
     

    • Proposed as answer by Sofiya Li Friday, June 27, 2014 8:13 AM
    • Marked as answer by RamKarthik DBA Friday, June 27, 2014 1:52 PM
    Thursday, June 26, 2014 7:47 AM
  • This works based on the failover modes...

    http://blogs.msdn.com/b/usisvde/archive/2012/02/24/how-to-give-your-application-high-availability-disaster-recovery-using-alwayson-with-sql-server-2012.aspx

    http://msdn.microsoft.com/en-us/library/hh213151.aspx

    http://msdn.microsoft.com/en-us/library/ff877957.aspx


    Raju Rasagounder Sr MSSQL DBA

    • Proposed as answer by Sofiya Li Friday, June 27, 2014 8:13 AM
    • Marked as answer by RamKarthik DBA Friday, June 27, 2014 1:50 PM
    • Unmarked as answer by RamKarthik DBA Friday, June 27, 2014 1:50 PM
    • Marked as answer by RamKarthik DBA Friday, June 27, 2014 1:51 PM
    Thursday, June 26, 2014 7:36 AM

All replies

  • This works based on the failover modes...

    http://blogs.msdn.com/b/usisvde/archive/2012/02/24/how-to-give-your-application-high-availability-disaster-recovery-using-alwayson-with-sql-server-2012.aspx

    http://msdn.microsoft.com/en-us/library/hh213151.aspx

    http://msdn.microsoft.com/en-us/library/ff877957.aspx


    Raju Rasagounder Sr MSSQL DBA

    • Proposed as answer by Sofiya Li Friday, June 27, 2014 8:13 AM
    • Marked as answer by RamKarthik DBA Friday, June 27, 2014 1:50 PM
    • Unmarked as answer by RamKarthik DBA Friday, June 27, 2014 1:50 PM
    • Marked as answer by RamKarthik DBA Friday, June 27, 2014 1:51 PM
    Thursday, June 26, 2014 7:36 AM
  • Check this link, about its operation and all.

    http://msdn.microsoft.com/en-in/library/ff877884.aspx


    Santosh Singh

    • Proposed as answer by Sofiya Li Friday, June 27, 2014 8:13 AM
    Thursday, June 26, 2014 11:40 AM