当我使用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.
