Moving SQL Server to a new drive

[Todd Beauchemin]

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

[David Portas]

Todd 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/default...b;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
--

[John Bell]

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" <hi************@todds-world.net> wrote in message
news:zz*****************@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