Changing instance type results in destroying and provisioning a new instance

Hi, basic question ig i change instance type , it will destroy the instance and provision a new instance?

If you mean an EC2 instance - no it will not. Stop the instance, change the type and then power on again, and it will have more resources.

And I will caveat that statement .

If you are using EC2 with ephemeral storage (, once you shut down the instance, all the data on that volume, will be lost.

Thanks, actually in sql server installates on ec2 instance with ebs volumes

I have to mention that i want to do it on the secondary node, which mean nothing written there