I'm trying to downgrade my ec2 instance from sql enterprise to sql standard or express, the thing i wanna keep the server content and i can't start from scratch. i've tried uninstalling sql server and change the instance type, but i get this error message "Microsoft SQL Server Enterprise Edition is not supported for the instance type" since i started the instance with sql server enterprise. how can i downgrade the instance to standard or express ?

Thank you


This isn't possible. You'll need to export your data, create a new instance, then import the data into the new instance.

  • Can you please tell a bit more about exporting data ? – Omiga May 3 at 21:25
  • I don't know anything about SQL Server sorry. Use whatever tools MS provides to export schema and data, then the same tools to import back in - Google should find them. If you need help with that please ask a question on the Stack Exchange DBA site. – Tim May 4 at 0:30
  • Thank you for the help, i think i can backup the database and import it somewhere else, what i don't know is if it's possible to export the rest of the os content to another ec2 instance avoiding "the instance type" error i'm getting on aws – Omiga May 4 at 5:23
  • 1
    What is "OS content"? Servers have applications and data. Install the applications, transfer the data, go. – Tim May 4 at 8:02
  • i just was looking for an easy way to do it i guess, thank you – Omiga May 4 at 17:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.