Move SQL 2000 data to new SAN, same drive letter

Giganews Newsgroups
Subject: Move SQL 2000 data to new SAN, same drive letter
Posted by:  Ken (kenkw…@gmail.com)
Date: 22 Aug 2006

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

Replies