For many businesses, get high availability is a common demand. Solutions applicable to a particular scenario depends on many factors, in a performance situations the best solution is not necessarily in other situations is the most suitable. For example the following scenarios:
◆ Internet-based sports goods retailer to offer its customers similar to continuous availability. Web server has been added to the Web site, but will produce a database failure error, most of the time these cases will lose its customers. The company has approved the standard server version, hoping to avoid spending a lot of money, change the basic structure or rewrite applications.
◆ executive search firm is concerned about its customer database user encountered an error. Although there is no immediate need to implement recovery, but the company still hopes to have a quick online access to the warm standby server.
◆ insurance claims database to approximate their continuous availability. The performance of the system must not be affected, and currently stored in the file system to support the claims of the document also must be available.
◆ management training company has three sites, each site has a sales team. Sales team will enter their respective sites, the Orders in the database. To improve performance, requires each site to the local server access on all orders. When failure to provide availability, each site must be able to switch to another site server.
◆ accounting firm hope that in the event of failure (such as natural disasters) can provide availability to its customers. Information not immediately available, but should be available within a few days rather than hours. Every day the company would like to save the information in the database to meet regulatory requirements. Do not need to copy the data immediately available, but in many years are available.
◆ toy manufacturers want to sell the database according to the preparation of reports, but because the database has been in use, so the process of preparation of the report will normally be interrupted by the current transaction being executed. The company hopes to trade for the preparation of reports not submitted, but will produce incorrect results, because some transaction is not complete.
◆ real estate companies want to protect the system when the user errors, hoping to restore the previous day's record values. The company would also like to be able to data compiled according to the report the day before, because they will not be day trading. Under ideal circumstances, the company hopes to implement a disk solution for the least cost.
According to a variety of availability requirements, businesses need a solution for high-availability database platform to provide flexible options. The white paper, you can see SQL Server 2008 Always On technology to provide flexible options for high availability to enable enterprises to implement under the best solution for specific needs.