Stored procedure not installed during install

mfaile

Recently installed V5 into a 2-node MS cluster and when I run a backup script
ala :

<snip>
EXEC master..sqlbackup @command
, @exitcode OUTPUT
, @sqlerrorcode OUTPUT
<snip>

I get the error:

Msg 2812, Level 16, State 62, Line 13
Could not find stored procedure 'master..sqlbackup'.

I would assume the stored procs did not get installed during the clustered install. How can I easily remedy this?

Thanks
Matt

petey

If it's only the stored procedures that did not get installed, do the following:

- adding the extended stored procedure library
Copy xp_sqlbackup.dll from the SQL Server Binn folder of a server where SQL Backup has been successfully installed, to the Binn folder of the current server.

- registering the extended stored procedures
sp_addextendedproc sqlbackup, 'xp_sqlbackup.dll'
sp_addextendedproc sqbutility, 'xp_sqlbackup.dll'
sp_addextendedproc sqbstatus, 'xp_sqlbackup.dll'
sp_addextendedproc sqbtest, 'xp_sqlbackup.dll'
sp_addextendedproc sqbtestcancel, 'xp_sqlbackup.dll'
sp_addextendedproc sqbteststatus, 'xp_sqlbackup.dll'
sp_addextendedproc sqbdata, 'xp_sqlbackup.dll'
sp_addextendedproc sqbmemory, 'xp_sqlbackup.dll'
sp_addextendedproc sqbdir, 'xp_sqlbackup.dll'

However, if the SQL Backup Agent service has also not been installed, it would be use the server components installer (SQBServerSetup.ex) to perform the installation.