| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | ||
|---|---|---|---|---|---|---|---|---|---|---|---|
MSSQLSERVER_3169 |
MSSQLSERVER_3169 |
MashaMSFT |
mathoma |
04/04/2017 |
sql |
supportability |
reference |
|
|
[!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.