I currently have a Windows 2003 server installed with SQL Server 2000 and 2005 on it.
We have the disk partitioned in two:
C:contains the operating system and applications
E:contains the DB files
I need to reinstall the server due to license changes, and reinstall the databases as well. Is it possible to do this:
- Reinstall Windows on
- Reinstall SQL Server 2000 and 2005 (ok, maybe only 2005)
- Reattach all the DBs and have the server work as if nothing had happened to it.