We've all data and log files located in SAN mount point. In case of
primary server crash, is it possible to unmount the volumes and
remount at secondary server? Do we have any problems with master DB
moving this way. Detach,attach or backup/restore are not our options.

Thanks

"barbara" <barbara_2003@hotmail.com> wrote in message
news:5cd01256.0409020302.4fbab4e0@posting.google.c om...
> We've all data and log files located in SAN mount point. In case of
> primary server crash, is it possible to unmount the volumes and
> remount at secondary server? Do we have any problems with master DB
> moving this way. Detach,attach or backup/restore are not our options.
>
> Thanks

If you want to fall over to another server without using any of the
mechanisms you mention, and with minimal downtime, then clustering is the
usual approach. Even if you have all the database files intact, you would
have to attach them to another installation of MSSQL somehow, and that
requires a supported mechanism such as detach/attach.

You might find the information here useful:

http://support.microsoft.com/default...&Product=sql2k
http://www.microsoft.com/sql/techinf...ailability.asp
http://www.microsoft.com/technet/pro.../spltmirr.mspx

This page has several links on using MSSQL in a SAN environment:

http://www.microsoft.com/sql/techinf...calability.asp

Simon