question

EdisonTamayo-7212 avatar image
0 Votes"
EdisonTamayo-7212 asked learn2skills commented

Sql server 2016

Hello, could you please help me with the following question, what we would need to build DRP for sql server 2016 Enterprise edition on premise, also what we need to build HA for sql server 2016 Enterprise edition Thanks

sql-server-generalwindows-server
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @EdisonTamayo-7212, we have not get a reply from you. Did the answers could help you? If there has an answer helped, do "Accept Answer". If it is not work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·

To follow-up, Please let us know if you have further query on this.
Please don’t forget to Accept the answer

0 Votes 0 ·
learn2skills avatar image
0 Votes"
learn2skills answered learn2skills edited

Hi @EdisonTamayo-7212
Thank You for posting in Q & A.

A good SQL Server disaster recovery plan must take into account numerous factors: sensitivity of data, data loss tolerance, required availability, etc. The plan can be based on few a solutions:

  1. Failover clustering

  2. Database mirroring

  3. Database Replication

  4. Log shipping

  5. Backup and restore

  6. Always On Availability Group
    Introduced in SQL Server 2012, Always On Availability Groups (availability groups) provide database-level protection by sending each transaction of a database to another instance, known as a replica, that contains a copy of that database in a special state. An availability group can be deployed on Standard or Enterprise Editions. The instances participating in an availability group can be either standalone or Always On Failover Cluster


If the Answer is helpful, please click Accept Answer and up-vote, this can be beneficial to other community members.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered

Hi @EdisonTamayo-7212,

Always On Availability Groups is an enterprise-level high-availability and disaster recovery solution introduced in SQL Server 2012 to enable you to maximize availability for one or more user databases. Always On Availability Groups requires that the SQL Server instances reside on Windows Server Failover Clustering (WSFC) nodes. Please refer to SQL Server 2016 Step by Step: Creating AlwaysOn Availability Group to get more information.

Microsoft provide some business continuity solutions for high availability and disaster recovery in SQL Server. Please refer to Business continuity and database recovery - SQL Server to get more information, see below:
79031-dr.png

Best regards,
Carrin


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



dr.png (108.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AlexBykovskyi avatar image
0 Votes"
AlexBykovskyi answered

Hey,

Always On Availability Groups would be a great choice to build HA SQL server. The following guide might help:
https://www.sqlservercentral.com/articles/steps-for-installing-alwayson-availability-groups-sql-2019

Another alternative is to build SQL FCI, which requires shared storage and provides an instance level HA. Check the following guide for the configuration process:
https://www.starwindsoftware.com/resource-library/starwind-virtual-san-installing-and-configuring-sql-server-2017-failover-cluster-instance-on-windows-server-2016/

Cheers,

Alex Bykovskyi

StarWind Software

Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.