How to check % of recovering of database.

• PritamSalvi

  Valued Member

  Points: 72

  More actions

  May 13, 2011 at 9:01 pm

  #389527

  Hi proff,

  Unforyunately one of our production server gonna in recovery mode after disk rebuild.

  I know it can be checked through error log how much % is completed or recovered (rollbacked/forwarded)

  But i want such queryso that i can find out how much % of the database is recovered yet.

  Please reply urgent.

  We have to recover within 1hour.

• maheshkumar_pandeti

  SSC Journeyman

  Points: 84

  More actions

  May 14, 2011 at 6:45 am

  #1324620

  select percent_complete from sys.dm_exec_requests where command like '%restore%'