Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 sql-server2000, torn-page 823 error in attaching a databas

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-02-27 : 12:08:31
masood writes "dear sir
hello:
would you please solve my problem as below:
i have a sqlserver2000 database file , in attaching , a error message appears as
Error 823: I/O error (torn page) detected during read at offset 0x00000000b57c000 in the file c:\mydata...

what can i doing ??? how repaire the database file . i copied the file to other computer in the network and without any error message it was copied , therefore the file has no disk problem of bad sector

the file itself was coruppted . please explain the way i can give you the 600MB datafile for repairing. how much i pay for and how?. i live in iran . please give me your representative address in iran to submit the damaged file to them, or if i must
directly send you in u.s.a by post. please help me to repire it . i dont have any backup. "

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-02-27 : 13:35:50
read this KB article http://support.microsoft.com/default.aspx?scid=kb;EN-US;828339

THis is definitely a question for Paul Randal and probably should be in the "Data Corruption Issues" forum here.



-ec
Go to Top of Page

activecrypt
Posting Yak Master

165 Posts

Posted - 2006-02-28 : 00:34:39
http://www.sqlservercentral.com/accessdenied.aspx?SourceURL=/forums/shwmessage.aspx?forumid=24&messageid=190516

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=3093

http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/35d8236e6b94d39/6fb3c570ac1451d6%236fb3c570ac1451d6?sa=X&oi=groupsr&start=0&num=2

http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/2bc76551eb05266b/3e08f2f089d8a02e%233e08f2f089d8a02e?sa=X&oi=groupsr&start=1&num=2

http://sqlpass.org/Forums/messageview.cfm?catid=372&threadid=12252

Andy Davis
Sql Shield Team
--------------------------------------------
SQL Server Encryption Software
http://www.sql-shield.com
Go to Top of Page
   

- Advertisement -