I am running SQL Server 7.0 on a XP box. The computer name on the XP box was
inadvertently changed. Once the computer name was return to the orginal value
the SQL Server 7.0 installation was corrupted. I am unable to restart the SQL
Server. The error message indicates to rerun the setup. I do not have a good
backup but I have the .mdf and .ldf. My concern is if I reinstall the
software will my database left intact? Do I have to reinstall the software or
is there a workaround? I can open Enterprise Manager. Any help would be
appreciated

See the following:
http://www.karaszi.com/SQLServer/inf...erver_name.asp



"Sherry" <Sherry (AT) discussions (DOT) microsoft.com> wrote

=?Utf-8?B?U2hlcnJ5?= (Sherry (AT) discussions (DOT) microsoft.com) writes:
The database should survive a reinstalltion, but it is of course a good
idea to copy the files elsewhere as a safeguard.

I would also recommend that you copy the files for the master database
elsewhere. This database will be overwritten by the reinstallation, so
you would need to reattach databases. But it may work with copying back
the old master database.

Don't forget to reapply the service packs!


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx