Error - Could not find procedure master..sqbutility
Published 01 March 2013
When installing the SQL Backup Pro server components on a SQL Server instance using the SQL Backup Pro graphical user interface, the following error may arise:
To resolve this issue, install the server components manually:
- Open the SQL Backup Pro installation folder. By default this is:
- %Program Files%\Red Gate\SQL Backup 7 on 32-bit servers
- %Program Files (x86)%\Red Gate\SQL Backup 7 on 64-bit servers
- Locate SQBServerSetup.exe and copy it to the machine on which you want to install the server components.
- Run SQBServerSetup.exe and follow the instructions in the wizard. For more information, see Installing the server components manually.
If the error persists, install the sqbutility extended stored procedure manually by running the following command against the master database of the SQL Server:
execute sp_addextendedproc sqbutility, "xp_sqlbackup.dll"
If xp_sqlbackup.dll is not found, copy the file from the SQL Backup Pro server components installation folder to the SQL Server Binn folder, then run the command again. By default, xp_sqlbackup.dll is installed in:
- %ProgramFiles%\Red Gate\SQL Backup 7\<instance name>\<platform> on 32-bit machines
- %ProgramFiles(x86)%\Red Gate\SQL Backup 7\<instance name>\<platform> on 64-bit machines
Note that the extended stored procedure is platform specific.
By default, the SQL Server Binn folder is found at %ProgramFiles%\Microsoft SQL Server\MSSQL.x\MSSQL\Binn