June 15, 2002 at 2:01 am
I'm trying to restore a set of nightly backups from one Sql 2K Server
Machine to my sql2k test box. First, I use "c>sqlservr -c -m" to set single-user mode and type the following in QA:
restore database master from disk= 'C:\backup\master_db.BAK' with replace
When I execute the above statement I get the error message
>>>
Server: Msg 3168, Level 16, State 1, Line 1
The backup of the system database on device C:\backup\master_db.BAK
cannot be restored because it was created by a different version of the server (134218112) than this server (134217922).
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
>>>
What is this referring to? I believe the original Sql 2K was a Standard edition and the one on my test box is Sql 2K Dev edition. (I used the same Sql SP for both mahcines)? Is there a workaround?
June 15, 2002 at 7:18 pm
I have only seen this type of message when trying to restore a 2000 backup to 7. I have done serveral restores from SQL Standard to Dev, and Enterprise with no issues. Can you run SELECT @@VERSION on both servers and post here please?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 15, 2002 at 9:52 pm
Antares,
I did a "select version" on both machines.
My Development Box:
------------------
Microsoft SQL Server 2000 - 8.00.534 (Intel X86)
Nov 19 2001 13:23:50
Copyright (c) 1988-2000 Microsoft Corporation
Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
From Production Box:
--------------------
Microsoft SQL Server 2000 - 8.00.384 (Intel X86)
May 23 2001 00:02:52
Copyright (c) 1988-2000 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
My Development Box: 8.00.534 = Sp2
Production Box: 8.00.384 = Sp1
So there is a difference in Sql Sp's! I will experient to see if this is the source of the error.
Bill
June 16, 2002 at 12:06 am
Antares,
I found the error thanks to your directions. The problem was that Sql SP 1 was installed on the production box and I had not done the same for my development box. To be honest, I thought that under Sql 7 I had gotten away restoring the Sql server then applying the SP, in that order. But that doesn't make any sense, does it?! Better burned now than burn later.
Bill Salkin
June 16, 2002 at 8:17 am
Honestly it seems to me that SP2 on the Dev box should have been fine as you were moving forward in revision but SP1 could be a problem if you moved from dev to prod. But maybe master is treated deifferently. Glad you found a solution.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply