Post reply

SQL Backup stuck in Restore Mode

  • February 28, 2014 at 12:39 am

    #304855

    Hi everyone

    I have a DB, MDF is about 170GB, log 200GB. When I do a restore of it, the backup takes about 20 minutes to get to 100% but then it just stays there in Restoring Mode.

    I have specified the WITH RECOVERY option.

    What is happening that it doesn't commit the backup for some reason?

    Thank you.

  • February 28, 2014 at 4:04 am

    #1692989

    If it's at the last step its dealing with all the logs, rolling forward or rolling back transactions. That can take a while.

    Have you looked at sys.dm_exec_requests to see if there is a blocking issue?

    "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

  • February 28, 2014 at 4:18 am

    #1692991

    Thanks, found a another two week old copy on a dev server, going to detach/attach the MDF files.

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

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