SQL Backup failed with exit code: 850

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

SQL Backup failed with exit code: 850

Postby xdai » Fri Jan 08, 2010 4:10 pm

Hi, when I create a backup job which delete prior backup older than 20hours, the job failed, but when i change to 1 day, it is successful, please advice, here is the execute command

EXECUTE master..sqlbackup '-SQL "BACKUP DATABASE [testdb] TO DISK = ''\\\\xxxx\\N$\\MSSQL.1\\MSSQL\\Backup\\<AUTO>.sqb'' WITH ERASEFILES_ATSTART = 20H, MAILTO = "test@email.com'', COMPRESSION = 2, THREADCOUNT = 7"', @exitcode OUT, @sqlerrorcode OUT
xdai
 
Posts: 69
Joined: Wed Dec 31, 2008 11:50 pm

Postby Brian Donahue » Mon Jan 11, 2010 2:33 pm

Thanks for your post. I've copy/ pasted the query from your previous post and tried to run it (more or less). It seems there is a double-quote after the email address as I get this error:
Syntax error: 'test@email.com'' after '='
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby xdai » Mon Jan 11, 2010 5:44 pm

Here is the command

EXECUTE master..sqlbackup '-SQL "BACKUP DATABASE [testdb] TO DISK = ''\\\\server\\F$\\MSSQL.1\\MSSQL\\Backup\\<AUTO>.sqb'' WITH ERASEFILES_ATSTART = 20H, MAILTO = "test@email.com'', COMPRESSION = 2, THREADCOUNT = 7"'

the version is 1.2.
xdai
 
Posts: 69
Joined: Wed Dec 31, 2008 11:50 pm


Return to SQL Backup 6

Who is online

Users browsing this forum: No registered users and 0 guests