veeam for sql backup

Can I ask for a view on the following. We have found our admin isn’t backing up a certain MSSQL (express) database, she said they use VEEAM to backup the whole server, and if required would use that to rollback the Server/Database to another point in time. Is this sufficient for an MSSQL DB backup? Does VEEAM even include the DB in the backup? As I thought you had to backup a DB separately as it would be locked? Is this a poor approach ( I am looking at this from a risk angle I don’t admin the System myself). What are the cons/pitfalls in this approach?
LVL 3
pma111Asked:
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.

MaximVeeamCommented:
Is this sufficient for an MSSQL DB backup?
Hi pma111, thank you for this question! Make sure the "Application Aware Image Processing" option is chosen. AAIP is an ad-hoc mechanism, which allows Veeam Backup & Replication to create transactionally consistent backup of a VM running VSS-aware applications (such as Active Directory, Microsoft SQL, Microsoft Exchange, Sharepoint) without powering them off. Furthermore, it ensures successful VM recovery, as well as proper recovery of all applications installed on the VM without any data loss and also it notifies applications about them being backed up.  

Does VEEAM even include the DB in the backup?
Veeam is an image-level backup for VMs (like bare-metal backup for physical machines). It backups / replicates the whole VM, including OS and applications installed inside this VM.

As I thought you had to backup a DB separately as it would be locked?
Use the "Application Aware Image Processing" option to make sure that your database will be in consistent state after the backup job was performed, cause all the transactions that were in progress will be finished as well as new ones won't be started, so it will be safe to do a snapshot for this VM and this will keep your backups with highly transactional applications in consistent state.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pma111Author Commented:
Thanks. Where would you check if AAIP is enabled, and has been enabled on the server backup for the past backup jobs of that server? I.e. if I ask an admin they would likely just switch it on now and say "yes we do that", whereas the reality may be it hasnt be enabled up until this point.
0
MaximVeeamCommented:
Where would you check if AAIP is enabled, and has been enabled on the server backup for the past backup jobs of that server?
This article from Veeam Help Center might be helpful - http://helpcenter.veeam.com/backup/70/vsphere/index.html?backup_job_vss_vm.html

Take a look at the Guest Processing tab when you create a new Backup Job or edit an already existing one.
0
pma111Author Commented:
I suppose there is no way to determine when that setting was enabled?
0
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
Microsoft SQL Server

From novice to tech pro — start learning today.