June 23, 2003 at 11:34 pm
Hi Guys
Pls. find the OS & SQL Configuration details
Windows 2000
SQL Server 2000 Standard Edition
Service Pack 2
Product Version Old : 8.00.679 (SP2)
New : 8.00.534 (SP2)
Pls. find the following error msg, while restoring the master database from
Production to Disaster,
Microsoft SQL-DMO (ODBC SQLState:42000)
The backup of the system database on device <path> cannot be restored
because it was created by a different version of the server (134218407) than
this server (134218262).
RESTORE DATABASE is terminating abnormally.
Can you guys help me out here.How do I resolve this error.
June 24, 2003 at 12:01 am
Hi
Interesting problem..
8.00.679 SP 2 + Q316333
8.00.534 Service Pack 2
Try applying Q316333 and try again.
See http://www.krell-software.com/Resources/mssql-builds.htm
Cheers
Ck
Chris Kempster
Author of "SQL Server 2k for the Oracle DBA"
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
June 24, 2003 at 6:52 am
Were any changes made to the Operating System? I've restored successfully after upgrading Service Packs to SQL Server so that shouldn't be your problem. But upgrading your operating system could be.
-SQLBill
June 24, 2003 at 11:49 am
Chris is right. You have to have both SQL Server at same level of SQL Servers and patches for master database restoration.
Edited by - Allen_Cui on 06/24/2003 11:49:34 AM
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply