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

Stored procedure not installed during install

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
mfaile
0

Comments

1 comment

Sort by
  • 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.
    petey
    0

Add comment

Please sign in to leave a comment.