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

sqlbackup v4 on sql 2005

oberionoberion Posts: 41
edited May 3, 2006 12:43PM in SQL Backup Previous Versions
hi,

I'm having some problem installing red-gate sqlbackup 4.1 on my sql 2005 box.

I had to enable the xp_cmdshell xproc
had to manually register :
sp_addextendedproc sqlbackup, 'xp_sqlbackup.dll'
GO
sp_addextendedproc sqbstatus, 'xp_sqlbackup.dll'
GO
sp_addextendedproc sqbutility, 'xp_sqlbackup.dll'
GO
sp_addextendedproc sqbmemory, 'xp_sqlbackup.dll'
GO

Then, I tried it again but now in the "checking service application version" I am getting:

Could not find stored procedure 'master..sqbutility'. (2812)

in "checking extended sproc DLL version"

I am getting:

Could not find stored procedure 'master..sqbutility'. (2812)

I know the uqbutility isn't in the master database, so the question is how do I get it there?

thanks.

Comments

  • Options
    peteypetey Posts: 2,358 New member
    Running

    sp_addextendedproc sqbutility, 'xp_sqlbackup.dll'

    should register the extended stored procedure.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    petey, I did that already and it still doesn't work.

    in the sql backup gui, I am unable to expand the cdb01 instance nor does it list the 6 databases associated with this instance, it has a red box next to it like it doesn't think the sql server is up. I couldn't install the sprocs and so forth so I had to drop the extended sproc.

    I am running sql 2005 w/ sp1 btw. Not sure if that helps.
  • Options
    nevermind, I just saw the announcement for 4.2 that will support sql 2005 w/ sp1.
Sign In or Register to comment.