Hi all, in our current environment we have 1 server running sql. After
making a review of our disaster recovery strategy and readiness we have
decided to bring in a 2nd server to function as a standby failover. Due to
the price limitations with SQL2KEE we have decided to stick with Standard
Edition. Here is how we intend to set it up and wanted to see whether this
was feasible and were there any downsides to this architecture.

1. 2 Servers running Windows Server 2003 Standard in a NLB Cluster.
2. Both Servers will have SQL2K Standard Installed
3. Database files (mdf & ldf) will reside on a Dell PowerVault NAS Server
4. Databases on each server configured to point to same file on NAS Server.

Assuming this is possible, if 1 server were to go down, the 2nd would
pickup. Now we would be in a ditch if the NAS Server were to go down.

Any suggestions/recommendations are greatly appreciated.

thanks a bunch!

For "emergency standby SQL Server" options, you way want to look at data
replicaiton tools like Double-Take:
http://www.nsisoftware.com/pro/doubletake/

It will replicate your database to another standby SQL Server. No need to
build a cluster, or try and share the same NAS between 2 SQL Servers.

Chris Skorlinski
Microsoft SQL Server Support
Please reply directly to the thread with any updates.

This posting is provided "as is" with no warranties and confers no rights.