Batch Script Problem

[FMAaron]

I have a batch script with the command:

copy /Y "C:Program FilesFileMakerFileMaker ServerDataBackups*.fp7" Q:Backups

If I run the batch script while logged in as Admin by double clicking it all of my FileMaker databases in Backup on the local drive are copied to Backup on the mapped drive Q.

I have a schedule programmed in FileMaker server to run this batch script at a set time. The admin console claims that the script is run without errors. When I check the backup folder it did none of the backups it was supposed to do.

Why will the script run when I double click it but not when FileMaker Server tells it to?

Thank you for your help.

Edited February 14, 2008 by Guest

[IdealData]

Are you using the Send Event script step?

If so then it won't run because FM SERVER only supports web compatible script steps - however FM CLIENT supports all the script steps.

[FMAaron]

Thanks for your quick response! I am always impressed with how friendly and responsive FileMaker users are.

I am not running the script from within a FileMaker database. I have scheduled the script to run from the Admin Console Schedules. I assume that is what you are referring to with the Send Event script step.

Did I understand you correctly?

I thought it would include the info from my profile in the first post (I don't think it did.) I am running FMS on Windows 2003.

Edited February 14, 2008 by Guest

[mcyrulik]

We had tried to do that also, on previous versions of filemaker server. It ended up being something to do with privileges that we could never remedy. It almost seemed like the fmsadmin user didn't have the rights to run that script.

We ended up using the FM Server scheduling to back up the databases to a local folder, then used the built in Task Scheduler to move the files to the network drive. Works just as well if you output the results of your "copy" statement to an output file.

[Steven H. Blackwell]

FMSAdmin does not have rights to run the OS script unless you tell it to "run as" with appropriate admin credentials for the source location.

See the excellent white paper on Backups on Wim Decorte's web site here.

Steven

[FMAaron]

Thanks so much for the advice!