| title | MSSQLSERVER_3169 | |
|---|---|---|
| description | MSSQLSERVER_3169 | |
| author | MashaMSFT | |
| ms.author | mathoma | |
| ms.date | 04/04/2017 | |
| ms.service | sql | |
| ms.subservice | supportability | |
| ms.topic | reference | |
| f1_keywords |
|
|
| helpviewer_keywords |
|
[!INCLUDE SQL Server]
| Attribute | Value |
|---|---|
| Product Name | SQL Server |
| Event ID | 3169 |
| Event Source | MSSQLSERVER |
| Component | SQLEngine |
| Symbolic Name | NA |
| Message Text | The database was backed up on a server running version %ls. That version is incompatible with this server, which is running version %ls. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. |
Certain features in [!INCLUDEssNoVersion] affect the structure of the database files. When you restore a database to another instance of [!INCLUDEssNoVersion], the file format might not be compatible with a different version of the [!INCLUDEssDEnoversion].
For example, this error can be caused by using the vardecimalstorage format in a later version of [!INCLUDEssNoVersion] and then trying to restore the database files in a version earlier than [!INCLUDEssVersion2005] Service Pack 2.
Determine the version of [!INCLUDEssNoVersion] that is running on the originating server. In [!INCLUDEssManStudioFull], either right-click the server and then click Properties or type SELECT @@VERSION in a query window. Open the database by using the original version of [!INCLUDEssNoVersion]. Investigate the features that are enabled on the original database in the instance of [!INCLUDEssNoVersion]. Modify these settings to work with the version of [!INCLUDEssNoVersion] in which the database will be restored.