Home Forums SQL Server 2014 Administration - SQL Server 2014 What kind of technology should i use? RE: What kind of technology should i use?

  • August 23, 2017 at 7:58 am

    #1956378

    SQL_Hacker - Wednesday, August 23, 2017 7:49 AM

    What version of SQL Server are you using? If it's 2012 or higher, you can use AlwaysOn, which uses mirroring as one of it's foundational bases, but also includes High Availability (HA) of Windows Clustering technology to allow the ability to have automatic failover without the need for a witness server.

    We can offer more specific solutions to your problem if you provide more specific details about the problem you're trying to solve.

    Yes version will be 2012 or higher most likely it will be 2016...
    So i have a data entry application, that just reads and write to the database, but it is very important for it to be up 24/7 so if the main server crashes, i need to be able to run that application on a backup server and keep on working, and after the primary comes backup, all the data and changes made on the backup must go to the primary, almost like with mirror.

    Im going to read about this AlwaysOn