By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Update instance type of EC2 running SQL server

0

A customer is running SQL Server Standard 2012 on an i2.xlarge instance. He wants to upgrade to i3.xlarge and SQL Server Standard 2017.

Are there any issues with SQL server and changing the instance type?
Things like SQL expecting certain processor types or numbers?

IS this the correct steps for the upgrade?

  1. Stop the instance
  2. change the instance type to i3.xlarge
  3. start the instance
  4. upgrade sql server to 2017
Topics
DatabaseCompute
Tags
Microsoft SQL ServerAmazon EC2
Language
English
AWS
MODERATOR
AWS-User-4245468
asked 5 years ago849 views
1 Answer
2

AWS has also created System Manager Automation workflows to assist with the upgrade of SQL Server, the below documentation will provide more information: https://docs.aws.amazon.com/systems-manager-automation-runbooks/latest/userguide/automation-awsec2-CloneInstanceAndUpgradeSQLServer.html

Alex_M
answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content