469,630 Members | 1,230 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,630 developers. It's quick & easy.

Disaster - moving databases

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
Jul 20 '05 #1
1 1598

"barbara" <ba**********@hotmail.com> wrote in message
news:5c**************************@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
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

19 posts views Thread by MasonC | last post: by
4 posts views Thread by LaSalamandra | last post: by
9 posts views Thread by Daven Thrice | last post: by
6 posts views Thread by Woody Splawn | last post: by
2 posts views Thread by DataPro | last post: by
3 posts views Thread by scoots987 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.