hmcnasty
asked on
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.md f'. [SQLSTATE 42000] (Error 3271) Backup or restore operation terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
ASKER
Thanks, we were able to find the corrupt table and fix it.
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.