asked
SQL Server 2014 Partition Function
Hi All, I have a backup copy of database from SQL Server 2005 Enterprise Edition and I restored that backup in SQL Server 2014 Standard Edition. Then I got an error. See below: Msg 3013, Level 16, State 1, Line 8 RESTORE DATABASE is terminating abnormally. Msg 905, Level 21, State 1, Line 8 Database 'TestDB' cannot be started in this edition of SQL Server because it contains a partition function 'TestDB_PartitionRange'. Only Enterprise edition of SQL Server supports partitioning. Msg 933, Level 21, State 1, Line 8 Database 'TestDB' cannot be started because some of the database functionality is not available in the current edition of SQL Server. From this error I checked my 2005 database there is no partition scheme so can you suggest any solution for above error? Thanks & Regards, Sakthi
You have some good answers below. This web site runs by you voting and marking the best answers. For each helpful answer below, indicate this by clicking on the thumbs up symbol next to those answers. If any one answer lead to a solution, indicate this by clicking on the check mark next to that answer. This helps indicate your solution for anyone else with the same question.
You can run this code to check for partitions: select * from sys.partitions You can run this to get a list of partitioned tables: select * from sys.partitions p inner join sys.tables t on p.object_id = t.object_id where p.partition_number <> 1 Here is a thread from SQLServerCentral on finding partitions:
http://www.sqlservercentral.com/Forums/Topic992539-391-1.aspx Hope this helps.
check sys.partition_schemes for an existing scheme, the error suggests you have a portioned table in the database
Given that the error message makes reference to a partition function, have you tried looking in sys.partition_functions? It is, after all, possible to have a partition function without associating it with a partition scheme.
22 People are following this question.
