Unable to bring the database online

• rambilla4

  SSCrazy Eights

  Points: 8715

  More actions

  November 3, 2009 at 10:25 am

  #213177

  Hi,

  I'm trying to bring the database online using

  Restore database Mydb

  with recovery.

  But I'm getting the below error. How to find which backup set was interrupted in-order to bring the database online.

  Msg 4319, Level 16, State 4, Line 1

  A previous restore operation was interrupted and did not complete processing on file 'Mydb_data'. Either restore the backup set that was interrupted or restart the restore sequence.

  Msg 3013, Level 16, State 1, Line 1

  RESTORE DATABASE is terminating abnormally.

  thanks

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  November 3, 2009 at 10:31 am

  #1074402

  Run the following:

  select * from msdb.dbo.restorehistory