Import .bak file in Microsoft SQL Server 2008 Service Pack 3 I have a backup of my database as a TestDatabase.bak file but I am unable to restore it.

When I try to restore I receive the following error message in SSMS: 


  RESTORE could not start database 'FieldopsDevDynamic07042013'




The error log shows:


  Database 'FieldopsDevDynamic07042013' cannot be started because some
  of the database functionality is not available in the current edition
  of SQL Server.




How can I restore this database?
Your backup is from a database that is using Enterprise Edition features. You are trying to restore it to an Express Edition server. That will not work.

The message in your error log is telling you exactly that:


  Database 'FieldopsDevDynamic07042013' cannot be started because some
  of the database functionality is not available in the current edition
  of SQL Server.


The error log even tells you which feature is causing the problem:


  Database 'FieldopsDevDynamic07042013' cannot be started in this
  edition of SQL Server because it contains a partition function...


Try restore to an Enterprise or Developer edition server. If it still fails update your question with the result of your attempt.