What are the challenges you face when working across database platforms? Take the survey
Options

Stored procedure not installed during install

mfailemfaile Posts: 18 Bronze 2
edited July 7, 2007 11:25AM in SQL Backup Previous Versions
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

Comments

  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.