SQL 2000 De-Installation
Stop the server. The first step to de-installing SQL 2000 is to make sure the server is stopped.
Look at the bottom right of your server's screen and see if you have the SQL Server icon with the
green arrow.
If you do, stop your right click the icon and select 'MSSQL Server - Stop'.
Now click 'Yes' on the confirmation box.
After your server is stopped, the SQL icon will be replaced with one showing a red 'X'.
Back up your database files! - If you care about your data, you should back up your database files now
since they will be deleted during your de-install process.
These files are located in the:
C:\Program Files\Microsoft SQL Server\MSSQL\Data\ folder. - If not sure which
ones to backup, get them all. - Just copy them to a new folder on the 'C:\' drive (i.e. 'C:\data_backup\'.
Now go to 'Control Panel' and click 'Add or Remove Programs'.
Look for 'Microsoft SQL Server 2000' and click on it. - Now click on 'Change/Remove'.
On the 'Confirm File Deletion' box, click 'Yes'.
The de-install process will start. - At some point, you may see a 'Remove Shared File?' box asking you if you
want to delete any shared files found. - At this point, click on 'No to All'. - The process will continue.
When the de-install finishes, you'll be informed of the fact. - You'll also be informed that it is recommended you
restart your server. - Click 'OK'.
Before leaving 'Control Panel->Add or Remove Programs', check to see if you have any other MS SQL programs installed. -
If you do, remove these as well. - You can always add them back later. - This will ensure you end up with a 'clean'
install later.
Now Re-Boot your server.
When your server comes back up, you'll now want to remove if the 'Microsoft SQL Server' folder on your C:\
drive.
With 'Windows Explorer', navigate to: 'C:\Windows\Program Files\Microsoft SQL Server\ and delete it by right
clicking on it and select 'Delete'.
On the 'Confirm Folder Delete' box, click 'Yes'. - This will remove your data and any shared files the de-install
found during the de-installation. - If everything goes okay, this folder will be removed.
You're now ready to install a new copy of SQL 2000 Server.
|