DR test issue

• MVDBA (Mike Vessey)

  SSC-Insane

  Points: 21797

  More actions

  December 2, 2019 at 10:20 am

  #3703366

  Hi

  I have a DR test server that failed this morning due to lack of disk space. I've fixed most of it, but I have one problem database.

  it's in "recovery" mode,  and i'm getting a lot of messages like

  Message

  There have been 36608 misaligned log IOs which required falling back to synchronous IO.  The current IO is on file D:\sqldata\Common_Restored2_1.ldf.

  if I try and drop the database, i'm told that it is currently in use

  I remember several years ago taking a database out of suspect mode using a command that was vaguely like sp_changedbstatus

  Anyone got any suggestions?

  MVDBA

• muthukkumaran Kaliyamoorthy

  SSCoach

  Points: 19026

  More actions

  December 2, 2019 at 10:42 am

  #3703372

  Better to wait until in recovery finish.

  Muthukkumaran Kaliyamoorthy
  https://www.sqlserverblogforum.com/