| Author |
Topic |
|
aliyesami
Starting Member
30 Posts |
 Posted - 2008-08-22 : 16:30:10
|
| hi !I am trying to restore the master database from enterprise edition to standard edition, I am getting this error below : "The backup of the system database on device c:\.... cannot be restored because it was created by a different version of the server (134219778) than this server (134219767) "The source database version is "Microsoft SQL Server 2000 - 8.00.2050 (Intel X86) Mar 7 2008 21:29:56 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4) "The target database version is "Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2) "NOTE: The target database is showing SP2 with 'select @@version' command, where as I have applied sp4 to this database and the commands below show that . so I guess this is some kind of bug in sqlserver 2000.The version and levels from the source and target databases using 'serverproperty' commands are shown below:SELECT SERVERPROPERTY('ProductLevel') level , SERVERPROPERTY('ProductVersion') versionLEVEL VERSION SP4 8.00.2039 <<<<<<<< target SP4 8.00.2050 <<<<<<<< source is this version difference which is not letting me restore the master database ? Isnt this version difference coming from being standard or enterprise edition ? and if yes I thought I could restore a system database from enterprise edition to standard .. or can I not ? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-22 : 16:33:28
|
| http://support.microsoft.com/kb/264474 |
 |
|
|
aliyesami
Starting Member
30 Posts |
Posted - 2008-08-22 : 16:52:08
|
| hi I read the article it says :"If the "Backup Build" is larger than the "SQL Server Build," install all the necessary service packs or hotfix builds to roll the server software forward to the "Backup Build" that was determined previously. Then, go to step 6."this is my case ... my backup build is 2050 and my SQL server build is 2039 . I have installed SP4 so what other 'hotfix builds' the article is talking about that I can apply ? where can I download them for SQLserver 2000? I thought the only thing i needed to apply was SP4 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-22 : 17:00:44
|
| [quoite]NOTE: The target database is showing SP2 with 'select @@version' command, where as I have applied sp4 to this database and the commands below show that . so I guess this is some kind of bug in sqlserver 2000.[/quote]It isn't showing as SP2 for @@VERSION. That's the OS service pack level. The SQL service pack level (patch level, build number, ...) is 2039/2050. Check out the SELECT @@VERSION article here for more information.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
aliyesami
Starting Member
30 Posts |
Posted - 2008-08-22 : 17:51:38
|
| ok but how do I get the build 2050 ? i have search the MS site and the only they they are offering is cumulative hotfix build 2187 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
aliyesami
Starting Member
30 Posts |
Posted - 2008-08-22 : 18:34:58
|
| thanks Tara but I am not finding any downloads for build 2050 on this page , can you please guide me ? all its showing is details of various versions and builds. . if you can send me the URL for downloading specifically build 2050 I will be greateful |
|
|
|
aliyesami
Starting Member
30 Posts |
Posted - 2008-08-22 : 19:31:07
|
| I found it .. thanks a lot for your help , after the hotfix i could restore the system databases from the backup. |
|
|
|
swekik
Posting Yak Master
126 Posts |
Posted - 2009-02-05 : 17:07:46
|
| Hi Tara,Do you know whether this hot fix is included in 2005 SP3 ? I couldn't find that in the list of hotfixes in SP3 .In which CU fix does this hotfix included? |
|
|
|
|
restoring master database