Re: windows scheduler not working

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

What's the scheduler say under the "Last Run Time," "Next Run Time," and
"Last Result" columns?

"yawnmoth" <terra1024@xxxxxxxxx> wrote in message
news:1147369209.340598.66510@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I'm trying to use Windows Scheduler to make a backup of a database on
my computer every day at 6am and am having some difficulty.

If I run the backup script manually, it works. If I tell the scheduler
to run it a minute or two from now (eg. 11:30am, when it's 11:28am) it
works. However, at 6:00am (after I've been asleep for a few hours), it
doesn't.

As for how I know it isn't working... the script pretty much creates a
zip file of the database backup and copies it over the network to
another computer. When I do it by hand (or a minute or two from now,
as described above), the timestamp on the file on the other computer
reflects this. Further, every time the file is ran, a note to this
effect is appended to a file - log.txt - making note of this (this note
includes the time and date the script was ran).

So, like I said, Windows Scheduler doesn't seem to be working, save for
in situations where manual backups are just as effective. Any ideas as
to what I can do to fix this?

Also, any ideas as to how I can better test whether or not it is
working? Thus far, all the tests I've attempted to use give me
(apparently) false results. However, being able to only run one test a
day is going to make this take much more time than I'd like it to...



.

Relevant Pages

  • Feedback on backup script
    ... The one problem I have is that the script keeps stopping at lines 633,635 and or 637 with the error "Path Not Found" I have emailed the original author for help but haven't heard back yet. ... I was just wondering if the problem could be that the account running the script doesn't have correct permissions to a share/directory/file that it's trying to backup? ... ' always one less than the actual number of folders. ... ' Show the user free space info on all available disk drives ...
    (microsoft.public.scripting.vbscript)
  • Re: Enterprise Manager Newbie Question
    ... a SQL backup is not a simple copy of the database files. ... Is it possible to write a script that one could run from a workstation and ...
    (microsoft.public.sqlserver.tools)
  • Re: xcopy and vbscript
    ... It takes about 5-6 minutes to backup approximately ... A copy of the script is below for reference. ... ObjShell.Popup strMessage, 5, "Backup Complete", OK_Button ... Dim sSrc, sDest ' as string ...
    (microsoft.public.scripting.vbscript)
  • Re: How do I move an account... A few more details... and more
    ... >> use this system as a backup system if the first ever goes down. ... >> rsync for this. ... >serv1 and the system you back up to is fs. ... >rsync script. ...
    (Fedora)
  • Re: Maintain backup directory
    ... When I run the script (after setting target to the right ... the backup media runs out of ... Remove the word "echo" from Line #18 to enable the file deletion. ...
    (microsoft.public.scripting.wsh)