Database 'ContosoRetailDW' cannot be started in standard edition of SQL Server: this information is missing within system requirements!

Question

Hello all.

My goal for today was to do some tutorials with Report Builder 3.0: Tutorial: Creating Drillthrough and Main Reports (Report Builder 3.0). Looking through the Microsoft websites I have got the advice to use the Contoso database. I found my systems requirements met: Microsoft SQL Server 2008!! I have a Standard Edition of SQL Server 2008 R2 in place! Not one word pointed out that I would need Enterprise Edition of SQL Server 2008 R2.

I have got this message when I tried to restore the backup file ContosoRetailDW.bak:

----------------------------------------------------------------------------------------------------------------------------------------------------------

TITLE: Microsoft SQL Server Management Studio
------------------------------

Restore failed for Server.  (Microsoft.SqlServer.SmoExtended)
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Database 'ContosoRetailDW' cannot be started in this edition of SQL Server because part or all of object 'DimProduct' is enabled with data compression or vardecimal storage format. Data compression and vardecimal storage format are only supported on SQL Server Enterprise Edition.
Database 'ContosoRetailDW' cannot be started because some of the database functionality is not available in the current edition of SQL Server. (Microsoft SQL Server, Error: 909)

-----------------------------------------------------------------------------------------------------------------------------------------------------------

Is there a way to do the tutorial with Contoso database and the Standard Edition of SQL Server 2008 R2?

For help thanks in advance.

Regards

Answer 1

Hi Andi,

We cannot restore a backup of a database which has compressed objects in sql Standard edition because data compression is only supported in Enterprise edition, refer to http://technet.microsoft.com/en-us/library/cc645993(SQL.100).aspx So you need to remove the features before you perform the full backup and restore the database.

For more information about this question, please see:
http://blogs.msdn.com/b/sqlserverfaq/archive/2010/09/03/how-to-identify-compressed-tables-before-restoring-migrating-database-to-any-edition-other-than-enterprise-edition-of-sql-server-2008.aspx

If you have any questions, please feel free to ask.

Regards,
Charlie Liao

If you have any feedback on our support, please click here.

---

Charlie Liao
TechNet Community Support

Answer 2

Hi Charlie Liao,

thank you for your response.

Do you know if there is one of the tutorial provider who is going to provide a contoso database which can be used with standard edition of SQL Server 2008 R2?

At least one of them should update the system requirements if no applicable database is offered!!

Thank you.

Regards,

Andi