Regarding backup integrity check of SQL 2019

Question

当我使用Veritas Backup Exec做sql备份的恢复时，若选择进行一致性校验时，会报错提示校验失败，但是恢复出来的数据库也能正常使用。
先前咨询了Veritas原厂，反馈的说法是这个校验是由sql 软件本身来执行的，Veritas只是做一个任务推送。
现在想咨询下，如何排查一致性校验的错误，并如何解决这个问题？优先想解决物理的一致性检查错误。

When performing restore with backups made with "Veritas Backup Exec" and selected "integrity checks", it will show the check is failed, however the restored database is still functional.

Have contacted the vendor of backup software, their reply said that the test is performed with the SQL Server itself. All Veritas does is to queue a task for it to do.

Now I wish to ask, how to troubleshoot those integrity check errors, and how to solve this problem. I'd like to first fix integrity errors that occurred on physical level.

Answer 1

Hi,

Welcome to Microsoft Q&A!

>it will show the check is failed, however the restored database is still functional.

What is the detailed error message prompted? Maybe it is because the operation cannot be executed and the error is reported instead of the backup itself.

>Have contacted the vendor of backup software, their reply said that the test is performed with the SQL Server itself. All Veritas does is to queue a task for it to do.

Do they explain what operations SQL Server will perform? For example, RESTORE VERIFYONLY FROM DISK ='D:\AdventureWorks.bak'.

You can also manually execute DBCC CHECKDB to check the logical and physical integrity of all the objects in the specified database as suggested by Erland.

Answer 2

Good to hear that DBCC CHECKDB does not return any error.

I think we need to refer you back to Veritas. They may claim that the check is performed by SQL Server, but at least they should know which commands they are using. (And, well, you could use Profiler to spy on Veritas yourself, but as I said, Veritas should know what they are doing.)