Post reply

restore operation was interrupted

  • April 9, 2014 at 12:53 am

    #284295

    restored full backup with norecovery , getting below error while restore the diff backup with recovery .

    Error:

    Unexpected termination on thread: 0, Return code: x80770004

    RESTORE

    DATABASE is terminating abnormally.

    Problems were identified while planning for the RESTORE statement.

    Previous messages provide details.

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

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

    any help to resolve this ?

  • April 9, 2014 at 5:54 am

    #1704460

    Sounds like you need to do what it suggests, start the process over again. Be sure that the FULL BACKUP you're restoring is linked to the DIFFERENTIAL you're restoring.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply