Can veeam perform any DBCC CHECKDB

[jessey316]

Hi,

currently, we are backing up our databases uses native SQL methods and part of that process is to run a dbcc check on the databases so we are not backup up bad data.

Is there any way to have veeam do this? or if anyone has any experience with a similar solution. I understand that scripts can be included in the backup job so might be possbile to create a script to check if the DBCC passed

Thanks in advance for any suggestions

[Gostev]

Hi, Jessey.

This activity falls into backup validation, and most users do these kind of checks as a part of SureBackup jobs.

Doing this during the backup itself is not a good idea, because it increases the backup windows significantly, which in particular means backup snapshots growing very large, causing commit issues and production environment impact.

Thanks!

[jessey316]

Thanks Gostev,

I had a look at this option. This is an after process once the backup is done, correct? Would this work only volume level backups? if we are not backing up the entire VM.

[Gostev]

Yes, SureBackup is separate from backup and is a job that can be scheduled to run at any time.

However, SureBackup requires a full VM backup, since it physically powers them on in the isolated Data Lab.

Having said that, you can still do the same with volume level backups too, but using a different technology called Data Integration API (a v10 feature). This allows you to instantly mount disks from backup directly into the file system of the specified server. Then on this server, you can run any command or tool against any files on the attached disks. So, just a tiny wee bit more scripting to do, but nothing too complex: despite the fancy name, Data Integration API means literally a single PowerShell cmdlet that does all the mount magic. Here's a good blog post to give you an idea.