We have a number of databases in our company and we recently had to buy a second SQL server.What I would like to do is have both SQL Servers act as failovers for each other.They both are the exact same hardware configuration (dell blades poweredge 1855) and we have a RAID array with Melio clustered file system for our web servers.I haven’t found any documentation on if this is even possible.Am I completely wrong in thinking this can be done or is there a better solution to spread the load but provide failover support with out buying 2 new machines?
Basic cluster 'failover' schemes require 'shared storage', such as SAN or NAS. If the disk array is dedicated to only one machine, it is not shared storage.
You might be better off examining Server Mirroring (if you are using SQL 2005).
No comments:
Post a Comment