Move sql database to diverend harddisk with same drive letter

I have a small d: drive and like to change this with a bigger one, how can i
move the database from old drive to new drive and use te same drive letter
after the database move? i installed the new harddrive with letter e: Can i
stop the sql server and copy the whole drive d: to drive e: and than change
driveletter to d:?
ThanksYou can move the data file. you would need to deatach the database, move the
file phisicaly to another drive (mdf or ndf and ldf) then atach the database
and it will ask you for a location of the new data files (both mdf/ndf and
ldf). point to the newly created drive and new location of your files and
that is it.
Do me a favor, it has been 2 years since I did it; google it "move data
files to another drive" and you will get tons of hits. This is non system DB
?
This is one of your own databases?
"Luq" wrote:

> I have a small d: drive and like to change this with a bigger one, how can
i
> move the database from old drive to new drive and use te same drive letter
> after the database move? i installed the new harddrive with letter e: Can
i
> stop the sql server and copy the whole drive d: to drive e: and than chang
e
> driveletter to d:?
> Thanks|||Her you go Luq
http://support.microsoft.com/kb/224071
"Luq" wrote:

> I have a small d: drive and like to change this with a bigger one, how can
i
> move the database from old drive to new drive and use te same drive letter
> after the database move? i installed the new harddrive with letter e: Can
i
> stop the sql server and copy the whole drive d: to drive e: and than chang
e
> driveletter to d:?
> Thanks