Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bogey
Posting Yak Master
166 Posts |
 Posted - 2009-06-23 : 17:02:00
|
| I've installed sp2 for sql server 2005 and my version is 9.00.3042 I'm trying to rebuild a server from our production backups and I'm getting the error The backup of the system database on the device Z:\master_backup_200906221801.bak cannot be restored because it was created by a different version of the server (9.00.3077) than this server (9.00.3042). (Microsoft.SqlServer.Smo) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-06-23 : 18:01:56
|
| Looks like your backup was performed on an earlier build of SQL. That's why you need to backup the systems databases regularly. You'll need to install SQL Server so that it is at the same build level as the old server, perform your restores, and then install whatever cumulative update package 3077 is. I'd recommend just going to build 4211, which is the latest as far as I know.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
 |
|
|
bogey
Posting Yak Master
166 Posts |
Posted - 2009-06-24 : 09:04:24
|
| Tara - We cannot update our production to the latest build at the moment. We are testing our DR and need to get a copy of the production up and running thats why I'm looking to get my "copy" of sql server up to the release number of our production. Where can I find this update?: Thanks Tara :)Microsoft SQL Server 2005 - 9.00.3077.00 (Intel X86) Dec 17 2008 15:19:45 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2) |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
|
|
|
|
|
Trying to restore master but getting version error