When server comes back after the reboot navigate to the SQL database file location found in step 3 and confirm the system databases do not exist.

To make copies of the files, Shutdown the SQL Server service and copy the files to another location as these will be used later.ĥ) Uninstall SQL Server from Control Panel the following components:Ħ) SQL Server Management Studio, Client Tools and Connectivity do not require to be uninstalled as they are Shared Components.ħ) Reboot the server after uninstall is complete. The location of these files can be obtained from the previous step. SELECT name, physical_name AS current_file_locationĤ) Create copies (mdf and ldf files) of the system database master, model and msdb. To view this information launch SQL Management Studio and execute the following command: SELECT Execute the following script in new query to determine location of database files: Databases should be backed up prior to performing this procedure.*ġ) Create Database Backups of ION_Data, ION_Network, ApplicationModules.Ģ) Check the current version of SQL and build number. This procedure should only be performed by users familiar with SQL Server Management Studio. *Warning: Irreparable database damage can occur.

Need to downgrade to SQL Standard Edition. Enterprise Edition features are not required plus don't want to pay for the additional licensing. SQL Server that was installed is Enterprise Edition. SQL Server 2012, SQL Server 2014 and SQL Server 2008 R2 How to Downgrade from SQL Server Enterprise Edition to Standard Edition

Sql server enterprise manager