Moving SQL Server to a new drive

We installed MS SQL Server to our drive D drive E was the CDROM Drive.
We wanted to move the CDROM drive to drive D and the hard drive to drive
E. We change that around and corrected the registry entries -
repointing everything to drive E instead of D. SQL Server however will
not start it says it cannot find the databases. Where is this
information stored. How can I go about changing it?

~ToddTodd Beauchemin wrote:

> We installed MS SQL Server to our drive D drive E was the CDROM Drive.
> We wanted to move the CDROM drive to drive D and the hard drive to drive
> E. We change that around and corrected the registry entries -
> repointing everything to drive E instead of D. SQL Server however will
> not start it says it cannot find the databases. Where is this
> information stored. How can I go about changing it?
> ~Todd

Refer to:
http://support.microsoft.com/defaul...kb;en-us;224071

To do this safely you may have to change the E/D drives back to what
they were, then swap them again as you go through the proper sequence
of attaching and detaching.

--
David Portas
SQL Server MVP
--|||Hi

The registry rebuild option from the setup application may be able to do
this, but I can't remember if I have tried it!

John

"Todd Beauchemin" <high-commander@.todds-world.net> wrote in message
news:zznsf.10255$3Z.3395@.newsread1.news.atl.earthl ink.net...
> We installed MS SQL Server to our drive D drive E was the CDROM Drive.
> We wanted to move the CDROM drive to drive D and the hard drive to drive
> E. We change that around and corrected the registry entries -
> repointing everything to drive E instead of D. SQL Server however will
> not start it says it cannot find the databases. Where is this
> information stored. How can I go about changing it?
> ~Todd