Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
|
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 20th, 2007, 04:03 AM
Registered User
 
Join Date: Mar 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Anuja Jadhav
Default Error 823 : I/O error 23 CRC

I get the following error when try to take backup or restore from same server.If I try to restore the Bckp from other server to existing DB it pops the below error.

Error 823: I/O error 23 (Data error(cyclic redundancy check).)detected during read at offset in 0xe3a in file 'D:\Mircosoft Sql Server\MSSQL\data\msdbdata.mdf'.

It doesn't allow me to work on those database.Though the application connecting them is working fine and enters the data properly.



Anuja Jadhav
Senior Database Administrator
 
Old March 20th, 2007, 08:50 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Looks like the MDF is corrupted. I could get some pointer from Repairing corrupt MDF files. But not sure if this helps you. Because the MSDB is corrupt for you. If you have a replica of the msdb on another server you can try overwriting it and changing the reference of msdb to the remote server if any.

Cheers.

_________________________
- Vijay G
Strive for Perfection
 
Old March 20th, 2007, 09:00 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Got some more info on it...

Books online: Severity Level 24

Message Text
I/O error detected during %S_MSG for %S_BUF

Explanation
SQL Server encountered an I/O error on a read or write request made to a device. This error usually indicates disk problems. The parameters in the error message refer to internal structures and don't often help determine which device is involved. However, additional kernel messages in the error log, recorded before error 823, should indicate which device is involved.

Action
Check the accessibility and condition of the device in question. After you have identified and corrected the problem, run dbcc checkdb and dbcc checkalloc to ensure that no other damage was caused by the bad device. For information about using DBCC, see the Microsoft SQL Server Transact-SQL Reference.
In addition, run hardware diagnostics and correct any problems.

Cheers

_________________________
- Vijay G
Strive for Perfection





Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert Query Error & Run-Time Error 3022 DavidWE Access 1 July 31st, 2008 11:17 AM
Ch 4: Parse error: syntax error, unexpected T_SL hanizar77 BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0 0 June 23rd, 2008 09:17 PM
CRC Check richie86 C# 2005 0 August 18th, 2006 09:53 AM
Page 23, Point 2, Error 1046 carlitio BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 9 July 9th, 2004 01:52 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.