I am looking to use vmss for an application with multiple instances. however i am not sure how upgradepolicy works.
If i set it to automatic. then does this mean all the configuration on my existing vmss instances shall be replicated to a new instance if it comes up after scaling?
for eg. If I have currently one instance in vmss with sql server image and i have manually created new database with some database.Then i perform manual scaling , and a new instance comes up. how can I ensure, the new instance has the same configuration including database and data? or for that matter any custom application that is deployed on the vm.