Installation of SQL Server

I have SQL Server 7 installed onto a partition (not C on a Win NT4 Server.
I shortly intend upgrading the server to Windows 2000 (to join a new AD
domain). This process will format the C: drive before installing a new Win
2000 installation. I realise I have to back up and detach the databases
before doing this.
However, my question is, does anyone know whether Enterprise Manager will
still run correctly if C: drive is overwritten (even though it is installed
to E?
(I'm concerned about losing DLLs etc..)
A lot of information is stored in the registry, and that will be on the C:
drive. Among the information that is stored in the registry are the start up
parameters for SQL Server, and that includes the location of the master
database. In other words, if you format the C: drive and wipe the registry,
SQL Server won't start, never mind Enterprise Manager. If you are intend on
formatting the C: drive, I would uninstall SQL Server, and then reinstall it
after you have installed the new OS. That is the safest way to do it.
Jacco Schalkwijk
SQL Server MVP
"gmickelsen" <gmickelsen@.discussions.microsoft.com> wrote in message
news:5CBBFAC6-4D12-4A21-B70F-B794C54B4428@.microsoft.com...
>I have SQL Server 7 installed onto a partition (not C on a Win NT4
>Server.
> I shortly intend upgrading the server to Windows 2000 (to join a new AD
> domain). This process will format the C: drive before installing a new Win
> 2000 installation. I realise I have to back up and detach the databases
> before doing this.
> However, my question is, does anyone know whether Enterprise Manager will
> still run correctly if C: drive is overwritten (even though it is
> installed
> to E?
> (I'm concerned about losing DLLs etc..)
>