MSSQLSERVER_3168
Details
Product Name |
SQL Server |
Product Version |
10.0 |
Product Build Number |
- |
Event ID |
3168 |
Event Source |
MSSQLSERVER |
Component |
SQLEngine |
Symbolic Name |
LDDB_SYSTEMWRONGVER |
Message Text |
The backup of the system database on the device %ls cannot be restored because it was created by a different version of the server (%ls) than this server (%ls). |
Explanation
You cannot restore a backup of a system database (master, model, or msdb) on a server build that differs from the build on which the backup was originally performed.
Uwaga
Installing a service pack or a hotfix build changes the server build number, and server builds are always incremental.
Possible Causes
The database schema for system databases may be changed across server builds. To make sure that a schema change does not cause inconsistencies, the RESTORE statement compares the server build number on the backup file to the build number of the server on which you are trying to restore the backup. If the builds are different, the statement issues the 3168 error message, and the restore operation terminates abnormally.
Some scenarios in which this problem may occur include the following:
A user tries to restore a system database on Server A from a backup taken on Server B. Servers A and B are on different server builds. For example, Server A might be on the original release version build and Server B might be on a service pack 1 (SP1) build.
A user tries to restore a system database from a backup taken on the same server. However, the server was running a different build when the backup occurred. That is, the server was upgraded since the backup was performed.
User Action
The restore process in this situation is fairly involved, and used only as a last resort. For more information, see "You cannot restore system database backups to a different build of SQL Server".