SQL Server Disaster Recovery & High Avalability
SQL Server Availability Minimize the complete downtime, speed up recovery process and achieve the appropriate level of availability defined by service level agreements
Selecting the appropriate Disaster Recovery site is one of the most important decisions made during the disaster recovery planning process. The decisions vary from organization to organization based on factors such as organization cost vs. benefit strategy, type of applications used, sensitivity of the data, the amount of risk the company is willing to take, the amount of time the organization is ready to invest in restoring the business operations and many more. While making the above decisions, you must always consider the organizations business objectives and the criticality of continuity and viability of the business. Financial institutions, healthcare providers and other organizations engaged in time-sensitive computing activities may require making sizable investments to avoid a few hours of down time, which may not be the case in other environment. In conclusion, for every organization it is important to carefully consider specific business needs along with the costs and capabilities of each site option when identifying the best approach for their business.
SQL Server Availability Minimize the complete downtime, speed up recovery process and achieve the appropriate level of availability defined by service level agreements
- SQL Server Clustering (Active/Active, Active/Passive)
- Database Mirroring
- Log Shipping
- Replication
Selecting the appropriate Disaster Recovery site is one of the most important decisions made during the disaster recovery planning process. The decisions vary from organization to organization based on factors such as organization cost vs. benefit strategy, type of applications used, sensitivity of the data, the amount of risk the company is willing to take, the amount of time the organization is ready to invest in restoring the business operations and many more. While making the above decisions, you must always consider the organizations business objectives and the criticality of continuity and viability of the business. Financial institutions, healthcare providers and other organizations engaged in time-sensitive computing activities may require making sizable investments to avoid a few hours of down time, which may not be the case in other environment. In conclusion, for every organization it is important to carefully consider specific business needs along with the costs and capabilities of each site option when identifying the best approach for their business.