This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 12%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
I see our database integrity job has failed with no clear error message. I also checked the commandLog table, but couldn’t get any error there either.
Usually integrity checks fail when there is activity on the database and it is unable to create the snapshot it uses. Make sure there is no activity on the database, kill connections and run the job manually to test. It should finish fine. Try it during maintenance window hours.
Thanks Alberto, will wait for our maintenance window and give it a shot.
Probably is unable to create a snapshot of the database it needs. You may see errors on the SQL Server error log like "The database could not be exclusively locked to perform the operation."
You are welcome!
Checked Error Logs and noticed it doesn’t have any error message regarding the database integrity failure
Run the job with no database activity, no backup jobs or other agent jobs running at the same time.
Got it. Thank you!