x

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

freediverx gravatar image

freediverx
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

KenJ gravatar image

KenJ
20k 1 3 12

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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1840
x9
x3

asked: Jul 03, 2012 at 05:45 PM

Seen: 752 times

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