January 17, 2011 at 5:07 pm
I'm basically verifying each steps that I will do during weekend for the migration. when I backuped the master db from the old and restore to the new server, I got an error saying "The backup cannot be restored because it was created by a different version of the server than this server". They are same sql server 2000 and same OS. Here's what I'm getting from @@version. Can the different dates and different numbers in 8.00.xxxx cause the error?
Old server: Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 ...
New server: Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 ....
January 17, 2011 at 9:42 pm
The new server needs to be on the same build (2039) as that of the old server. This article has more details.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply