recover - how do I tell if it is really happening?

Hello all -
this is the first restore I've attempted on a real production database.
I used EM to execute the restore, and it correctly found my last full backup
, diffs and tran log files.
(I run full recovery mode).
I can see in the log where things are happening, and the status of the datab
ase is being displayed as loading.
But after 3.5 hours you just start to wonder if anything is really happening
.. Any advice?How long did the backup take? Restore is usually longer. Sometimes 2 or 3x
longer.
Run sp_who2 and see if the CPU and IO counters change for the restore task.
Watch the blinkey lights on the case.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"randyvol" <randy.volters@.whaleyfoodservice.com> wrote in message
news:81408CF6-B061-4514-87C7-D582E3DF9058@.microsoft.com...
> Hello all -
> this is the first restore I've attempted on a real production database.
> I used EM to execute the restore, and it correctly found my last full
backup, diffs and tran log files.
> (I run full recovery mode).
> I can see in the log where things are happening, and the status of the
database is being displayed as loading.
> But after 3.5 hours you just start to wonder if anything is really
happening... Any advice?|||Hi Randy.
For future reference, you might find RESTORE's STATS option useful. I use
this pretty much on autopilot - RESTORE.. WITH STATS=10 - it writes a
progress response to the console / query analyser every 10 percent. That way
you get an idea of how far the restore's progressed.
HTH
Regards,
Greg Linwood
SQL Server MVP
"randyvol" <randy.volters@.whaleyfoodservice.com> wrote in message
news:81408CF6-B061-4514-87C7-D582E3DF9058@.microsoft.com...
> Hello all -
> this is the first restore I've attempted on a real production database.
> I used EM to execute the restore, and it correctly found my last full
backup, diffs and tran log files.
> (I run full recovery mode).
> I can see in the log where things are happening, and the status of the
database is being displayed as loading.
> But after 3.5 hours you just start to wonder if anything is really
happening... Any advice?|||Hi Randy,
I am reviewing your post and we have not heard from you for some time. I
want to know if your restore is fine now. Our community members have
provide some informaitons by using WITH STATS in recovery and it might be
longer than backup. If you still have questions, please feel free to let me
know and we are glad to help.
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.