Moving a database

13 Jan 2006 11:26 PM

Dean

I have a small customer with a 2GB database. They recently added a RAID 5
array and RAID10 array to their server. I want to move the data files to the
RAID 5 and the log files to the RAID 10. Is there a script/command I can use
to move it or is it easier to just backup the database and then use RESTORE
WITH MOVE?

Note that I have an entire weekend to accomplish it. =-)

Thanks,
Dean

14 Jan 2006 12:33 AM

Andrew J. Kelly

You can either use Restore WITH MOVE or attach it. It's almost 6 or one and
a half dozen of the other either way.

--
Andrew J. Kelly SQL MVP

Show quote

"Dean" <D***@discussions.microsoft.com> wrote in message
news:F441AF9C-BBFE-487F-B23F-0226F326C0CA@microsoft.com...
>I have a small customer with a 2GB database. They recently added a RAID 5
> array and RAID10 array to their server. I want to move the data files to
> the
> RAID 5 and the log files to the RAID 10. Is there a script/command I can
> use
> to move it or is it easier to just backup the database and then use
> RESTORE
> WITH MOVE?
>
> Note that I have an entire weekend to accomplish it. =-)
>
> Thanks,
> Dean
>