http://www.perlmonks.org?node_id=951514


in reply to Re^2: Backup Sql databse
in thread Backup Sql databse

Take this out of CGI and just run it from the command line until you get it working. The backup command outputs print statements which are usually received via an error handler. Look at the script http://cpansearch.perl.org/src/MJEVANS/DBD-ODBC-1.34_2/examples/backup_restore.pl which I know works - you might want to comment out the restore first though. The main point is that any procedure you call has to run to completion and if nocount is off and the proc issues output the client end needs to read the output or the proc does not complete.