-
- Enthusiast
- Posts: 30
- Liked: never
- Joined: Jan 14, 2018 3:18 am
- Full Name: Bert Adams
- Contact:
Backups with SQL Server
I was going through the user guide where it talks about creating a backup. I have always selected the VMs I wanted to backup, and it backed them up fine. And, I could restore them. But, now when I look closer, it shows "objects" I should include. Like SQL. Do I need to choose SQL Servers, etc. in order to make sure they are backed up? Is that part of Application Aware?
-
- Product Manager
- Posts: 5797
- Liked: 1215 times
- Joined: Jul 15, 2013 11:09 am
- Full Name: Niels Engelen
- Contact:
Re: Backups with SQL Server
If you enable Application Aware processing for SQL you will be able to do database recovery & point in time restores. You can find more information on our Veeam Explorer for SQL via our userguide.
Personal blog: https://foonet.be
GitHub: https://github.com/nielsengelen
GitHub: https://github.com/nielsengelen
-
- Product Manager
- Posts: 8191
- Liked: 1322 times
- Joined: Feb 08, 2013 3:08 pm
- Full Name: Mike Resseler
- Location: Belgium
- Contact:
Re: Backups with SQL Server
Hi Bert,
Correct me if I misunderstood your question. What we mean by objects can be: Everything, Folder, Host Group, SCVMM, Cluster, Host or Virtual machine within Hyper-V. What you have been doing is perfect. No need to do something specific. What Niels above says is if you want to take advantage of application aware processing giving you item-level recovery for many workloads (SQL/ AD/ Exchange/ ...). Before you can do that, you need to tell the job that holds those servers that it needs to do application aware processing which is in this step: https://helpcenter.veeam.com/docs/backu ... tml?ver=95
But as said, selecting VMs is a perfect method, we just use objects as a name and not VMs because you can choose differently. And when that VM is a sql server, it will be protected no matter what, and with AAIP you will even have additional item-level restore options
Did I understand it correctly?
Thanks
Mike
Correct me if I misunderstood your question. What we mean by objects can be: Everything, Folder, Host Group, SCVMM, Cluster, Host or Virtual machine within Hyper-V. What you have been doing is perfect. No need to do something specific. What Niels above says is if you want to take advantage of application aware processing giving you item-level recovery for many workloads (SQL/ AD/ Exchange/ ...). Before you can do that, you need to tell the job that holds those servers that it needs to do application aware processing which is in this step: https://helpcenter.veeam.com/docs/backu ... tml?ver=95
But as said, selecting VMs is a perfect method, we just use objects as a name and not VMs because you can choose differently. And when that VM is a sql server, it will be protected no matter what, and with AAIP you will even have additional item-level restore options
Did I understand it correctly?
Thanks
Mike
Who is online
Users browsing this forum: No registered users and 23 guests