SQL errors on backup

Posted on 2009-04-27
Last Modified: 2013-11-30
Can anyone help me out with these erros on my sql back up? 10 percent backed up. [SQLSTATE 01000] (Message 3211)  20 percent backed up. [SQLSTATE 01000] (Message 3211)  30 percent backed up. [SQLSTATE 01000] (Message 3211)  40 percent backed up. [SQLSTATE 01000] (Message 3211)  50 percent backed up. [SQLSTATE 01000] (Message 3211)  60 percent backed up. [SQLSTATE 01000] (Message 3211)  Nonrecoverable I/O error occurred on file 'D:\MSSQL7\DATA\Technic.mdf'. [SQLSTATE 42000] (Error 3271)  Backup or restore operation terminating abnormally. [SQLSTATE 42000] (Error 3013).  The step failed.
Question by:hmcnasty
    LVL 13

    Accepted Solution

    run a DBCC Checkdb('your database')

    see if you get any errors reported.

    also are they any errors noted on the Event Viewer.

    run a check disk on D drive.

    LVL 75

    Expert Comment

    by:Anthony Perkins
    >>Nonrecoverable I/O error occurred on file 'D:\MSSQL7\DATA\Technic.mdf'.<<
    That is not good.  In addition to the previous comment, I would start searching for all your backup sets.  Do not overwrite them you may need them.

    Author Comment

    Here is the error message I got when I ran DBCC Checkdb('your database')
        Server: Msg 823, Level 24, State 1, Line 3
        I/O error 121(The semaphore timeout period has expired.) detected during read of BUF pointer = 0x1498a9c0, page ptr = 0x2bcfe000, pageid = (0x1:0x362e48), dbid = 5, status = 0x801,
        file = D:\MSSQL7\DATA\Technic.mdf.
        Connection Broken

    Author Comment

    Thanks, we were able to find the corrupt table and fix it.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Introduced in Microsoft SQL Server 2005, the Copy Database Wizard ( is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
    When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now