unable to run bat file from logical drive in Azure RRS feed

  • Question

  • My requirement is to schedule DB backups from SQL azure to csv files and save it in Azure storage. The backupjob needs to run periodically.We have developed our application which will do the following. 1) Create a container Azure. 2) Create a drive inside the container. 3) Copy bcp.exe and cp.rll to the drive created. 4) Create a .bat file("BCP \" select * from <dbname.tablename> \" QUERYOUT \"" + drivename + "users.csv\" -n -D<dbname> -U<username> -P<password> -S<servername> -a 16387 -b 10000") and save it in the drive created. 5) Execute the .batfile using the command Process.Start(mounteddrive.LocalPath + "createcsv.bat"); 6) Copy the csv file created to another container with a logical and unique filename. Here everything works fine except step 5. That means the csv files are not created. When we coded this and tested in dev storage, it worked perfectly, but when we deployed it in live environment, the csvfiles are not generating.
    Thursday, February 10, 2011 9:27 AM


  • Perhaps capturing the standard error and standard output from Process.Start would give you information about the nature of the problem.

    David Pallmann GM Application Development, Neudesic Windows Azure MVP
    • Marked as answer by Mog Liang Monday, February 21, 2011 10:10 AM
    Saturday, February 12, 2011 12:26 AM