DB snapshot has failed an i/o operation

• MSQLDBA

  SSCrazy

  Points: 2783

  More actions

  March 31, 2009 at 6:37 am

  #207772

  Hello dear frndz,

  I m monitoring my SQL Server in error log i got this error message,

  ‘Database snapshot 'Database_name' has failed an IO operation and is marked suspect. It must be dropped and recreated.’

  Sourcespid69

  Message

  Error: 3420, Severity: 21, State: 1.

  I am not able to understand this issue, i search this db in object explorer its not showing, i run the 'sys.database' its showing status online, while i run the 'sp_helpdb dbname' it showing other db name. Can anybody please help me out.

  Thanks in advance.

  M.I.

  ________________________________________
  M.I.
  [font="Times New Roman"]

  Learning is a path with no destination...

  [/font]

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  March 31, 2009 at 9:45 am

  #969228

  Please don't cross post. It just wastes peoples time and fragments replies.

  No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic686966-146-1.aspx

  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