x

SQL Server Failover Clustering

I am a junior DBA. A client has decided to have their SQL environment clustered. I'm new to this and need insight as to what is required of me as the DBA. I know that i would need Licencing for the software,another server configured exactly identical to the current live server. a lot of testing. Is there a step by step guide of what i would need to do to make this a success first time? Thanks
more ▼

asked Feb 06, 2012 at 11:45 AM in Default

Pinkett gravatar image

Pinkett
30 11 13 15

(comments are locked)
10|1200 characters needed characters left

7 answers: sort voted first

I guess no better and more authentic resource than BOL and Microsoft [technet][2].

[2]: http://technet.microsoft.com/en-us/library/cc732488%28WS.10%29.aspx
more ▼

answered Feb 06, 2012 at 12:29 PM

Usman Butt gravatar image

Usman Butt
13.9k 6 8 14

(comments are locked)
10|1200 characters needed characters left

You could also get yourself a good reference book:

  • Pro SQL Server 2008 Failover Clustering Amazon US | [Amazon UK][2]
[2]: http://www.amazon.co.uk/Server-Failover-Clustering-Experts-Voice/dp/1430219661
more ▼

answered Feb 06, 2012 at 01:06 PM

Kev Riley gravatar image

Kev Riley ♦♦
52.8k 47 49 76

(comments are locked)
10|1200 characters needed characters left

On top of the good suggestions provided there are some simple things that you should know first:

  • The servers require a shared SAN for the storage
  • A domain account is the best for the service account
  • You may need to work with a Windows SA to set up Windows Clustering depending on your company's policies
more ▼

answered Feb 06, 2012 at 02:19 PM

Blackhawk-17 gravatar image

Blackhawk-17
11.9k 28 31 36

(comments are locked)
10|1200 characters needed characters left

Not that I'm aware of, although some a clustering expert might know of something. Clustering requires shared storage, so if your client truly wants a "cluster", they will have to put in some form of shared storage.

Now, there are other options available to provide various levels of protection, depending on what the requirements are, such as sql replication, database mirroring, and/or log shipping. Those don't require shared storage however they do require another sql instance and you have to do some planning.

Here is some information to get you started down that path if interested:

Replication: http://msdn.microsoft.com/en-us/library/ms151198.aspx

Mirroring: http://technet.microsoft.com/en-us/library/dd207314.aspx

Log Shipping: http://msdn.microsoft.com/en-us/library/ms190640.aspx

High Availability Solutions Overview: http://msdn.microsoft.com/en-us/library/ms190202.aspx

There is a ton of information out on the internet about each of these topics.

Hope this helps!
more ▼

answered Feb 06, 2012 at 09:45 PM

JohnM gravatar image

JohnM
6.6k 1 3 7

(comments are locked)
10|1200 characters needed characters left
If there is no shared SAN can we purchase a third party tool to store the data and replicate to the other server\node?
more ▼

answered Feb 06, 2012 at 02:28 PM

Pinkett gravatar image

Pinkett
30 11 13 15

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x17

asked: Feb 06, 2012 at 11:45 AM

Seen: 1223 times

Last Updated: Feb 07, 2012 at 11:58 AM