Competition: What’s your favorite Redgate tool? Enter now.

Cannot find the function sqbutility

timnjoan33timnjoan33 Posts: 4
edited July 18, 2006 10:47PM in SQL Backup Previous Versions
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!

Comments

  • peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • 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?
  • peteypetey Posts: 2,358 New member
    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'
    
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Excellent thank you.

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