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

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 change
> 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 change
> driveletter to d:?
> Thanks

Move database to new drive w/ same drive letter

Hi all,
I want to move several database files from a small drive to a new one and replace the existing (small) drive with the bigger one.
The drive letter would not change.
Can I just go ahead and boot the server w/o the SQL service running, copy the folders to the new drive, pull out the old drive and replace it with the new one or do I have to go through the whole attach/detach schema as described in http://support.microso
ft.com/default.aspx?scid=KB;EN-US;q224071&ID=KB;EN-US;q224071 ?
Thanks!
Andreas
You don't have to detach/attach... As long as the drive letter and path is
the same, there shouldn't be any problems as long as SQL is shutdown
cleanly.
"Andi" <anonymous@.discussions.microsoft.com> wrote in message
news:A3410D22-0CFC-469E-8BC0-515D3B1A83AF@.microsoft.com...
> Hi all,
> I want to move several database files from a small drive to a new one and
replace the existing (small) drive with the bigger one.
> The drive letter would not change.
> Can I just go ahead and boot the server w/o the SQL service running, copy
the folders to the new drive, pull out the old drive and replace it with the
new one or do I have to go through the whole attach/detach schema as
described in
http://support.microsoft.com/default...;EN-US;q224071 ?
> Thanks!
> Andreas

Move database to new drive w/ same drive letter

Hi all,
I want to move several database files from a small drive to a new one and re
place the existing (small) drive with the bigger one.
The drive letter would not change.
Can I just go ahead and boot the server w/o the SQL service running, copy the folders t
o the new drive, pull out the old drive and replace it with the new one or do I have to
go through the whole attach/detach schema as described in [url]http://support.microso[
/url]
ft.com/default.aspx?scid=KB;EN-US;q224071&ID=KB;EN-US;q224071 ?
Thanks!
AndreasYou don't have to detach/attach... As long as the drive letter and path is
the same, there shouldn't be any problems as long as SQL is shutdown
cleanly.
"Andi" <anonymous@.discussions.microsoft.com> wrote in message
news:A3410D22-0CFC-469E-8BC0-515D3B1A83AF@.microsoft.com...
> Hi all,
> I want to move several database files from a small drive to a new one and
replace the existing (small) drive with the bigger one.
> The drive letter would not change.
> Can I just go ahead and boot the server w/o the SQL service running, copy
the folders to the new drive, pull out the old drive and replace it with the
new one or do I have to go through the whole attach/detach schema as
described in
http://support.microsoft.com/defaul...B;EN-US;q224071 ?seagreen">
> Thanks!
> Andreas

Move database to new drive w/ same drive letter

Hi all
I want to move several database files from a small drive to a new one and replace the existing (small) drive with the bigger one
The drive letter would not change
Can I just go ahead and boot the server w/o the SQL service running, copy the folders to the new drive, pull out the old drive and replace it with the new one or do I have to go through the whole attach/detach schema as described in http://support.microsoft.com/default.aspx?scid=KB;EN-US;q224071&ID=KB;EN-US;q224071
Thanks
AndreasYou don't have to detach/attach... As long as the drive letter and path is
the same, there shouldn't be any problems as long as SQL is shutdown
cleanly.
"Andi" <anonymous@.discussions.microsoft.com> wrote in message
news:A3410D22-0CFC-469E-8BC0-515D3B1A83AF@.microsoft.com...
> Hi all,
> I want to move several database files from a small drive to a new one and
replace the existing (small) drive with the bigger one.
> The drive letter would not change.
> Can I just go ahead and boot the server w/o the SQL service running, copy
the folders to the new drive, pull out the old drive and replace it with the
new one or do I have to go through the whole attach/detach schema as
described in
http://support.microsoft.com/default.aspx?scid=KB;EN-US;q224071&ID=KB;EN-US;q224071 ?
> Thanks!
> Andreas