Re: Moving SQL 2000 to different Drive

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Ron Talmage (rtalmage_at_prospice.com)
Date: 12/29/04 

Date: Tue, 28 Dec 2004 22:03:24 -0800

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.
> >
> >
> >
Quantcast