SQL Server High Availability, Scalability and Reliability

Email Alerts

Register now to receive SearchSQLServer.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • database mirroring

    Database mirroring is the maintenance of redundant copies of a database to ensure continuous data availability and minimize or avoid downtime that might otherwise result from data corruption or loss, or when the operation of a network is partially c... 

  • Ensuring high availability of SSAS databases

    In part three of this series, Baya Dewald hones in on the administrative side of SQL Server Analysis Services, with details on the various methods on high availability for SSAS. 

  • FAQ: How to offer high-availability solutions with SQL Server 2008

    Expert Ross Mistry discusses the different ways that SQL Server 2008 can provide high-availability solutions in this FAQ podcast. 

  • Podcast: Log shipping in SQL Server: Basics to best practices

    SQL Server database administrator Eric Johnson explains how to back up your primary database and restore it to a secondary server through log shipping. He'll explain log shipping setup via SQL Server Management Studio. Get the details on how to set u... 

  • Database mirroring in SQL Server 2005 2

    What is database mirroring in SQL Server and how can it benefit your environment? SQL Server database administrator Eric Johnson starts by outlining the three roles involved in database mirroring: principle, mirror and witness. He goes on to share th... 

About SQL Server High Availability, Scalability and Reliability

High availability and reliability is a must for most large enterprises, and that doesn't exclude the database. There are several different high availability database solutions for Microsoft SQL Server, such as failover clustering, replication, and database mirroring. This topic page provides resources on a wide variety of high availability techniques for SQL Server 2005 and 2008. Here you'll find tips on high availability methods like log shipping and managing scalable shared databases, along with other tips covering overall best practices for high availability with Microsoft SQL Server. This page also includes details on SQL Server scalabilty strategies, with advice on scalability for all Microsoft SQL Server releases.