Achieve High-Availability with SQL Server 2008

Tuesday Jan 26th 2010 by DatabaseJournal.com Staff

Keeping your database up and running is the lifeblood of every organization. Find out which features in SQL Server 2008 can be used to meet your high-availability requirements.

At the heart of every organization is a database.  The database is the lifeblood of each company, and when it is down revenue dollars are lost, as well as customers.  Keeping your database up 24x7 is critical to the success of your business.  With SQL Server 2008, Microsoft has enhanced its high availability and scalability features to meet the demands of today’s organizations.

In this white paper, you will find out how SQL Server 2008 can help your organization achieve the database stability needed to support your day-to-day and long-range database needs.   The following high-availability topics will be discussed in this paper:

• Database Mirroring

• Log Shipping

• Failover Clustering

• Peer to Peer Replication

• Database Snapshots

• Dynamic Configuration

SQL Server 2008 provides a number of different features you can use to improve the uptime of the critical databases that support your organization.  Picking the features that you need can sometimes be a difficult task. This paper will help explain the different features and how they work together to make sure you select the features needed to meet your high-availability requirements.

Mobile Site | Full Site