Saturday, February 25, 2012

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

No comments:

Post a Comment