Can SQL 2008 Enterprise create a backup file compatible with the Standard version?

Trying to restore a backup file created with SQL 2008 Enterprise on a system with the SQL 2008 Standard edition. The bak file restore is failing, indicating that it contains a partition function, and that partitions are only supported by the Enterprise edition.

Is it possible to create a version of the bak file that is fully compatible with the Standard version of SQL from the Enterprise version?

more ▼

asked Jul 03, 2012 at 05:45 PM in Default

avatar image

0 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

No. If you need to be able to restore from enterprise to standard, you cannot use any enterprise-only features

More detail can be found here - http://www.sqlmag.com/blog/sql-server-questions-answered-28/sql-server/can-i-restore-my-enterprise-edition-database-on-all-editions-of-sql-server-137118

more ▼

answered Jul 03, 2012 at 05:59 PM

avatar image

25k 3 13 20

You can run a quick query on any databases prior to attempting to restore it elsewhere. If you have any results from

SELECT * FROM sys.dm_db_persisted_sku_features

then you'll not be able to restore it to anything other than enterprise/datacenter or dev edition.

Jul 03, 2012 at 06:20 PM SirSQL
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jul 03, 2012 at 05:45 PM

Seen: 962 times

Last Updated: Jul 03, 2012 at 06:20 PM

Copyright 2018 Redgate Software. Privacy Policy