O'Reilly logo

Professional Microsoft® SQL Server® 2008 Administration by Steven Wort, Ross LoForte, Wayne Snyder, Ketan Patel, Brian Knight

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

20.6. Clustering SQL Server 2008

Believe it or not, the procedure to install a SQL Server 2008 instance onto a cluster is one of the easiest parts of getting your SQL Server 2008 cluster up and running. The SQL Server 2008 setup program is used for the install, and it does the heavy lifting for you. All you have to do is make a few (but critically important) decisions, and then sit back and watch the installation take place. In fact, the setup program even goes to the trouble to verify that your nodes are all properly configured; and if not, it will suggest how to fix any problems before the installation begins.

When the installation process does begin, the setup program recognizes all the nodes, and once you give it the go-ahead to install on each one, it does so, all automatically. SQL Server 2008 binaries are installed on the local drive of each node, and the system databases are stored on the shared array you designate.

The next section shows the step-by-step instructions for installing a SQL Server 2008 instance in a cluster. The assumption for this example is that you will be installing this instance in a two-node active/passive cluster. Even if you will be installing in a two-node active/active or a multinode cluster, the steps in this section are applicable. The only real difference is that you have to run SQL Server 2008 setup for every instance you want to install on the cluster, and you have to specify a different logical drive on the shared array.

20.6.1. Clustering ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required