Cannot find the function sqbutility

• 
  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.

  petey July 13, 2006 20:57

  - 0 +
• 
  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?

  BrianM July 18, 2006 21:40

  - 0 +
• 
  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'
  

  petey July 18, 2006 21:54

  - 0 +
• 
  Excellent thank you.
  
  I ended up uninstalling, stopping the service and deleting the v3dll and reinstalling and it seems to be working fine now.

  BrianM July 18, 2006 22:47

  - 0 +

Add comment

Please sign in to leave a comment.