SQLBackup Connection Issues

mrclod

All of a sudden a couple of days ago, backups cease to work on one of my servers.

Connection error from SQL Backup GUI "Properties":

Connection Error: Error opening mutex.


Ran:

EXEC master..sqlbackup '-sql "BACKUP DATABASE model TO DISK = [c:\model.sqb] WITH INIT"'

Resulting with:

SQL Backup v5.3.0.178

---

ERRSQB: 5150 (Error opening mutex.) (Global\SQBMutex_): 5 (Access is denied.)

exitcode 5150
sqlerrorcode 0


Nothing appears to have changed on the server/network side as all other servers working properly.

I have kickstarted the "SQL Backup Agent" serveral times with no success other than to remove the WAIT_TIMEOUT error I was previously receiving (exitcode 5240)


What next?

petey

When the SQL Backup Agent starts up, it grants read/write rights to certain Windows objects to both the SQL Server and SQLBackup service's startup accounts. When you run a backup using the extended stored procedure, the extended stored procedure needs to access those objects momentarily.

The error message suggests that the SQL Server service startup account does not have rights to access the SQL Backup Agent objects. This is strange, as if you were able to start up the SQL Backup Agent service without errors, rights should have been granted without problems.

Could you please try using an account that has more rights to start up the SQL Backup Agent service, or use the same account as that of the SQL Server service?

mrclod

The following services all use the same account:

SQL Server
SQL Server Agent
SQL Backup Agent


I turned on xp_cmdshell and ran the following:

exec xp_cmdshell 'dir C:\"Program Files"\"Red Gate"\"SQL Backup"\(LOCAL)'


And received the following implying that access does exist:

output

---

Volume in drive C has no label.
Volume Serial Number is A8AA-9A42
NULL
Directory of C:\Program Files\Red Gate\SQL Backup\(LOCAL)
NULL
04/04/2008 11:55 AM <DIR> .
04/04/2008 11:55 AM <DIR> ..
02/25/2008 01:47 PM 2,925,568 SQBCoreService.exe
02/25/2008 01:47 PM 2,383,360 SQLBackupC.exe
04/04/2008 11:55 AM 49,822 unins000.dat
04/04/2008 11:54 AM 1,541,898 unins000.exe
04/04/2008 11:55 AM <DIR> Win32
10/03/2007 08:14 AM 59,904 zlib1.dll
5 File(s) 6,960,552 bytes
3 Dir(s) 60,351,586,304 bytes free
NULL

(16 row(s) affected)

mrclod

Cannot run this from the command line either from a privileged account:


C:\Program Files\Red Gate\SQL Backup\(LOCAL)>SQLBackupC.exe -SQL "BACKUP DATABASE model TO DISK = [c:\model.sqb] WITH INIT"

Red Gate SQL Backup 5.3.0.178, (c) Red Gate Software Ltd 2004 - 2007
Serial number: 010-030-073748-86CC

Backing up model (full database) to:
c:\model.sqb

VDI error 1010: Failed to get the configuration from the server because the timeout interval has elapsed. Check that the SQL Server
instance is running and that you have the SQL Server System Administrator server role; or try increasing the value of the VDITimeout
registry setting in HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\[InstanceName]
SQL error 3013: BACKUP DATABASE is terminating abnormally.
SQL error 3201: Cannot open backup device 'SQLBACKUP_023F1F83-10B3-464D-A860-F9839357A255'. Operating system error 0x80070005(Access
is denied.).

Memory profile
Type Maximum Minimum Average Blk count Total

---

---

---

---

---

---

Commit 1073414144 4096 1710222 1728 2955264000
Reserve 7991296 4096 405823 359 145690624
Free 23859200 4096 429304 280 120205312
Private 1073414144 4096 2223738 1337 2973138944
Mapped 1060864 4096 97358 78 7593984
Image 24862720 4096 178901 672 120221696


Warning 300: Backup failed. Retry attempt: 1

mrclod

Gave "Everyone" full access for the RedGate software.

Still does not work.

???????

petey

The error message 'Cannot open backup device 'SQLBACKUP_023F1F83-10B3-464D-A860-F9839357A255'. Operating system error 0x80070005(Access is denied.). ' is a little worrying. It indicates that SQL Server was unable to access the virtual backup device created by SQL Backup.

Was the service startup account changed recently e.g. dropped and recreated, or perhaps had its password changed? If possible, could you please try restarting the SQL Server service?

mrclod

I set the SQL Backup Agent to startup with a privileged account and restarted.

Same issue. Where do we go from here?

mrclod

Not able to restart the SQL Server service at this time. Live production system that would require informing quite a few clients as well as an off time.

I have a ticket in for our IT team to address your latest concern. Is there anything else we can try while we await their response?

petey

Is there anything else we can try while we await their response?

Sorry, I can't think of anything else to try.