Database Attach-Detach

• Harcharan Jassal

  SSC Veteran

  Points: 296

  More actions

  April 20, 2005 at 7:33 am

  #109745

  Hi Experts!!!

  After some patches were applied by Network Adminstrator, one of my database got into suspect mode. I tried to detach and re-attach the database, but I get the following error:

  " I/O error (bad page ID) detected during read at offset 0x00000000030000 in file 'E:\NLGDATA\XYZ_Data.MDF'.

  Connection Broken "

  Is there a way to get this Database up again? Unfortunately I donot have a backup as this DB was used for some test purpose and I never realised it contains few tables which are used used as a connection string for a OLAP Database in analysis server

  Please mail me any answers at hjjassal@yahoo.com

  Regards,

  Harry

• Vinod Kumar

  SSC-Addicted

  Points: 475

  More actions

  April 21, 2005 at 12:28 am

  #553975

  Is this on SQL Server 2005 or SQL Server 2000?

  If on SQL Server 2000 then this is the wrong forum. But still you can see the BOL for a section on resolving suspect dabatase.

  HTH,

  Vinod Kumar

  http://www.ExtremeExperts.com