Practice Exam

Question 46 of 75

Downgrade SQL Server From Enterprise To Standard Edition

You work for MDFT Pro, a well-known training agency with a SQL Server on Azure Virtual Machines instance named TrainingVM that was deployed using an Azure Marketplace SQL Server 2019 Enterprise image. Mark, the License Compliance Manager, has reviewed the company’s SQL Server licensing and discovered that the Enterprise edition features are not being used, resulting in unnecessary licensing costs. The databases on TrainingVM only use Standard edition features such as basic availability groups, standard backup compression, and basic performance features. Mark wants to change the SQL Server instance on TrainingVM to the Standard edition to reduce licensing costs while ensuring full compliance with Microsoft licensing requirements. Before making the change, he needs to understand the correct procedure.

What should you do first?

Choose the correct answer from the options below.

Explanations for each answer:

Learn more about Changing SQL Server Editions:
SQL Server Edition Changes
Next Question
Discuss this question on social media: