Suspect database

• sn.rana87

  Grasshopper

  Points: 11

  More actions

  June 17, 2008 at 11:35 pm

  #381202

  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'.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  June 18, 2008 at 12:02 am

  #830211

  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

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

• Paul Randal

  One Orange Chip

  Points: 29544

  More actions

  June 18, 2008 at 10:54 am

  #830637

  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

• Manoj-485464

  SSCrazy

  Points: 2717

  More actions

  June 24, 2008 at 10:11 am

  #833430

  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?

  Manoj

  MCP, MCTS (GDBA/EDA)

• Sasi-672091

  SSC Veteran

  Points: 298

  More actions

  June 25, 2008 at 1:54 am

  #833747

  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