Error on Execution of Backup

michellem33michellem33 Posts: 19
edited January 29, 2006 2:08AM in SQL Backup Previous Versions
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

Comments

  • peteypetey Posts: 2,358 New member
    Is this for a named instance? If so, what is the name of the instance?
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • 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.
  • peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Thanks very much for your help. It is now working.
Sign In or Register to comment.