cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Highlighted

queries about ePO DB downgrade

Team,

We have ePO 5.9.1 installed with SQL 2016 Enterprise edition. ePO and DB are on seperate servers

We need to know if we have to downgrade the SQL database from SQL 2016 Enterprise to SQL 2016 Standard edition, what are the pros and cons of it. 

Is it possible to do so

What are the best practises to be followed for such activity

Do we have a kb article showing the best practises for this. 

Will this affect the ePO events for the last 6 months. in the existing DB

Any changes that we will have to make manually in the ePO application console post downgrade

Will this affect the automatic responses in any way 

5 Replies
Highlighted
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 2 of 6

Re: queries about ePO DB downgrade

That might be a Microsoft question, but I really don't believe that would be a good idea.  The enterprise version has additional features/schema that standard does not and when a database is in one instance of sql, it inherits that versions schema.  I don't believe you can downgrade it.  I know you can't downgrade versions, but I would suspect the same stands true for feature sets.

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

Highlighted
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 3 of 6

Re: queries about ePO DB downgrade

There is no impact on ePO Events due to version change. Maybe you have to do re-config again(under core/config), amake sure that you are not changing the server name and ip and using same credentials.

There is no McAfee KB article for downgrading the SQL version but you are not using any enterprise edition feature then you can go ahead and follow simple steps.

* Take Full backup of ePO and copy mdf and ldf files to some other location.

* Uninstall Enterprise edition and install Standard edition.

* Attach the database again.

Highlighted
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 4 of 6

Re: queries about ePO DB downgrade

Run this query against the epo database. 

SELECT *FROM sys.dm_db_persisted_sku_features

If it returns any rows, you can't downgrade to standard.

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

Highlighted
Reliable Contributor
Reliable Contributor
Report Inappropriate Content
Message 5 of 6

Re: queries about ePO DB downgrade

@cdinet ,

Similar question to the original post, we are on epo 5.10 update 6 and SQL running on Enterprise. We would like to downgrade SQL to standard to save licensing cost. 

I ran the command  "SELECT *FROM sys.dm_db_persisted_sku_features" against two database EPO

EPO_serveraname  - Didn't return any rows. 

EPO_servername_Events. - Returned one row

"Feature_Name " = Partitioning & Feature_id = 200

Does this mean we can't downgrade to SQL standard edition?

2020-02-25 09_36_17-GENSDP - ASG-RemoteDesktop 2019 - __Remote.jpg

 

 

In case above information was useful or answered your question, please select "Accept as Solution" in my reply, or give a Kudo. Thanks!
Highlighted
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 6 of 6

Re: queries about ePO DB downgrade

Depending on the version of sql that you are using and SP level, it may be ok.  Please refer to this comparison of features, but I am not sure if it would also need partitioned table parallelism or not.  It will, however, support the functionality of the partitioned tables.

https://dba.stackexchange.com/questions/159556/does-sql-server-2016-standard-edition-support-table-p...

 

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

You Deserve an Award
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from McAfee experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by McAfee employees.
Join the Community
Join the Community