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 (https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/InstanceStorage.html), 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