SQL SERVER 2008 - upgrade advisor warning about sqlbackup?

randyv

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?

priyasinha

Hi,

Please read this post:

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

Hope this helps.

Thanks,
Priya

ChrisAVWood

Priya,

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

Thanks

Chris

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

ChrisAVWood

This makes it sound like V 6 is further away than possibly expected. I thought that it was in Q2 200(/

Chris

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