How can we help you today? How can we help you today?

Error on Execution of Backup

Hi,

I have been testing SQL Backup 4 and when running the following command:

exec master..sqlbackup '-SQL "BACKUP DATABASE tst100mb TO DISK = [c:\bydbbackupfile.BAK.SQB] WITH COMPRESSION = 1 " '

I am recieving the following error:

SQL Backup (DLL v4.0.0.113)
Failed to connect to SQL Backup service: 1060 (The specified service does not exist as an installed service)

(1 row(s) affected)

I have checked and:

1)the SQL Backup Agent Service is running and is running as Local System
2)Builtin\administrators group has Sysadmin rights to SQL Server
michellem33
0

Comments

4 comments

Sort by
  • petey
    Is this for a named instance? If so, what is the name of the instance?
    petey
    0
  • michellem33
    Yes it is a named instance named SQLEXPRESS. It's a SQL 2005 Express edition. Have you seen this happen before? I had to manually register: SQLBackup, SQButilities, SBQMemory and sqlstatus. On the installation/upgrade screen; i have found that one component isn't working right. It says:

    Checking Service Application Version: Failed to retrieve application version.
    michellem33
    0
  • petey
    When you install SQL Server 2005 Express (Express), it is installed as a named SQL Server instance, using the name SQLEXPRESS. The SQL Backup installer does not install SQL Backup on named instances. You need to perform the following steps to use SQL Backup with Express.

    - copy xp_sqlbackup.dll from the SQL Backup installation folder to "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn"

    - register the SQL Backup extended stored procedures

    exec master..sp_addextendedproc sqlbackup, 'xp_sqlbackup.dll'
    exec master..sp_addextendedproc sqbstatus, 'xp_sqlbackup.dll'
    exec master..sp_addextendedproc sqbutility, 'xp_sqlbackup.dll'
    exec master..sp_addextendedproc sqbmemory, 'xp_sqlbackup.dll'

    - remove the SQL Backup service installed for the default instance:

    C:\Program Files\Red Gate\SQL Backup\sqbcoreservice -uninstall

    - install the SQL Backup service for the SQLEXPRESS instance:

    C:\Program Files\Red Gate\SQL Backup\sqbcoreservice -install -i sqlexpress

    In the Services panel, you should now see a service named SQL Backup Agent-SQLEXPRESS. Start this service. Ensure that the startup account has the SQL Server sysadmin server role.
    petey
    0
  • michellem33
    Thanks very much for your help. It is now working.
    michellem33
    0

Add comment

Please sign in to leave a comment.