Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Operating system error 23 in SQL Expand / Collapse
Author
Message
Posted Saturday, July 21, 2007 2:52 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 23, 2007 3:17 AM
Points: 2, Visits: 1
I scheduled daily backup on tape and it was working fine for two weeks.Last night the backup failed and threw the error BackupTapeFile::SkipFileMark: SetTapePosition failure on backup device '\\.\Tape0'. Operating system error 23(Data error (cyclic redundancy check).).

Please give me a solution
Post #383932
Posted Saturday, July 21, 2007 5:01 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 2:19 AM
Points: 542, Visits: 2,138

It means the tape or hardware has gone bad.

This is the probable sequence:
1. a BAK file is generated and a CRC code is generated
2. the BAK file is written to tape
3. the tape is re-read and a CRC code is generate

The CRC codes from step 1 and 3 don't match. Boom! Time to replace the tape or the tape drive or the computer attached to the tape drive.

Post #383936
Posted Saturday, July 21, 2007 5:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 23, 2007 3:17 AM
Points: 2, Visits: 1
But today I took the backup of our one database successfully in the tape.But it failed for the second database.I also tried changing the tapes.Our server is DELL Poweredge.
Post #383943
Posted Monday, July 23, 2007 3:05 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, November 17, 2014 7:05 AM
Points: 3,461, Visits: 353
Do a checkdb of the db to check if it has any tornpages. Tornpages might cause CRC issues with backups.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Post #384103
Posted Thursday, July 24, 2008 3:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 24, 2008 3:27 AM
Points: 1, Visits: 0
Hi there..

My problem is similar to the one mentioned above, but not the same .. ->

BackupTapeFile::SkipFileMark: SetTapePosition failure on backup device '\\.\Tape0'. Operating system error 21(error not found).

This backup job was runing fine too for a long time, and for 3-4 day its making me crazy.
The scheduled evening backup is faling, but if i run a "manual" backup it's working fine..

Any ideas?
Post #539960
Posted Sunday, May 5, 2013 8:14 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, May 5, 2013 7:56 AM
Points: 31, Visits: 2
http://answerforu.com/2013/05/05/could-not-open-a-connection-to-sql-server-sql-server-error-code-40/
Post #1449516
Posted Sunday, May 5, 2013 8:49 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:13 PM
Points: 40,428, Visits: 36,879
Please note: 6 year old thread


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1449517
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse