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, 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.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...
> > 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.
>
>|||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?
> 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...
> > > 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.
> >
> >
> >