SQL Backup failed with exit code: 669

Compresses, encrypts, secures and monitors SQL Server backups.

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

SQL Backup failed with exit code: 669

Postby matthewf » Mon Nov 11, 2013 4:47 pm

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/displ ... 500+-+5292

The version i'm running is

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

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.
Posts: 3
Joined: Wed Aug 17, 2011 5:07 pm

Postby petey » Tue Nov 12, 2013 12:52 am

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
Posts: 2233
Joined: Sun Apr 24, 2005 12:34 pm

Postby eddie davis » Thu Nov 28, 2013 11:14 am

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 Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests