any further backup nesesary in AWS?

I created an EC2 instance.  I created a lifecycle manager policy to create up to 3 snapshots of the instance Volumes, and create a new one every 24 hours.  

My question is, Do I have to do any more in terms of Backing up the VM?
tike55Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David FavorLinux/LXD/WordPress/Hosting SavantCommented:
Keep in mind, taking snapshots won't produce a useful backup if any databases are involved.

When databases are involved, part of data lives in memory buffers + part of data lives on disk.

Many people find out the hard way, the only way to backup a database is one of...

1) Stop database + create some disk level snapshot or /var/lib/mysql (or where ever your raw files live)... or...

2) Use a real database backup tool, like mysqldump or whatever tool your database system provides.

This same consideration applies to any type of system where data lives on disk + in memory simultaneously.

If you're new to backing up complex systems... and having a backup that will actually restore to a running system again... best to talk with someone who works with complex system backup/restore scenarios every day.
tike55Author Commented:
The VMs that have snapshots contain BAK files of the databases.  
Is this adequate?
David FavorLinux/LXD/WordPress/Hosting SavantCommented:
No snapshot (with database server running) will produce a working database.

The database will always be corrupt.

When the database daemon starts, it will attempt to repair the damage.

1) If it's successful, you'll likely loose some data.

2) If it's unsuccessful, you'll likely loose all data in one or more tables.

Snapshots only produce restorable backups for static HTML sites. If any database or any other server is running where some state lives in memory, all these types of systems will be corrupt when snapshot is restored.
tike55Author Commented:
So just to be clear.  I have a VM with a simple SQL database.  It is on a lifecycle backup schedule in AWS to create a snapshot 1x per day.  The snapshots are the exact same size as the volume.  

Your saying that if I try to restore the VM from a snapshot backup, the database won't work?  If that is the case, will the BAK files on the snapshot work to populate a new database instance on a restored vm?  The databases are being backed up locally everyday as well.  Would the alternative be to back the databases up to another file share instead of the Snapshot?
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Virtualization

From novice to tech pro — start learning today.