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 '12 at 11:45 AM in Default

Pinkett gravatar image

Pinkett
30 9 13 15

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

7 answers: sort newest
Are there any T-SQL scripts online that i can use to print out backup database statements for all my databases? I think they call it auto generating SQL server backup database script: obviously one for each database: the return results are something like: Backup database 'db_name' to disk = '' for each database.
more ▼

answered Feb 07 '12 at 11:39 AM

Pinkett gravatar image

Pinkett
30 9 13 15

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

Thank you so much for all your answers. I am new to this but am feeling inspired by all you Professionals. I am not very good when coming to T-SQL so i could use all the help i could get.

Regards, Pinkett.
more ▼

answered Feb 07 '12 at 08:31 AM

Pinkett gravatar image

Pinkett
30 9 13 15

(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 '12 at 09:45 PM

JohnM gravatar image

JohnM
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 '12 at 02:28 PM

Pinkett gravatar image

Pinkett
30 9 13 15

(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 '12 at 02:19 PM

Blackhawk-17 gravatar image

Blackhawk-17
11.8k 28 30 35

(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:

x16

asked: Feb 06 '12 at 11:45 AM

Seen: 1143 times

Last Updated: Feb 07 '12 at 11:58 AM