Trying to install sqlbackup extended stored procedure

• 
  Hello,
  
  I would guess that you'd probably upgraded SQL Backup and need to uninstall the current stored procedure. To do this, you can use the 'install extended stored procedure' program from the SQL Backup program group to uninstall the current SQLBackup extended stored procedure and run it once more to install the newer one.
  
  To see if SQL Backup's extended procedure is installed, you can run the following from a SQL Server connection (Query Analyzer):

  exec sp_helpextendedproc 'SQLBackup'
  

  
  To manually drop an extended stored procedure, you can also use SQL Server's sp_dropextendedproc stored procedure.

  Brian Donahue December 20, 2005 12:58

  - 0 +
• 
  I've tried that already. The stored procedure is not in sysobjects. There is no sign of it but I can't install extended SP

  pchee373 December 20, 2005 14:22

  - 0 +
• 
  What happens when you enter
  
  exec master..sqlbackup ''
  
  in Query Analyzer? Is your server case sensitive?

  petey December 20, 2005 21:32

  - 0 +
• 
  Good one!
  
  If you run sp_helpextendedproc with no arguments, it will simply list all extended stored procedured on the system. Maybe you can try that and locate sqlbackup in the list?

  Brian Donahue December 21, 2005 05:13

  - 0 +
• 
  If I try to run sqlbackup I get a 'MSG2812: Could Not find the Stored Procedure ' master..sqlbackup'
  
  It's not listed in when I just run exec sp_helpextendedproc.
  
  I'm wondering if I have to restart the SQL service maybe. it's production so I have to wait.

  pchee373 December 21, 2005 11:54

  - 0 +
• 
  You shouldn't have to restart the server to install this and the install extended stored procedure program should put it in place for you.
  
  I suppose if that doesn't work, you could install it manually:

  • Copy c:\program files\red gate\sql backup\xp_sqlbackup.dll in your SQL Server's BINN folder.
  • Open Query Analyzer and run sp_addextendedproc 'sqlbackup', 'xp_sqlbackup.dll'
  • Run sp_helpextendedproc 'sqlbackup' to make sure it's listed this time.

  Brian Donahue December 21, 2005 12:24

  - 0 +
• 
  Can't do that either. It won't let me drop it saying that it doesn't exist and it won't let me add saying there's already a SP by that name. Where would this object exist? Or what table is it in? Thanks

  pchee373 December 21, 2005 13:52

  - 0 +
• 
  SELECT * FROM master..sysobjects WHERE type = 'X' ORDER BY crdate DESC

  petey December 21, 2005 14:34

  - 0 +
• 
  The sqlbackup Extended SP is NOT in the table, BUT it still says it exist so I can't install. Where can it possibly be?

  pchee373 December 21, 2005 15:28

  - 0 +
• 
  Well, there's a possibility that there is another object that goes by the same name. Try running
  
  SELECT * FROM master..sysobjects WHERE UPPER(name) = 'SQLBACKUP'

  petey December 21, 2005 21:11

  - 0 +
• 
  Tried it and nothing there either

  pchee373 December 22, 2005 11:43

  - 0 +
• 
  How about DBCC DROPEXTENDEDPROC('sqlbackup')?
  
  All I can think of after this is restarting the SQL Server Service. Possibly something is tied up in memory?

  Brian Donahue December 22, 2005 13:05

  - 0 +
• 
  Recently, there was another user who encountered the same issue. Try creating an object in the master database (table or view) and then drop it. Then try adding the extended stored procedure again.

  petey February 17, 2006 22:04

  - 0 +

Add comment

Please sign in to leave a comment.