Move SQL 2000 data to new SAN, same drive letter

Tech-Archive recommends: Fix windows errors by optimizing your registry

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: Move SQL 2000 data to new SAN, same drive letter
    ... 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 ...
    (microsoft.public.sqlserver.clustering)
  • Re: Moving the databases to a new SQL server
    ... In the SQL 2000 Admin tool, you have to detach the databases. ... You also have to specify to SQL Server the location for the new databases. ... Is it possible to move all the databases from the SQL server on a SAN making sure that the portal and the SQL server point to the new location? ...
    (microsoft.public.sharepoint.portalserver)
  • 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: BizTalk eating up SQL Server (Virii Behaviour)
    ... Yes, one gig is the least to run sql & bts in the same box, ... uninstall procedure, i manually deleted all databases, and run the ... and it was leaving like 20 mbs free memory, ... BizTalk Solution Developer ...
    (microsoft.public.biztalk.general)
  • Re: Dont understand what version of SQL to install
    ... I'm talking about developing and testing databases for my client and ... To my XP, I can add SQL Developer 2008 to develop (I guess I should say, ... So I can use SQL Developer 2008 to create a database in standard 2005, ... installed on Client OSs such as Windows Vista. ...
    (microsoft.public.sqlserver.setup)