![]() That is, the server was upgraded since the backup was created. However, the server was running a different build when the backup process ran. You try to restore a system database from a backup that's taken on the same server. For example, Server A might be on the original release version build and Server B might be on a service pack 1 (SP1) build. Servers A and B are on different server builds. You try to restore a system database on Server A from a backup that's taken on Server B. Some scenarios in which this problem might occur include the following: If the builds are different, the statement issues a "3168" error message, and the restore operation terminates abnormally. To make sure that a schema change doesn't cause inconsistencies, the RESTORE statement compares the server build number of the backup file to the build number of the server on which you are trying to restore the backup. The database schema for system databases might be changed across server builds. ![]() Installing a servicing update like cumulative update or service pack or a GDR changes the server build number.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |