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
asked Feb 06, 2012 at 11:45 AM in Default
On top of the good suggestions provided there are some simple things that you should know first:
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:
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!
answered Feb 06, 2012 at 09:45 PM