Click here to Skip to main content
13,150,539 members (31,348 online)
Click here to Skip to main content
Add your own
alternative version


3 bookmarked
Posted 17 Sep 2012

SQL Server: Restore Failure from Enterprise to Standard Edition

, 19 Apr 2013
Rate this:
Please Sign up or sign in to vote.
Restore failure from Enterprise to Standard edition in SQL Server.

Yes you can restore a backup file which is taken from SQL Server Enterprise Edition in Standard Edition but if the source database is not using Enterprise Edition specific features, like partition functions in our case, it could be a problem.

This happened to one of my juniors when he was restoring a database (on SQL Server 2008 R2 Standard Edition) from full backup, which was taken from SQL Server 2008 R2 Enterprise edition. A 6 GB database backup file took more than half an hour to restore and after showing 100 percent completion, on starting database, it returned FAILURE ERROR.

Database 'SQL2008R2_Ent_PartitionFunction' cannot be started in this edition of SQL Server 
   because it contains a partition function 'SSF_PF_Right'. 
   Only Enterprise edition of SQL Server supports partitioning.
Database 'SQL2008R2_Ent_PartitionFunction' cannot be started because some of the database functionality 
   is not available in the current edition of SQL Server. (Microsoft SQL Server, Error: 905)

Basically the restore process is completed successfully and you can see the database name in the list and its files on required location but in inaccessible mode.

I think Microsoft should improve this process and these prerequisites should be checked first.


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

aasim abdullah
Team Leader CureMD
Pakistan Pakistan
Aasim Abdullah is working as SQL Server DBA with CureMD ( based in NY, USA. He has been working with SQL Server since 2007 (Version 2005) and has used it in many projects as a developer, administrator, database designer. Aasim's primary interest is SQL Server performance tuning. If he finds the time, he like to sketch faces with graphite pencils.

You may also be interested in...


Comments and Discussions

AnswerSolution is here (if you correct script for your needs - this is MS CRM solution) Pin
Member 102504092-Jun-15 23:44
memberMember 102504092-Jun-15 23:44 
GeneralMy vote of 1 Pin
Marcus Kramer2-Oct-12 12:26
memberMarcus Kramer2-Oct-12 12:26 
GeneralRe: My vote of 1 Pin
aasim abdullah2-Oct-12 20:41
memberaasim abdullah2-Oct-12 20:41 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.170924.2 | Last Updated 19 Apr 2013
Article Copyright 2012 by aasim abdullah
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid