Re: Move SQL 2000 data to new SAN, same drive letter

I have done this before except it was remapping the drive letters to new
LUNS on the same SAN. It works just fine. The OS and MSCS know it is a
different resource, but SQL only looks at drive letters and paths when
locating data files. The key is to make sure SQL is shut down cleanly and
stans down during the entire process. Also, make sure the paths are exactly
the same after copying.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP




"Tom D" <Tom D@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3C170086-CD78-45F6-A1E0-8DDB6F17A017@xxxxxxxxxxxxxxxx
Hi

Are you sure it will be that easy? Won't the clustering services look at
the
new san volumes as new drives because the ID's will be different?

I'm always confused on this point

Thanks

Tom D

"Ken" wrote:

Great. Thanks for the reply.

Linchi Shea wrote:
If you do the drive letter swap while the SQL instance is offline, you
should
be able to bring up the SQL instance without it noticing a thing.

Linchi

"Ken" wrote:

We need to move our existing SQL 2000 data to a new SAN.

If I move/copy the database files to the new SAN but remap to the
same
drive letter, do I need to perform a detach/attach of the databases?

Assume the databases will be offline. The cluster node running SQL
will
remain untouched apart from mapping the new SAN volume.

thanks,
Ken






.

Relevant Pages

  • Re: Multi-Channel Raid VS SAN Storage
    ... The idea of keeping the database in memory is appealing, ... Our report SPs are vry tempDB and memory intensive. ... Probably because our SQL server only has 3 GB of RAM. ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • Re: SAN drive config for SQL Cluster
    ... thanks for your responses which helped me to setup/running SQL ... cluster in SAN. ... We plan to have 2-instance Cluster running on SAN. ... you must plan drive letters on a cluster-wide basis. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Move SQL 2000 data to new SAN, same drive letter
    ... "Geoff N. Hiten" wrote: ... LUNS on the same SAN. ... The key is to make sure SQL is shut down cleanly and ... Senior Database Administrator ...
    (microsoft.public.sqlserver.clustering)
  • Re: Active/Active Clustering - Help!
    ... You install a complete second instance of SQL ... Senior Database Administrator ... > can see the actual SAN resources at anyone time. ... > The scenario I have is I currently have a Windows 2003 Active/Passive ...
    (microsoft.public.sqlserver.clustering)
  • Re: Moving a SQL 2005 2-node, single-instance cluster to new SAN hardware
    ... Russ looks like he has the right steps. ... SQL only cares about drive letters when resolving file paths. ... existing SAN to a new SAN. ...
    (microsoft.public.sqlserver.clustering)