Change Drive Letter

We have installed a SQL Server 2000 database on the J
drive. However, we would like to change the drive letter
to E.
We would like to know what steps we should do in order to
move the database from J to E drive ? Is it necessary for
us to detach and attach the database ? OR Just change the
file location of the database from J to E in EM?
Thanks
You would need to detatch the database, move the files and then re-attach
the files to bring the DB back online. When re-attaching the files however
you will be able to browse for the .MDF file. If there are any subsequent
files such as .NDF or .LDF you *may* need to search for them separatly.
When detatching a database if you have any full text searches enabled on the
DB, these will need to be re-established once the database is re-attached.
This can be done by right clicking on the table with the full text index and
then proceeding to 'edit' the index.
Hope this helps.
Anubis.
"Jason" <anonymous@.discussions.microsoft.com> wrote in message
news:018701c5707c$2f643880$a601280a@.phx.gbl...
> We have installed a SQL Server 2000 database on the J
> drive. However, we would like to change the drive letter
> to E.
> We would like to know what steps we should do in order to
> move the database from J to E drive ? Is it necessary for
> us to detach and attach the database ? OR Just change the
> file location of the database from J to E in EM?
> Thanks
|||If it's just a single DB you're talking about, detach/attach would be
the best way. I'd strongly advise *against* hacking the system tables
to change the driver letter in sysfiles.
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Jason wrote:

>We have installed a SQL Server 2000 database on the J
>drive. However, we would like to change the drive letter
>to E.
>We would like to know what steps we should do in order to
>move the database from J to E drive ? Is it necessary for
>us to detach and attach the database ? OR Just change the
>file location of the database from J to E in EM?
>Thanks
>
sql