Looking for intro document on high availability options for SQL RRS feed

  • Question

  • Hello,


    I'm a newbe to SQL and am looking for an intro documents for high availability options for SQL server.


    Our goal is to set up up some kind of fail over. We want to have a duplicate of our primary db maintained more or less real time on a 2<sup>nd</sup> server.  This will permit a working backup of the primary db and an ability to use the 2<sup>nd</sup> server should the first server goes off line.


    Part of the plan is for the 2<sup>nd</sup> server to be at a remote location, connected by a VPN.


    Any guidance on this would be appreciated.


    Thank you.


    Friday, September 30, 2011 6:59 PM


All replies