Hi everyone, I'm new here but appreciate if anyone can help me out on this.
Found this error since 19th Oct. Previously the backup maintenance plans were perfectly fine.
Executing the query "BACKUP DATABASE [TeamMate_Production] TO DISK = N..." failed with the following error: "Read on "E:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.SQLEXPRESS\\MSSQL\\DATA\\TeamMate_Production.mdf" failed: 1(Incorrect function.)
BACKUP DATABASE is terminating abnormally.
10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.
80 percent processed.
90 percent processed.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Also, I execute DBCC ChECKDB and found 4 consistency errors. Below are the errors for your reference:
Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:367495) with latch type SH. 1(Incorrect function.) failed.
Msg 8929, Level 16, State 1, Line 1
Object ID 1426104121, index ID 1, partition ID 72057594054901760, alloc unit ID 72057594057457664 (type In-row data): Errors found in off-row data with ID 2520252416 owned by data record identified by RID = (1:348730:10)
Msg 2533, Level 16, State 1, Line 1
Table error: page (1:367495) allocated to object ID 1426104121, index ID 1, partition ID 72057594054901760, alloc unit ID 72057594057588736 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 1426104121, index ID 1, partition ID 72057594054901760, alloc unit ID 72057594057588736 (type LOB data). The off-row data node at page (1:367495), slot 0, text ID 2520252416 is referenced by page (1:367418), slot 0, but was not seen in the scan.