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



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: SQL 2000 on SAN
    ... If they won't guarantee disk layout, then have them put performance metric ... > We are in the process of moving our production SQL servers to a SAN. ... > regarding moving our databases onto a SAN? ...
    (microsoft.public.sqlserver.setup)
  • Re: Staging Area Design
    ... SAN is not a solution designed only for large databases, ... discussions on whether dedicated disk is better for database solutions. ... A data warehouse architect that is not sure that SAN are a good ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Moving Databases - Timeframes?
    ... >We will be moving our databases from a SAN back to our ... The server is currently connected to the SAN via 100MB/sec ... It's not an Exchange thing. ... files are just bog standard files that get moved. ...
    (microsoft.public.exchange.admin)
  • Re: ODBC connection problem
    ... installed new default SQL instance + Service Packs. ... > the SharePoint DBs that are keeping you from using them the way you wish. ... I'm not trying to connect to the share point databases, ... I just install a fresh SQL instance on the Server and use ...
    (microsoft.public.windows.server.sbs)
  • Re: Manual move of Exchange 2003 Databases?
    ... Exchange 2003 databases from the old SAN to the new SAN. ... our maintenance window, we wanted to restore the files to the new SAN ...
    (microsoft.public.exchange.admin)

Loading