1 Answer
- Newest
- Most votes
- Most comments
1
Hello.
To change your EC2 instance type from "Windows with SQL Server" to "Windows Standard" without SQL Server, follow these steps bellow.
1. Create a Backup (AMI) of Your Existing Instance
- In the AWS Management Console, go to EC2 > Instances.
- Select your current EC2 instance (m6i.2xlarge with SQL Server).
- Choose Actions > Image and templates > Create image to create an AMI as a backup.
2. Launch a New EC2 Instance with Windows Standard
- Navigate to EC2 > Instances > Launch instances.
- Choose Microsoft Windows Server (without SQL Server) from the available options.
- Select the same instance type, m6i.2xlarge.
- Use the same settings (VPC, subnet, security groups) as your current instance.
3. Detach and Attach EBS Volumes
- After launching the new Windows instance, stop both the current and new instances.
- In the EC2 console, go to Volumes and locate the EBS root volume of your current instance.
- Detach this volume and then attach it to the new instance (make sure it's attached as the root volume, /dev/sda1).
4. Verify and Restart
- Start the new instance.
- Check that the new instance boots correctly and all your data and applications are intact (minus the SQL Server).
5. Terminate the Old Instance
- Once you've confirmed the new instance is functioning correctly, you can terminate the old instance with SQL Server to avoid additional costs.
https://repost.aws/knowledge-center/ec2-windows-launch-sql-server
https://docs.aws.amazon.com/sql-server-ec2/latest/userguide/setting-up.html
Relevant content
asked a year ago
- AWS OFFICIALUpdated 6 months ago

Thank bro, it's helpful in my case.