September 19, 2008 at 12:25 pm
Hi,
I am trying to restore master from backup. While restoring I get the following error.
"Database cannot be restored because it was created by a different version of the server (134218713) than this server (134219768)"
I know that this error is due to the build mismatch.
I have SQL 2000 SP3a installed. I googled for build 134219768 and found out that the hotfix found at http://support.microsoft.com/kb/890942 is the solution for this. But on this page, I cannot find any link to download the hotfix. Please let me know how to obtain this hotfix.
This is really urgent for me and I badly need your help.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 19, 2008 at 1:04 pm
Make sure you install the same edition and service pack (+ hotfix) than your original server !
- I would try to reinstall that instance (starting from rtm) trying to restore master.
- If that does not succeed, apply sp1 ,
try to restore master
.....
simple but effective ... may take some time ...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 19, 2008 at 7:44 pm
Thanks a lot for your response.
I know that to restore this master backup, the version has to be
SP3a + Hotfix (http://support.microsoft.com/kb/890942).
My problem is that I am not able to download the Hotfix from http://support.microsoft.com/kb/890942.
Please let me know how to obtain this particular Hotfix.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply