Database backup maintenance failed

  • liana.dina

    SSC Journeyman

    Points: 95

    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.

  • Jack Corbett

    SSC Guru

    Points: 184360

    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 Dont let the good be the enemy of the best. -- Paul FlemingAt best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at workCheck 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 helpNeed an Answer? Actually, No ... You Need a QuestionHow to Post Performance Problems[/url]Crosstabs and Pivots or How to turn rows into columns Part 1[/url][url url=http://www.sqlservercent

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply