http://www.sqlservercentral.com/Content tagged High Availability posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Database Mirroring was released with SQL Server 2005 and is becoming a popular choice for a failover solution. One of the big issues with Database Mirroring is that the failover is tied to one database, so if there is a database failure the mirrored server takes over for this one database, but all other databases remain functional on the primary server. http://www.sqlservercentral.com/redirect/articles/64106/2008/08/19http://www.sqlservercentral.com/redirect/articles/64106/This article describes the SQL Cluster Setup process and how to troubleshoot it if something goes wronghttp://www.sqlservercentral.com/redirect/articles/63907/2008/08/15http://www.sqlservercentral.com/redirect/articles/63907/This case study describes upgrading to SQL Server 2005 and Windows 2003 Active/Active cluster from and provides upgrade option pros and cons for SQL Server high availability.http://www.sqlservercentral.com/redirect/articles/63389/2008/06/18http://www.sqlservercentral.com/redirect/articles/63389/http://www.sqlservercentral.com/questions/Database+Mirroring/62951/2008/06/03http://www.sqlservercentral.com/questions/Database+Mirroring/62951/This article presents a way to implement a simple database synchronization solution similar to log shipping using Database Maintenance Plans and T-SQL.http://www.sqlservercentral.com/articles/Log+Shipping/62676/2008/05/01http://www.sqlservercentral.com/articles/Log+Shipping/62676/Along with some best practices, SQL Server MVP Hilary Cotter shares a log shipping setup process from start to finish. http://www.sqlservercentral.com/redirect/articles/62903/2008/04/28http://www.sqlservercentral.com/redirect/articles/62903/ Along with some best practices, SQL Server MVP Hilary Cotter shares a log shipping setup process from start to finish. http://www.sqlservercentral.com/redirect/articles/62840/2008/04/22http://www.sqlservercentral.com/redirect/articles/62840/One of the four high availability technologies in SQL Server is replication, though this can be very cumbersome to setup and get working. Longtime author Paul Ibison looks at how this has changed from SQL Server 2000 to 2005 and what you should consider before setting this up.http://www.sqlservercentral.com/articles/High+Availability/62507/2008/04/17http://www.sqlservercentral.com/articles/High+Availability/62507/This article is to discuss a number of important cluster Group and Resource properties that have significant impact on failover behaviors.http://www.sqlservercentral.com/articles/Clustering/62327/2008/03/25http://www.sqlservercentral.com/articles/Clustering/62327/Understanding different types of failovers/Role Switching and How do they internally work in database mirroring.http://www.sqlservercentral.com/redirect/articles/62316/2008/03/14http://www.sqlservercentral.com/redirect/articles/62316/If your database goes offline, you’re probably up a creek, right? If you’re using SQL Server 2005 with SP1, however, the database mirroring feature can prevent disaster.http://www.sqlservercentral.com/redirect/articles/62155/2008/02/19http://www.sqlservercentral.com/redirect/articles/62155/Log shipping has been a mechanism for maintaining a warm standby server for years. Though SQL Server supported log shipping with SQL Server 2000 as a part of DB Maintenance Plan, it has become a built-in feature of SQL Server 2005. This article gives brief introduction to SQL Server 2005 Log Shipping, configuration of it, monitoring of it and failing over at the disaster.http://www.sqlservercentral.com/redirect/articles/61643/2007/12/13http://www.sqlservercentral.com/redirect/articles/61643/http://www.sqlservercentral.com/questions/High+Availability/61289/2007/10/17http://www.sqlservercentral.com/questions/High+Availability/61289/Apress has been generous enough to provide us with a sample chapter from their book on SQL Server 2005 High Availability by Alan Hirt.http://www.sqlservercentral.com/articles/Book+Reviews/61231/2007/10/03http://www.sqlservercentral.com/articles/Book+Reviews/61231/