Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Master Restoration on New SQL Server
Message
 
 
À
15/09/2008 11:21:58
Greg Rowe
Memphis Police Department
Memphis, Tennessie, États-Unis
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Copies de sauvegarde
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01347638
Message ID:
01347641
Vues:
11
>I attempted to restore master onto a new server and received the following error message:
>
>The backup of the system database on device L:\Production Backup\master.bak cannot be restored because it was created by a different version of the server (134219767) than this server (134219915). RESTORE DATABASE is terminating abnormally”.
>
>The production server’s @@version info is
>
>Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
> May 3 2005 23:18:38
> Copyright (c) 1988-2003 Microsoft Corporation
> Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
>
>
>The new server’s @@version info is
>
>Microsoft SQL Server 2000 - 8.00.2187 (Intel X86)
> May 9 2006 11:38:51
> Copyright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
>
>I looked online to compare 8.00.2039 and 8.00.2187. The both refer to MS-SQL 2000 service pack 4.
>
>Any suggestions on how I can restore master database onto the new server?
>
>

Something is strange with the number 2187. See SQL Server Versions

Could it be some beta installed? Is it possible to re-install SP4 on this machine?
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform