Discussions specific to the VMware vSphere hypervisor
Post Reply
tienlamnguyen
Influencer
Posts: 19
Liked: 4 times
Joined: Aug 22, 2014 2:31 pm
Full Name: Tien Lam Nguyen
Contact:

steps on setting up a SQL backup jobs

Post by tienlamnguyen » Mar 02, 2015 9:31 pm

Hi communities.

I am new to Veeam and there seems to have no roadmap to show newbies how to backup and recover SQL server with the SQL explorer.
I have read a ton of document but nothing is giving me a definitive answer.

Do I thought I ask the communities on what are the steps - best practices to configure an SQL server backup jobs. Here is what I want.

1-Backup my SQL database server.
2- I want everything to be backed up by Veeam and recover with the Veeam SQL explorer. There is no Native SQL server job

There are a lot of options.
Do i enable all of these options ? Enable application-aware processing;Enable guest file system indexing; enable VMware Tools quiescence

veremin
Product Manager
Posts: 16884
Liked: 1433 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: steps on setting up a SQL backup jobs

Post by veremin » Mar 03, 2015 10:00 am

You should:

- Enable application-aware image processing
- Go to Applications
- Select the necessary VM
- Click the SQL tab
- Define Backup log job settings

Thanks.

Vitaliy S.
Product Manager
Posts: 22976
Liked: 1555 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: steps on setting up a SQL backup jobs

Post by Vitaliy S. » Mar 03, 2015 10:52 am

...and to run a restore use this step-by-step guide.

tienlamnguyen
Influencer
Posts: 19
Liked: 4 times
Joined: Aug 22, 2014 2:31 pm
Full Name: Tien Lam Nguyen
Contact:

Re: steps on setting up a SQL backup jobs

Post by tienlamnguyen » Mar 03, 2015 8:56 pm

Thank for the input.

These are my options.

1-enable application- aware processing and guest file system indexing only
2-choose Truncate logs (prevents logs from growing forever)


I will make a test run and see

thanks

veremin
Product Manager
Posts: 16884
Liked: 1433 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: steps on setting up a SQL backup jobs

Post by veremin » Mar 04, 2015 10:18 am

1 - Indexing is only necessary if you're going to recover granular data via Enterprise Manager.
2 - You may want to backup SQL logs periodically, instead, to have ability to perform SQL point in time recovery.

Vitaliy S.
Product Manager
Posts: 22976
Liked: 1555 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: steps on setting up a SQL backup jobs

Post by Vitaliy S. » Mar 04, 2015 11:48 am

On a side note, logs truncation makes sense only for databases in Full recovery mode (didn't find what configuration you're using).

tienlamnguyen
Influencer
Posts: 19
Liked: 4 times
Joined: Aug 22, 2014 2:31 pm
Full Name: Tien Lam Nguyen
Contact:

Re: steps on setting up a SQL backup jobs

Post by tienlamnguyen » Mar 04, 2015 7:35 pm

2 - You may want to backup SQL logs periodically, instead, to have ability to perform SQL point in time recovery.
What do you mean by that ? when I choose the truncate jobs option - veeam is backing up my Transaction logs right ? so that i can have a point in time restore right ?
Do I have to choose Backups logs periodically to be able to have point in time restore ?
On a side note, logs truncation makes sense only for databases in Full recovery mode (didn't find what configuration you're using).
yes I am using Full recovery mode.

Vitaliy S.
Product Manager
Posts: 22976
Liked: 1555 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: steps on setting up a SQL backup jobs

Post by Vitaliy S. » Mar 04, 2015 7:55 pm

If you need point in time restores, you have to select backup logs periodically option, logs truncation will happen during normal backup job run in this case.

Post Reply

Who is online

Users browsing this forum: jtorres and 18 guests