July 13, 2015 at 3:06 pm
Hello,
Is it possible to restore sql server 2012 enterprise edition database on a standard edition of SQL server 2012
Thanks
SM
July 13, 2015 at 3:19 pm
It is possible, so long as the DB has no Enterprise-only features enabled (compression or partitioning, for example).
You can check by running this in the database on the Enterprise instance:
SELECT * FROM sys.dm_db_persisted_sku_features
Cheers!
July 13, 2015 at 3:27 pm
So if the Standard SQL Server 2012 has these features enabled such as compression or partitioning , then it won't be possible
to restore the SQL server 2012 Enterprise Database on SQL server 2012 Standard SQL server.
Is this correct ?
Another question can we install SQL server Enterprise 2012 on the same server where SQL server 2012 standard is already installed
as a separate instance so that SQL server Enterprise 2012 and SQL server standard 2012 co exist on the same server.
Thanks for your help
SM
July 13, 2015 at 3:37 pm
No. Features like data compression and partitioning are features only available in Enterprise edition.
If the Enterprise edition database is using those features, then you will not be able to restore it to Standard edition.
You can install multiple instance on a machine, with some of them being Enterprise and some being Standard. I generally shy away from installing multiple instances on the same machine, but it does make sense sometimes.
Cheers!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply