MSSQLSERVER_3168

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Details

Product Name

SQL Server

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.

Note

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".

See Also

Concepts

Back Up and Restore of System Databases (SQL Server)