Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are the high-availability options in SQL Server 2008?

April 26, 2017high-availability Options SQL Server

0

Posted

What are the high-availability options in SQL Server 2008?

1 Answer

0

Posted

SQL Server 2008 has four technologies that can provide high availability: failover clustering, database mirroring, log shipping and replication. Some of them, such as failover clustering, protect the full instance of SQL Server. Others, such as log shipping and database mirroring, protect at the database level. In addition, some of the high-availability technologies offer automatic failover, which is seamless to the client and application. Most SQL Server experts believe that replication can be used for high availability, but it is best used for distributing data between SQL Server instances or systems.