Moving a database

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 wend to accomplish it. =-)
Thanks,
DeanYou 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
"Dean" <Dean@.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 wend to accomplish it. =-)
> Thanks,
> Dean
>sql