Comprehensive data protection for all workloads
Post Reply
ccrichard
Enthusiast
Posts: 26
Liked: never
Joined: Sep 04, 2010 11:06 pm
Full Name: Richard Yamauchi
Contact:

Can Veeam Optimize and check SQL Integrity?

Post by ccrichard » Jun 16, 2011 5:50 pm

Can Veeam Optimize and check SQL Integrity during SQL Server Backups?
If not, I guess I just need to do this in a pre-script.

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

Re: Can Veeam Optimize and check SQL Integrity?

Post by Vitaliy S. » Jun 16, 2011 8:35 pm

Hello Richard,

Could you please clarify what optimization are you referring to? We've got application-aware image processing and SureBackup capabilities to verify VMs' backups, have you been able to look through our F.A.Q. topic?

Thanks.

ccrichard
Enthusiast
Posts: 26
Liked: never
Joined: Sep 04, 2010 11:06 pm
Full Name: Richard Yamauchi
Contact:

Re: Can Veeam Optimize and check SQL Integrity?

Post by ccrichard » Jun 17, 2011 3:45 pm

By optimize database and Database integrity check I mean for the SQL Server being backed up.
SQL Server Management studio can be scheduled to perform database integrity checks and database optimization as well as backing up the databases.

I've read that it's a good idea /best practice to perform an integrity check before the backup and then a optimization after.

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

Re: Can Veeam Optimize and check SQL Integrity?

Post by Vitaliy S. » Jun 19, 2011 6:49 pm

Ok, got it.

You can use VMware Tools quiescence with pre-freeze scripts to do that, however I would definitely recommend using "Application-aware image processing" option to backup all Microsoft-based VMs, especially SQL Servers.

As regards integration checks and optimization then you can schedule these within the guest being backed up.

For more info on "Application-aware image processing" please take a look at our F.A.Q.

Thanks.

Post Reply

Who is online

Users browsing this forum: Google [Bot] and 34 guests