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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanks Geoff!

"Geoff N. Hiten" wrote:

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: Error -2147217900: failed to create SQL database
    ... Senior Database Administrator ... Microsoft SQL Server MVP ... "Geoff N. Hiten" wrote: ...
    (microsoft.public.sqlserver.clustering)
  • 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: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • Re: Add new cluster and use existing LUNs?
    ... Meta-volumes are dedicated to a single host, single activity (OS, swap file, ... varied activity (DBMSes, Messaging Server, File Server, Web Servers, ... Some of the physical spindle limitations can be addressed through the SAN ... >> test would be to run a simulated SQL I/O load on the newly created LUNs ...
    (microsoft.public.sqlserver.clustering)