I've never tried this before but this is what I'm attempting to do :
- Backup all the databases
- Copy current
master.mdf
andmaster.ldf
to another location (for later purpose) - Uninstall SQL Server 2000 Personal Edition
- Install SQL Server 2000 Enterprise Edition (SP4)
- Stop the newly installed server, and replace the
master.mdf
andmaster.ldf
with those old two files above - Restart server
I've done this before, but only with Enterprise Edition, after reinstalling SQL Server I'll just have to replace the master file and everything is fine.
Will it work in this case ?