Hi All,

I would like to reinstall SQL Server 2000 on the SQL server. I have the
following steps to do it. Can any one tell me if there are anything I have
skipped?

Reinstalling SQL2000.

Preparation
1. Script all user database with logins.
2. Backup all databases

Install SQL2000
1. Run Query Analyser by connecting as 'sa'
2. Run the scripts to generate user databases
3. Restore databases.
4. Apply the latest Service Pack 2.
5. Apply the latest patch.

Install verification
1. Check registry and path environment variables.
2. Check user access to each user database.
3. Verify @@version

Thank you.

Sang Nahm
MS Sql Server LazyDBA home page