Cannot find the function sqbutility

timnjoan33

Hi - just downloaded and installed version 4.5 - we had been on version 3.0 before - I tried to go into the gui and am now getting the error below:

Cannot find the function sqbutility in the library xp_sqlbackup.dll. Reason: 127(The specified procedure could not be found.).
7/13/2006 2:35:00 PM

What should I do?

Thanks!

petey

Check that the xp_sqlbackup.dll file in your SQL Server Binn folder is version 4.5.

Register that extended stored procedure manually:

sp_addextendedproc sqbutility, 'xp_sqlbackup.dll'

You might also need to register the other new extended stored procedures (check if they exist already):

sp_addextendedproc sqbstatus, 'xp_sqlbackup.dll'
sp_addextendedproc sqbmemory, 'xp_sqlbackup.dll'

How did you upgrade? Uninstall version 3, followed by installation of version 4.5, or straight installation of version 4.5 ...?

Thanks.

BrianM

Hi I too am having this problem

I have tried what you have suggested but it does not work.

The dll did have the wrong version and I have fixed that up but I still get the error. Also when I search the registry I cannot find the dll but when i run the sp_addextendedproc sqbstatus, 'xp_sqlbackup.dll' it says Server: Msg 2714, Level 16, State 7, Procedure sp_addextendedproc, Line 26
There is already an object named 'sqbstatus' in the database.

I have tried uninstalling and reinstalling.

Any other suggestions?

petey

Try the following:

- run the following

sp_dropextendedproc sqlbackup, 'xp_sqlbackup.dll'
sp_dropextendedproc sqbstatus, 'xp_sqlbackup.dll'
sp_dropextendedproc sqbutility, 'xp_sqlbackup.dll'
sp_dropextendedproc sqbmemory, 'xp_sqlbackup.dll'

- Stop the SQL Server service.

- Find all version 3 of xp_sqlbackup on your system, and remove them. You may find a copy in the SQL Backup 3 installation folder.

- Start SQL Server service.

- Find version 4 of xp_sqlbackup.dll (a copy can be found in the SQL Backup 4 installation folder), and copy this to your SQL Server instance's Binn folder

- Run the following:

sp_addextendedproc sqlbackup, 'xp_sqlbackup.dll'
sp_addextendedproc sqbstatus, 'xp_sqlbackup.dll'
sp_addextendedproc sqbutility, 'xp_sqlbackup.dll'
sp_addextendedproc sqbmemory, 'xp_sqlbackup.dll'

BrianM

Excellent thank you.

I ended up uninstalling, stopping the service and deleting the v3dll and reinstalling and it seems to be working fine now.