Pre and post Batch files do not work when job runs
Hello. I have an issue where I am trying to backup and Oracle database on a different server. The oracle client has been installed on the BackupExec server so it can connect to the Oracle database server. I can manually run the batch files to "Shutdown and Startup" the remote database, yet when I add these batch files to the "Pre and Post" sections of the job, Backup exec and the job runs,but the batch files DO NOT execute. There isn't an error on the job log itself and Backeupexec even shows that the job seems to run fine. If I try to run the batch files manually, the usual black command line screen comes up and you can see the commands being execute. This DOES NOT happen when the backup exec job runs even though it says everything ran successfully. Here are a few other tidbits that may be relevant.
I am using 2003 server 6bit
Oracle Client is installed.
The Pre/Post option is set to run ON the backupexec server
This is a trial version of Backup Exec 2010 I am using.
The Backup exec services are either using "local System, or an Administrator account" so permissions shouldn't be the problem
We need to backup the oracle database this way because we will not be able to buy Oracle Agents. We used Arcserve in the past and Arcserve ran the batch files without any problems. Us purchasing Backup Exec depends on if we can get it to run these batch files that ran with Arcserve.
Thank for any help on this.
In general for scheduled tasks, if you're only accessing things on the local computer, "Local system" is probably good enough. If you're doing anything over the network, you'll need a Domain Account. Within BackupExec, these pre & post tasks are going to be using whatever account the BackupExec services use on the BE server - which is almost certanly a Domain Admin if you're setup correctly.
When in doubt, from the Tools menu, select Backup Exec Services, then click on Services credentials. Use this to change the services to use whatever account you're using for Backup Exec. If that account is missing some rights, this process will (usually) clean that up.
I'd recommend trying this:
-On the BE server, make a directory C:\TestBE
-Assign the "Everyone" group "Full" rights to that directory.
-Make a batch file called "C:\TestBE\PreTest.bat", with the following contents
ECHO Pre Command works OK>C:\TestBE\Pre-OK.txt
-Make a batch file called "C:\TestBE\PostTest.bat", with the collowing contents
ECHO Post Commans works OK>C:\TestBE\Post-OK.txt
-Make a test backup job (something small), and assign the above two as Pre & Post tasks.
-Run that test jobIf this works, then BE is working OK. Your problem is either rights, or a problem with your script.
If there's any way to log the output of your pre & post files (such as pipeing the output with ">"), you should get a better idea of what's going on. Troubleshooting blindly can be a real pain!