June 17, 2008 at 11:35 pm
When i am trying to attach suspected database (mdf) it shows eoorr=----
I/O error (torn page) detected during read at offset 0x00000000012000 in file 'D:\SURAJ\DOLPHIN@NAHAR_1036.MDF'.
June 18, 2008 at 12:02 am
Do you have a backup?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 18, 2008 at 10:54 am
And how did it get detached?
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
June 24, 2008 at 10:11 am
Rana, This we already discussed in some other thread. Could you please try to add new log file on the server, if not go with the latest backup copy of the DB and you are all set.
I would like to see what error you got in errolog or in event viewer?
MCP, MCTS (GDBA/EDA)
June 25, 2008 at 1:54 am
If you are able to deattach the DB successfully then you could try out this one.
DBCC TRACEON(1807)
GO
SP_ATTACH" ......... "
GO
DBCC TRACEOFF(1807).
Try this out and let us know whether you are able to attach the db successfully.
Regards,
Sasi
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply