Has anyone found a way to take a EBS snapshot for a Windows Server that maintains Application Consistency? In my case it's with SQL and I'd like to maintain SQL app consistency.
Either via quiescing the DB directly (as you can do on oracle
alter database begin backup,
ec2-create-snapshot vol-abcd1234,
alter database end backup)
or via VSS as SQL is VSS aware?
Best Answer
This question was asked before, it has a couple of viable options.
You can always stop the server, start the snapshot, and then immediately restart the server. It's the safest option, but quite disruptive.
You could of course use SQL Server within RDS. In that case AWS takes care of backups for you, and I think if you take a snapshot in RDS it will take care of the details for you.