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