<div>
<div class="content wysiwyg-content">
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. <br />
<br />
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.<br />
<br />
Can anyone point me in the right direction? Any pointers to online docs would be greatly appreciated.<br />
<br />
Thanks in advance.
</div>
</div>


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.

Setup SQL2000 failover with NAS

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.