Home Forums SQL Server 2005 Backups The database cannot be recovered because the log was not restored. RE: The database cannot be recovered because the log was not restored.

  • August 9, 2012 at 1:43 pm

    #1524071

    dineshvishe (8/8/2012)

    How to cancel restory state of databaase..

    It is stuck in this state since you canceled the restore. Once a restore has been started you cannot undo what the restore has begun... there is no rollback a restore process so it is left in a hung state.

    About all you can do is get another good backup and restore it from that.