I have a job on my live environment DB and the job has failed again this morning reporting SQL Server Error 824 (Soft I/O error, where the OS could read the page but SQL has treated it as corrupt):
SQL Server detected a logical consistency-based I/O error: incorrect checksum it occurred during a read of page (1:9545681) in database ID 5 at offset 0x0000123615a000 in file 'D:XXX\XX.mdf'
I have had a look and ran
DBCC CHECKDB with
all_errormsgs and saw the error didn't mention
CHECKSUM failure, however it reports the repair level needed to repair this error is
Is there anything else that can be done other than running the repair SQL Server has recommended since I don't want any data loss?
I have a good backup policy in place, however the backup that was last working when the job ran without any problems has now been deleted due to space issues. Is there anything else I can do now?