Skip to content

mssqlserver-905-database-engine-error.md

Latest commit

 

History

History
32 lines (27 loc) · 1.84 KB

mssqlserver-905-database-engine-error.md

File metadata and controls

32 lines (27 loc) · 1.84 KB
title MSSQLSERVER_905
description MSSQLSERVER_905
author MashaMSFT
ms.author mathoma
ms.date 04/04/2017
ms.service sql
ms.subservice supportability
ms.topic reference
helpviewer_keywords
905 (Database Engine error)

MSSQLSERVER_905

[!INCLUDE SQL Server]

Details

Attribute Value
Product Name SQL Server
Event ID 905
Event Source MSSQLSERVER
Component SQLEngine
Symbolic Name DBSTARTUP_EE_PARTITIONING
Message Text Database '%.*ls' cannot be started in this edition of SQL Server because it contains a partition function '%.*ls'. Only Enterprise edition of SQL Server supports partitioning.

Explanation

The database contains one or more partitioned tables or indexes. This edition of [!INCLUDEssNoVersion] cannot use partitioning. Therefore, the database cannot be started correctly. Partitioned tables and indexes are not available in every edition of [!INCLUDEmsCoName] [!INCLUDEssNoVersion]. For a list of features that are supported by the editions of [!INCLUDEssNoVersion], see Features Supported by the Editions of SQL Server 2016.

User Action

Detach the database by using the sp_detach_db stored procedure. Move the files if it is needed, and then attach the database to an instance of a supported [!INCLUDEssNoVersion] edition by using the CREATE DATABASE with the FOR ATTACH or FOR ATTACH_REBUILD_LOG option. Disable partitioning on all tables and remove the partitioning functions. Detach the database again, and reattach the database to the current server.