Solved

How do I upgrade from MSDE 1.0 to either MSDE 2000 or SQL Server 2005 Express Edition?

Posted on 2006-10-23
3
320 Views
Last Modified: 2008-02-01
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
SQL\Data\backup\master.bak"
2> go
Msg 3168, Level 16, State 1, Server SERVER2, Line 1
The backup of the system database on device C:\Program Files\Microsoft SQL
Server\MSSQL\Data\backup\master.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.

TIA
0
Comment
Question by:abansal97
3 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
Comment Utility
you cannot restore the master database like this, as it is a system database.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_4g4w.asp

similary, the model & msdb database (msdb does not apply to msde installation though):
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_2w1f.asp
0
 
LVL 29

Assisted Solution

by:Nightman
Nightman earned 250 total points
Comment Utility
You can't restore the master database across versions - only user databases
0
 

Author Comment

by:abansal97
Comment Utility
OK, that gave me the clue to proceed. Since the timestamp is equal, I'll split the points.

I additionally had to do the following.

I looked for the user databases, by typing the following:
1> SELECT name FROM master.dbo.sysdatabases WHERE DBID > 4
2> GO

After finding the databases, I then backed them up in MSDE 1.0.

When restoring the databases, I had to do the following, since the destination files had a different path than the original:
1> RESTORE FILELISTONLY FROM DISK = path_to_backup_set
2> GO
then
1> RESTORE DATABASE database_name FROM DISK = path_to_backup_set WITH MOVE logfile TO path_to_new_logfile, MOVE datafile TO path_to_new_datafile
2> GO

HTH someone.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now