locked
Adventure Work install problems RRS feed

  • Question

  • I have sql server 2014 express installed on my laptop and am trying to download the sample database Adventure Works. I installed the 2008 version and dragged the file into my sql server backup folder and attempted to restore the file but get the following error message when trying.

    Database AdventureWorks cannot be started in this edition of SQL Server because it contains a partition function TransactionRangePF1

    "

    Saturday, February 7, 2015 12:49 AM

Answers

All replies

  • Since you are Express edition, you can't restore a database that is using Enterprise feature such as Partitioning. Download the right Adventureworks DB here: https://msftdbprodsamples.codeplex.com/releases/view/125550

    Satish Kartan www.sqlfood.com

    Saturday, February 7, 2015 1:04 AM
  • Hi J Price,

    Based on my research, the error is caused by the edition of your SQL Server is Express, while the TransactionRangePF1 function uses partitioning which is only available for Microsoft SQL Server Enterprise and Developer editions.

    To fix this issue, we should disable partitioning on all tables and remove the partitioning functions. For more details, please refer to the following KB:
    https://support.microsoft.com/kb/2567984?wa=wsignin1.0
    http://dba.stackexchange.com/questions/33870/restore-database-from-backup-file-of-different-version-edition

    Thanks,
    Katherine Xiong


    Katherine Xiong
    TechNet Community Support

    Monday, February 9, 2015 4:25 AM
  • I don't know why the above reply has been given an Answered status.  The link provided doesn't show a solution to the problem, apart from either installing the Enterprise edition or remove/backup using Enterprise edition.

    I've installed SQL Server 2014 Express to do tutorials etc.  So I've downloaded SQL Server 2014 sample databases, AdventureWorksDW2008Big, ADWorks and having the same error as the above. 

    Apart from wanted to know how to overcome this problem I would also like to ask why on earth Microsoft SQL Server Sample databases team created those partitionings so that users like me cannot use it on Express editon.  After all the whole point for those Sample dbs is to learn and practice, meaning for someone who is not yet professional in this field and for someone who most probably will install Express edition to learn?

    At least they could have created 2 versions, one for Express and another for Enterprise.

    • Edited by Alex Teslin Thursday, November 5, 2015 11:45 AM
    Thursday, November 5, 2015 11:43 AM