Setup SQL2000 failover with NAS

First of all I want to confirm that it is possible to setup an active/passive failover with sql2000 using a NAS to store the data and log files. I have already setup 1 SQL server that is using data stored on a NAS box, now I need to setup a second machine to take over if the active machine fails.

Since it is not possible to attach 2 sql servers to the same data at the same time, how will I go about ensuring the data stored on the NAS will be associated with both servers? Is it neccessary to setup WIndows clustering to get this to work? We are using hardware load balancing so I was hoping to avoid using Windows clustering.

Can anyone point me in the right direction? Any pointers to online docs would be greatly appreciated.

Thanks in advance.
LVL 1
rot299Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
arbertConnect With a Mentor Commented:
Yes, if you want one machine to take over when the other one fails and use the same set of data--you need to setup clustering (whether it's Windows clustering, or a third party solution).

There isn't a supported method of making two non-clustered sql servers use the same database.

http://www.microsoft.com/windowsserver2003/technologies/clustering/default.mspx


Also, make sure your NAS hardware is on the hardware compatability list or you will be running a non-supported solution.

Brett
0
All Courses

From novice to tech pro — start learning today.