[SQL Backup 7]Cannot conduct database backup (exitcode 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 7]Cannot conduct database backup (exitcode 669)

Postby lamttl » Mon Nov 04, 2013 10:12 am

HI all

I am encountering issue on a flash installed SQL server 2012 on Windows 2012.

The backup of database fail with the following error no matter I use the GUI or using the stored procedure "sqlbackup"

Code: Select all
SQL Backup could not access [HKEY_LOCAL_MACHINE\\SOFTWARE\\Red Gate\\SQL Backup\\BackupSettingsGlobalINSTANCE1] running as user [SQLAdmin].


Image

I cannot find the registry specified by the error code.

However, interesting thing is when I browse the registry using Regedit, it is show that the following registry exist:
SOFTWARE\\Red Gate\\SQL Backup\\BackupSettingsGlobal\\INSTANCE1

It seems that the path in error message is missing the back slash.
May anyone help to advise how to fix this?

Below please have the software version:
SQL server: Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)
Windows: Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)
SQL Backup Version: 7.4.0.186

lamttl
 
Posts: 2
Joined: Mon Nov 04, 2013 9:10 am

Postby petey » Tue Nov 05, 2013 3:27 am

Could you please check if the user mentioned in the error message has read/write rights to that registry entry?

Thank you for pointing out the typo in the error message. This will be fixed in the next release.
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2234
Joined: Sun Apr 24, 2005 12:34 pm

Postby lamttl » Thu Nov 07, 2013 3:41 am

Thanks, the issue is caused by Group assignment of Domain ID.

(We through the Domain admin added the domain ID to a domain group that have local administrator privilege, but they actually not.)

I grant the access privilege directly to the domain account that starting SQL backup Agent service and the problem is solved.
lamttl
 
Posts: 2
Joined: Mon Nov 04, 2013 9:10 am


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests