Hi, i think that this is the problem. however i can't work out how to use the suggestion on my script, i have done this,

#!/usr/bin/perl

use CGI::Carp qw(fatalsToBrowser);
use DBI;

print "Content-type: text/html\n\n";

my $dbs = "DBI:ODBC:DRIVER={SQL Server};SERVER={dmssql01};DATABASE={sa
+ge200_dmstestconversion}"; 
my ($username, $password) = ('user', 'passwd');

my $dbh = DBI->connect($dbs, $username, $password) or die "$DBI::errst
+r\n";

my $sth = $dbh->prepare( 'backup database Sage200_DMSTestConversion to
+ DISK = \'d:\sage\sage200data\sagebackup2.bak\' ;') or die "Couldn't 
+prepare statement: " . $dbh->errstr;


$sth->execute() or die "execute failed: " . $sth->errstr();
do {

    while (my @row = $sth->fetchrow_array()) {
      print "backing up,<br>";
      print @row;
    }
  } while ($sth->{odbc_more_results});

my @error = $sth->err;

print @error;


$sth->finish(); 
$dbh->disconnect();

print "Backup Completed";
[download]

This still gives me the same output to screen and doesn't backup. Thanks