How to properly do an integrity check in MS SQL 2005 Server?

Question

SQL Server

Hello.
MS SQL Server 2005 SP4.
Created a maintenance plan with a simple DB check. It is not known if an integrity check was ever done before me. The plan fails at about the fifth minute with the following error.

Error:(-1073548784) Query "DBCC CHECKDB WITH NO_INFOMSGS
" failed with the following error: "Page (1:48993), object ID 1308583750, index ID 1, partition ID 72057594039369728, allocation unit ID 72057594043760640 (LOB data type), was modified but not marked as modified in the differential backup bitmap
CHECKDB encountered 0 allocation errors and 1 consistency errors in table 'LOG' (object ID 1308583750)
CHECKDB encountered 0 allocation errors and 1 consistency errors in database 'DB20170603'.
repair_allow_data_loss is the minimum fix level for errors found by DBCC CHECKDB (DB20170603). Possible causes of failure include problems with this query, the 'ResultSet' property was set incorrectly, parameters were set incorrectly, or the connection was not established correctly.

I think I can't do it myself. I assume that you need to write a request with repair.
Thanks in advance !

Answer 1

We make a backup of the database, raise its copy and mock the copy