I have heard of an approach to do this, never tested it.. But here goes.

Create a new DB on that server of the exact same name, size.. MDF/LDF.
Stop the server, replace the MDF/LDF just created with your "corrupt"
ones.
Start the server.

BCP out all the data you can table by table... (you will find the
corrupt data here I presume...)

Has anyone here heard of this or tried it??

Dano.



-----Original Message-----
From: Mark Peck
[mailto:mssqldba-ezmlmshield-x41215259.[Email address protected]
Sent: Friday, October 29, 2004 11:45 AM
To: LazyDBA Discussion
Subject: Attaching Corrupt MDF File [faked-from]
Importance: Low

Hi,

Pleas help! I have a corrupted .MDF file that I need to attach (as far
as I
can see) in order to run a DBCC process to fix it. The error in the
.MDF
when I try to use either EP or sp_attach_db is:

I/O Error (torn page) detected during read at offset ..... in file
......
connection broken

What is possible with this? Is it fixable? Urgent help needed.


Many thanks,
Mark


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]


MS Sql Server LazyDBA home page