Moving SQL 2000 to different Drive

Hello All,
Please help. I have installed my SQL on an old powervault and needed to move
it to a new CX300. The mdf files are installed on F:\Microsoft SQL
Server\MSSQL\Data and the ldf files on G:\Microsoft SQL Server\MSSQL\Data
drive. I stopped all SQL services and copied data to new H and I drives, the
n
shutdown F and G drives. I renamed H and I to F and G and reboot. My problem
is that after the sever rebooted the SQL services won't start. I got an
error: the system cannot find the path specified. Any idea?
Thanks.Put everything back to where you had it. Then read about sp_detach/
sp_attach in BOL.
"David" <David@.discussions.microsoft.com> wrote in message
news:015636D7-EAB9-40D4-8F4F-BC8F3C7668D8@.microsoft.com...
> Hello All,
> Please help. I have installed my SQL on an old powervault and needed to
move
> it to a new CX300. The mdf files are installed on F:\Microsoft SQL
> Server\MSSQL\Data and the ldf files on G:\Microsoft SQL Server\MSSQL\Data
> drive. I stopped all SQL services and copied data to new H and I drives,
then
> shutdown F and G drives. I renamed H and I to F and G and reboot. My
problem
> is that after the sever rebooted the SQL services won't start. I got an
> error: the system cannot find the path specified. Any idea?
> Thanks.|||Hi David,
(1) Use sp_detach_db
(2) Copy .mdf and .ldf files to the new drive
(3) Use sp_attach_db by specifying the new location
Thanks
GYK|||Thanks for Reply,
Do I have to deal with any SQL installation files on the old F and G drives?
For example the bin folder also installed on F drive.
Thanks.
"ChrisR" wrote:

> Put everything back to where you had it. Then read about sp_detach/
> sp_attach in BOL.
>
> "David" <David@.discussions.microsoft.com> wrote in message
> news:015636D7-EAB9-40D4-8F4F-BC8F3C7668D8@.microsoft.com...
> move
> then
> problem
>
>|||Chris,
Where did you install SQL Server? If on the old drives, you'll need to
reinstall it on the new drives.
Ron
--
Ron Talmage
SQL Server MVP
"David" <David@.discussions.microsoft.com> wrote in message
news:B89C0CF2-C9DA-4EEB-9D68-DBCBDA49A6FD@.microsoft.com...
> Thanks for Reply,
> Do I have to deal with any SQL installation files on the old F and G
drives?[vbcol=seagreen]
> For example the bin folder also installed on F drive.
> Thanks.
> "ChrisR" wrote:
>
to[vbcol=seagreen]
Server\MSSQL\Data[vbcol=seagreen]
drives,[vbcol=seagreen]
an[vbcol=seagreen]