| title | MSSQLSERVER_948 | |
|---|---|---|
| description | MSSQLSERVER_948 | |
| 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 | 948 |
| Event Source | MSSQLSERVER |
| Component | SQLEngine |
| Symbolic Name | NA |
| Message Text | The database '%.*ls' cannot be opened because it is version %d. This server supports version %d and earlier. A downgrade path is not supported. |
Certain features in [!INCLUDEssNoVersion] affect the structure of the database files. When you attach a database to another instance of [!INCLUDEssNoVersion], the file format might not be compatible with a different version of the [!INCLUDEssDE].
For example, this error can be caused by using the vardecimal storage format in a later version of [!INCLUDEssNoVersion] and then trying to attach 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 attached.