I would like to upgrade an older MSDE 1.0 installation on Windows 2000 Server to a MSDE 2000 installation on Windows 2003 Server. I am also willing to use SQL Server 2005 Express Edition if it's easier.
I looked at the following white paper: http://support.microsoft.com/?kbid=322620
, but am not sure if it applies to the the desktop versions.
I have tried doing a backup from MSDE 1.0 and restore to MSDE 2000, but got the following error during the restore:
C:\Program Files\Microsoft SQL Server\MSSQL>osql -E
1> RESTORE DATABASE master FROM DISK = "C:\Program Files\Microsoft SQL Server\MS
Msg 3168, Level 16, State 1, Server SERVER2, Line 1
The backup of the system database on device C:\Program Files\Microsoft SQL
aster.bak cannot be restored because it was created
by a different version of the server (117441135) than this server (134218488).
Msg 3013, Level 16, State 1, Server SERVER2, Line 1
RESTORE DATABASE is terminating abnormally.