|
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?
(comments are locked)
|
|
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 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 '12 at 06:20 PM
SirSQL
(comments are locked)
|
