| The disaster recovery is the way, which you can use | | | | two server is very high and can not be afforded by |
| to help recover data and information, if any kind of | | | | the small organizations. |
| data loss occurs. Disaster recovery mapping is the | | | | ? If any organization have branches across the globe, |
| work which is devoted to preparing all of the actions | | | | the process is not possible as the servers should be at |
| that must take place in response to a disaster. | | | | same geographical location. |
| In Microsoft SQL Server, failover clustering is the most | | | | ? There is no protection against disk array failure |
| important and widely accepted process of disaster | | | | ? You can not create failover clusters on the object |
| recovery. It is designed to failover automatically when | | | | level. It is possible only on database level. |
| a failure occurs. | | | | Due to given disadvantages, the failover clustering is |
| The failover clustering of SQL Server can be used for | | | | not always safe and the possibilities of server failure |
| creating failover cluster for a single or multiple | | | | and database corruption still exists. In such situations, it |
| instance(s) of SQL Server. It allows the database | | | | becomes mandatory to repair the database for |
| system to automatically exchange the processing of | | | | smooth running of your business. |
| an instance of SQL Server from the failed server to a | | | | The SQL recovery can be performed using the third |
| working one. | | | | party applications known as MDF recovery software. |
| The failover clustering is useful in cases of operating | | | | Using MDF recovery software is the quickest and |
| system failure, database corruption, and database | | | | easiest way to perform SQL repair. |
| system resource up-gradation. It increases the server | | | | Stellar Phoenix SQL Database Recovery is the most |
| availability without downtime. | | | | influential and robust MDF recovery software which is |
| It is the automatic process which occurs in times of | | | | able to repair and restore damaged database in all |
| server failure. For failover clustering, it is necessary | | | | possible situations. Carrying out SQL repair using this |
| that clustered nodes must be geographically near to | | | | software is very easy due to its intuitive and cool |
| each other. It is not useful if a disk array failure takes | | | | looking user interface with prosperous graphical |
| place. | | | | support. |
| Along with the advanced features of failover clustering | | | | An intensive scan of the damaged MDF file is done by |
| disaster recovery technique, there are several | | | | this SQL recovery software using the powerful |
| disadvantages also: | | | | scanning algorithms to end up at absolute MDF |
| ? The programs must be installed in order. If you | | | | recovery. You can repair all of the database objects |
| mistakenly don’t do the same, the server might fail | | | | using this SQL repair software including tables, reports, |
| and you may need to perform recovery by other | | | | forms, queries, macros, stored procedures, and many |
| means. | | | | alike. |
| ? You incur a larger expense. The maintenance of | | | | |