Can not drop a procedure. I/O error 38

• H2D

  Newbie

  Points: 3

  More actions

  February 17, 2007 at 1:23 am

  #172261

  When I want drop a procedure I receive this error:

   

  Server: Msg 823, Level 24, State 2, Line 1

  I/O error 38(error not found) detected during read at offset 0x00004000860000 in file 'E:\SISMDF\ZZZ_FRB.mdf'.

   

  Connection Broken

• MohammedU

  SSCoach

  Points: 19644

  More actions

  February 18, 2007 at 12:28 am

  #690373

  Looks like you have disk issue...

  Run the check db first without delay...

  Most of the cases related torn page, end up with database restore with previous good backup.

  MohammedU
  Microsoft SQL Server MVP