Restore Database Progress Bar

Posted on 2007-10-17
Last Modified: 2008-01-09
I started a restore of a 150 GB database about 12 hours ago via Enterprise Manager.  The progress bar has moved all the way to the end, but the task has not completed.

I just want to confirm this is normal behavior?

Thanks - Matt
Question by:hennessym
    LVL 8

    Expert Comment

    I am sure it will ok. It does take sometime sometimes have you checked in the task manager if its still running and give  highest priority to the task?
    LVL 21

    Accepted Solution

    Assuming SQL 2000, when did it get to the end?

    Does the Current Activity show that it is still working?

    Select * from master..sysprocesses where kpid >0
    --this should show a restore database command in process.  If the physical IO number is changing, its still working
    LVL 21

    Expert Comment

    the task manager will only show the sqlservr.exe, not the restore command
    LVL 1

    Author Comment

    Thanks, Kevin.

    The physical IO appears stuck at 1744660.

    The cpu is changing, from 242548 to 242564 to 242580.  In the SQL Server event log, I see "SQL Server has encountered 1 occurrence(s) of IO requests taking longer than 15 seconds to complete on file."  I'm assuming the best course of action is to abort the restore and try again?

    Thanks again - Matt
    LVL 21

    Expert Comment

    when you see "SQL Server has encountered 1 occurrence(s) of IO requests taking longer than 15 seconds to complete on file", you may have some serious disk issues.  Check that out first.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    In this article—a derivative of my blog post (—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now