What are the challenges you face when working across database platforms? Take the survey
Options

SQLBackup Connection Issues

mrclodmrclod Posts: 60
edited August 30, 2008 1:36PM in SQL Backup Previous Versions
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?

Comments

  • Options
    peteypetey Posts: 2,358 New member
    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?
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    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)
  • Options
    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
  • Options
    Gave "Everyone" full access for the RedGate software.

    Still does not work.

    ???????
  • Options
    peteypetey Posts: 2,358 New member
    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?
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    I set the SQL Backup Agent to startup with a privileged account and restarted.

    Same issue. Where do we go from here?
  • Options
    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?
  • Options
    peteypetey Posts: 2,358 New member
    Is there anything else we can try while we await their response?
    Sorry, I can't think of anything else to try.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.