|
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
(comments are locked)
|
|
(comments are locked)
|
|
You could also get yourself a good reference book:
(comments are locked)
|
|
On top of the good suggestions provided there are some simple things that you should know first:
(comments are locked)
|
|
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!
(comments are locked)
|
|
If there is no shared SAN can we purchase a third party tool to store the data and replicate to the other servernode?
(comments are locked)
|
1 2 next page »

