October 22, 2014 at 7:37 pm
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.
October 23, 2014 at 10:14 am
Since DBCC CHECKDB is returning errors, my best suggestion is to restore from the last good backup. Unfortunately that appears to be a few days ago, so you will likely lose some data. You should also check your storage subsystem for problems because it will likely happen again.
Check out this thread on SQLTeam where Gail Shaw, much better than I am with corruption issues, offers some advice, http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=164284
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply