• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 435
  • Last Modified:

SQL errors on backup

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.
0
hmcnasty
Asked:
hmcnasty
  • 2
1 Solution
 
WizillingCommented:
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.

0
 
Anthony PerkinsCommented:
>>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.
0
 
hmcnastyAuthor Commented:
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
0
 
hmcnastyAuthor Commented:
Thanks, we were able to find the corrupt table and fix it.
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now