I have a F drive which located at a SCSI Disk Array, it's the default
instance SQL's data drive, now I just switch the cluster from the SCSI array
to SAN.
Now, I want to switch the SQL data drive to a SAN drive.
Question is that it's just simple to cut off the database, and detach all DB
and copy to the new SAN shared drive, and then attach it.

IS that correct? Do I need care about the relaionship of the new SAN drive?

Thanks a lot!

Peter

Hi

The cluster needs to know about it's resources (in this case a volume) and
virtual servers have dependencies on the disk groups.

You have to create new drive letters against the SAN, make SQL Server
dependent on those new letters. Detach the DB's, copy them over and then
Re-Attach the DB's.

That should work quite well.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike (AT) epprecht (DOT) net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Peter Sun" <koarla (AT) hotmail (DOT) com> wrote

You may find this article helpful:
INF: Creating Databases or Changing Disk File Locations on a Shared Cluster
Drive on Which SQL Server 2000 was not Originally Installed
http://support.microsoft.com/default...b;en-us;295732

Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Adminstrator

"Peter Sun" <koarla (AT) hotmail (DOT) com> wrote

Hi, Mike,

Thank you so much.
Actually I already created the new drive letter against the SAN.
So, Can I just change the properties of the drive to build the relationship
with the virtual SQL server ( include dependence) at the cluster admin
console?

Is that works?

Thank you.

Peter
"Mike Epprecht (SQL MVP)" <mike (AT) epprecht (DOT) net> wrote