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