How can we help you today? How can we help you today?

SQL SERVER 2008 - upgrade advisor warning about sqlbackup?

Apologies if this has already been discussed. I searched on SQL Server 2008, but got an empty browser back, so I'm posting this here.

I'm getting ready to upgrade our data warehouse box to SQL Server 2008. The upgrade advisor returns this warning:
The DLLs that are listed in the report define extended stored procedures that have not been registered using the full path. These extended stored procedures will not work after upgrade because SQL Server will be unable to locate the DLLs. Use sp_dropextendedproc and sp_addextendedproc to drop and then reregister the DLLs with the full path.

This pertains to:
XP name: sqbdata
XP name: sqbdir
XP name: sqbmemory
XP name: sqbstatus
XP name: sqbtest
XP name: sqbtestcancel
XP name: sqbteststatus
XP name: sqbutility
XP name: sqlbackup

AND:
XP DLL name: xp_sqlbackup.dll


What is the proper procedure to perform the upgrade and continue to be able to use SQL Backup, please?
randyv
0

Comments

5 comments

Sort by
  • priyasinha
    Hi,

    Please read this post:

    http://www.red-gate.com/MessageBoard/viewtopic.php?p=26995

    Hope this helps.

    Thanks,
    Priya
    priyasinha
    0
  • ChrisAVWood
    Priya,

    What is the status of Bug Report reference number is SB-3550? Is it part of V 6?

    Thanks

    Chris
    ChrisAVWood
    0
  • priyasinha
    Hi Chris,

    This issue is still under review for V 6.0. We are not yet sure at this stage whether it will make into V 6.0 or later release.

    Thanks,
    Priya
    priyasinha
    0
  • ChrisAVWood
    This makes it sound like V 6 is further away than possibly expected. I thought that it was in Q2 200(/

    Chris
    ChrisAVWood
    0
  • priyasinha
    Hi Chris,

    SQL Backup 6.0 is planned to be released in Q2.

    There are certain bugs which we are still under review. SB-3550 is under this category... depending on development time and schedule for the project we would be able to decide about this. I will keep you updated about this issue.

    Thanks,
    Priya
    priyasinha
    0

Add comment

Please sign in to leave a comment.