Re: Restore runs longer in batch mode

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 08/08/04 

Date: Sun, 8 Aug 2004 21:20:10 +0530

Hi,

>From Query Analyzer, Could you execute the syetm procedure sp_who2 and see
the status of the backup process.
Repeatedly execute sp2 and check if the CPU time and DISK IO are increasing
for backup process. If the value is increasing
then the process is active.

Thanks
Hari
MCDBA

"cbriscoejr" <cbriscoejr@discussions.microsoft.com> wrote in message
news:E13E54D2-C77F-4A44-BDAB-630166185032@microsoft.com...
> I have created a Job that uses "cmcexec" to execute a SQL script. This
Job
> brings SQL to single_user mode then restores from a directory that is
local
> to the server.
>
> 1) When I run this restore in the GUI it takes 15 minutes but is still
> executing
> (1 + hours).
>
> 2) How can I tell that it is actually running and not hung up?

Relevant Pages

  • Re: recursive copy in VMS
    ... space on a tape (and slow the backup process). ... lose his Mac's disk and his VMS system's disk at the same time, ... like I'm satisfied that I won't lose my VMS systems' disks and their ... tape backups at the same time. ...
    (comp.os.vms)
  • RE: ?s about using XPs Automated Recovery Disk
    ... Unfortunately, when I booted from the disk as a test, I found that I ... > whole backup process again. ... > When I did my backup, I backed up my entire first drive and system settings ... > would I have to reinstall XP first and then restore? ...
    (microsoft.public.windowsxp.general)