Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Checking restore progress of scheduled job?

Posted on 2006-04-21
5
Medium Priority
?
203 Views
Last Modified: 2010-05-18
I have a job that is running a restore of a database in RECOVERY mode.  It is a LARGE database from a network device to local storage (250gb).  I want to view the status of the restore, but am unsure how to accomplish this.  Any help?

Thanks!
0
Comment
Question by:blood
  • 3
  • 2
5 Comments
 
LVL 27

Accepted Solution

by:
ptjcb earned 1000 total points
ID: 16509906
If you are running it from a script you could add the WITH STATS option. Then you would check the messages tab to see what percentage has finished.
0
 
LVL 2

Author Comment

by:blood
ID: 16510048
Yeah, but my job is 10 hours in to its restore and it has to be done by tonight :)  Stopping and restarting from a script in QA would kill me :)

thanks
0
 
LVL 27

Expert Comment

by:ptjcb
ID: 16510645
Ok - I assume that you are using 2000 (it will be different in 2005) - there are two tables that have restore information in MSDB. I did not see any column on percentage completed. Still checking. sp_help_job will tell you everything about the jobs, but it will be useless for you since you know what step it is on.
0
 
LVL 2

Author Comment

by:blood
ID: 16578698
Thanks.   Turned out to be a network latency problem with my file copy, but when I did fix it the stats option worked well :)

-jay
0
 
LVL 27

Expert Comment

by:ptjcb
ID: 16579559
Cool.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

572 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