Red Gate forums :: View topic - SQL Backup failed with exit code: 850
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 6
SQL Backup 6 forum

SQL Backup failed with exit code: 850

Search in SQL Backup 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
xdai



Joined: 31 Dec 2008
Posts: 69

PostPosted: Fri Jan 08, 2010 4:10 pm    Post subject: SQL Backup failed with exit code: 850 Reply with quote

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
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6645

PostPosted: Mon Jan 11, 2010 2:33 pm    Post subject: Reply with quote

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 '='
Back to top
View user's profile Send private message
xdai



Joined: 31 Dec 2008
Posts: 69

PostPosted: Mon Jan 11, 2010 5:44 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group