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

sqlbackup v4 on sql 2005

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.
oberion
0

Comments

3 comments

Sort by
  • petey
    Running

    sp_addextendedproc sqbutility, 'xp_sqlbackup.dll'

    should register the extended stored procedure.
    petey
    0
  • oberion
    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.
    oberion
    0
  • oberion
    nevermind, I just saw the announcement for 4.2 that will support sql 2005 w/ sp1.
    oberion
    0

Add comment

Please sign in to leave a comment.