|
Yes, I would suggest a SAN which gives you external storage that can be shared between servers which in turn allows you to add storage resources non-disruptively. External SAN storage will also enable you to use a clustering solution such as MSCS which will make your SQL server resource more highly available and allow you to perform normal server maintenance on your cluster nodes by moving the application between the nodes in the cluster.
I do not normally do product recommendations since my answers need to be vendor neutral. That being said, there are a number of storage vendors out there that can offer you very inexpensive SAN storage solutions.
Since you only have a couple of servers to connect, you can bypass SAN switch hardware for the time being by direct connecting the servers to the shared storage array using FC-AL( Fibre Channel Arbitrated Loop) hardware. As your server farm and storage needs grow, just add switches and storage.
I would first check with your server vendor for cheap SAN products. Dell, Gateway, HP, IBM, Sun, etc. all have low cost SAN products that you should be able to use.
Chris
Editor's note: Do you agree with this expert's response? If you have more to share, post it in one of our discussion forums.
|
