Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

MSSQLSERVER_3168

Product Name

SQL Server

Product Version

10.50

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

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.

NoteNote

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.

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.