sqlbackup v4 on sql 2005
oberion
Posts: 41
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 :
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.
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
sp_addextendedproc sqbutility, 'xp_sqlbackup.dll'
should register the extended stored procedure.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
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.