Win2k server partition needs to rebuilt/this is a SQL 7.0 Question.

[NicBurns]

I have to rebuild my OS which is installed on my C:drive, My SQL server 7.0 is installed on my E:drive. Are there any DLL's or system files that may be removed while doing this and possibly rendering my SQL server unusable? And if so what steps should I take after the rebuild, I don’t see any SQL folders on the C:drive and by no means am I a SQL genius. Any help is appreciated.

 

[mrdenny]

There will be some common files that will be installed, and some ODBC stuff. You can try to start the SQL Server (which probably isn't registered). It's a fairly easy fix from the SQL Side.

Move your database files to a new folder on the E drive (E:\SQLHolding will be fine). Install SQL Server, patch to the level that you were patched at before you burned and rebuilt the C drive.

Stop the SQL Service. Copy the database files back (overwritting the master, model, and msdb database files that are already there). Start the SQL Server back up. (make sure that the files are in the same folder that they were in before). All should be working ok now.

Denny

--Anything is possible. All it takes is a little research. (Me)