Could not find procedure 'master...sqbutility'

Category: Troubleshooting & error messages
Date: 13 Jul 2009
Product: SQL Backup
Versions: 5,6

When deploying SQL Backup server components to a SQL Server for the first time, the following error message may appear in the status area:
Could not find procedure 'master...sqbutility'

If you encounter this error when attempting to install the SQL Backup Server Components using the SQL Backup GUI "Install or upgrade Server Components" option. Locate the following executable in the SQL Backup Installation Folder (By default: C:\Program Files\Red Gate\SQL Backup):

SQBServerSetup.exe

Copy the file to the SQL Server you wish to deploy the SQL Backup Server Components to. Run the executable and follow the installation wizard to install the SQL Backup Server Components.

In the majority of cases, running SQBServerSetup.exe resolves this issue.

If you still encounter this issue, it is possible to install the sqbutility stored procedure manually. Once this has been done, the rest of the server component installation could be successful. To install the extended stored procedure, run the following command against the master database as a sysadmin using your preferred SQL query utility (Query Analyzer, Management Studio):

EXEC sp_addextendedproc sqbutility, "xp_sqlbackup.dll"

If an error message occurs explaining that xp_sqlbackup.dll could not be found, you may need to manually copy the file from the Red Gate SQL Backup installation folder to the SQL Server installation's BINN folder.

The xp_sqlbackup.dll file is generated when the server components are installed (whether the install succeeds to register the components or not). The file exists at the following location: c:\program files\red gate\sql backup\<instance name>\<platform>\ - where <instance name> is the name of the instance, and <platform> is the architecture - Win32, x64 or Itanium (and substitute the default directory accordingly if installed to a non-default location).

This file needs to be copied to the following location (again, substituting if not on a default location): c:\program files\microsoft sql server\<MSSQL.x>\MSSQL\Binn - where <MSSQL.x> is the identification for that SQL Server instance, for example MSSQL.1.

You should then be able to register SQL Backup's extended stored procedures correctly by using the following queries:
EXEC sp_addextendedproc sqlbackup, "xp_sqlbackup.dll"
EXEC sp_addextendedproc sqbutility, "xp_sqlbackup.dll"
EXEC sp_addextendedproc sqbstatus, "xp_sqlbackup.dll"
EXEC sp_addextendedproc sqbtest, "xp_sqlbackup.dll"
EXEC sp_addextendedproc sqbtestcancel, "xp_sqlbackup.dll"
EXEC sp_addextendedproc sqbteststatus, "xp_sqlbackup.dll"
EXEC sp_addextendedproc sqbdata, "xp_sqlbackup.dll"
EXEC sp_addextendedproc sqbmemory,"xp_sqlbackup.dll"
EXEC sp_addextendedproc sqbdir,"xp_sqlbackup.dll"

The server components make use of both 32-bit and 64-bit applications on a 64-bit platform, so by default they are installed into the Program Files (x86) directory rather than Program Files. Saying that, the extended stored procedure will be platform specific - either 32-bit, 64-bit or Itanium - so that it integrates correctly with SQL Server. While the SQBCoreService.exe runs as a 32-bit application (denoted by the *32 in Task Manager), SQL Backup 5 fully supports 64-bit architectures and SQL Server instances