Event Id | 905 |
Source | MSSQLServer |
Description | 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. |
Event Information | According to Microsoft: Cause: The database contains one or more partitioned tables or indexes. This edition of SQL Server cannot use partitioning. Therefore, the database cannot be started correctly. Partitioned tables and indexes are supported only in the SQL Server Enterprise and Developer editions. Resolution: 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 the Enterprise or Developer editions 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. |
Reference Links | Event id:905 Source:MSSQLServer |
Catch threats immediately
We work side-by-side with you to rapidly detect cyberthreats
and thwart attacks before they cause damage.