Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dewacorp.alliances
452 Posts |
 Posted - 2006-11-11 : 20:31:44
|
| Hi allI made an automatic testing restore through a stored procedure. Inside this sproc, I put the STATS = 10 for restore and scheduled this stored proc throgh a job. But since this inside the Job, I could not see the progress of the restoration while the job is running.How do I see this? Is there anyway that you can see perhaps in the system table somewhere while state is LOADING?Thanks |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-11-12 : 02:30:23
|
| I reckon you either need to run it manually, and you'll then see the progress every 10%, or put it in a job and forget about it! (The job can tell you if it succeeds/fails, of course)Kristen |
 |
|
|
|
|
|
SQL2K: How to Know the Progress of Restoration