You can combine the following products from Microsoft to achieve a comprehensive high-availability solution:
Microsoft SQL Server Standby Database to prevent data loss
Windows Server Failover Clustering to increase availability
For more information about the different solutions, see the SQL Server Books Online.
You can use either use each high-availability solution separately or you can combine them. For more information about how to set them up, see the SQL Server Books Online.
The following graphics give examples for various combinations:
“(A)SCS” means either the ABAP central services instance (ASCS) or the Java central services instance (SCS).
Each high availability solution has its own strengths and weaknesses, as shown in the following table.
This might help you to decide which solutions suits you best and whether you want to use them separately or combine them. For more information , see also the SQL Server Books Online.
Strengths |
Weaknesses |
|
---|---|---|
Database Mirroring |
|
|
Standby Database |
|
|
Windows Server Failover Clustering |
|
|