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

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

SQL Backup failed with exit code: 669

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
matthewf



Joined: 17 Aug 2011
Posts: 3

PostPosted: Mon Nov 11, 2013 4:47 pm    Post subject: SQL Backup failed with exit code: 669 Reply with quote

Anybody know what a 669 is?
the "Error code reference - SQL Backup" page here skips from 668 to 680.

Edited Link: http://documentation.red-gate.com/display/SBU7/SQL+Backup+errors+500+-+5292

The version i'm running is 7.4.0.23
Thanks!
-----------------------------------

Date 11/11/2013 8:43:36 AM
Log Job History (SQL Backup differential backup: model and 6 others (created 10/24/2013 3:44:44 PM))

Step ID 1
Server BB1DB
Job Name SQL Backup differential backup: model and 6 others (created 10/24/2013 3:44:44 PM)
Step Name execute master..sqlbackup
Duration 00:00:00
Sql Severity 16
Sql Message ID 50000
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: CWI\sql-sa-bb1db. SQL Backup failed with exit code: 669 SQL error code: 0 [SQLSTATE 42000] (Error 50000). The step failed.
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2306

PostPosted: Tue Nov 12, 2013 12:52 am    Post subject: Reply with quote

SQL Backup generates a log file for each process that it runs. The default folder where the logs are stored is C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\<instance name> on Windows 2003 and older, and C:\ProgramData\Red Gate\SQL Backup\Log\<instance name> on Windows Vista and newer.

Could you please post the contents of the log file for the backup that failed?
_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
Back to top
View user's profile Send private message Send e-mail
eddie davis



Joined: 14 Jun 2006
Posts: 937
Location: Red Gate Software

PostPosted: Thu Nov 28, 2013 11:14 am    Post subject: Reply with quote

SQL Backup Exit Code 669 indicates that the start-up account for the SQL Backup Agent service does not have read / write permissions to the SQL Backup registry folders.

Please check the following registry folders and ensure that the account given to the SQL Backup Agent service has read/write permissions to the following registry folders:

HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettings\<InstanceName>
HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\<InstanceName>
HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\InstalledInstances\<InstanceName>

Where <InstanceName> is the name of the SQL Instance for a named instance or (local) for the default instance?

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
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