Just moved MSDE 2000 to a new server with MSDE 2005. Well worth the update as MSDE 2005 is a free download as well and is way better than the admin consol. Other than not having a backup agent MSDE 2005 looks and feels very much like good old SQL 2005.
Here is the link to get to MSDE 2005 express: https://www.microsoft.com/express/2005/sql/default.aspx
Here's an article to set up a backup routine for MSDE:
http://www.sqldbatips.com/showarticle.asp?ID=27
Process I did to move to a new server:
- Make backup of DYNAMICS and company databases
- Run capture login scripts found at: https://mbs.microsoft.com/fileexchange/?fileID=879594a6-60ee-421f-b6ab-4d77da3aba22
- Install MSDE on new server (Mixed mode)
- Install GP on new server
- Copy output from #2 and run on new server (will automatically run against master database)
- Restore DYNAMICS database and company database to new server (All tasks>>restore>>type in database name exactly as it was on previous server)
- Change ODBC connections on workstations to point to new server
- Update Dynamics.set file on all workstations to point to new shared directory with new reports.dic file location
Process could also be used for regular SQL installs.
