Unable to upgrade to SQL Backup 10: Access Denied

tomslickers

I am trying to upgrade one of our servers to SQL Backup 10. The "Install or upgrade server components" failed with code 262144 - "The version of the SQL Backup Pro extended stored procedure dynamic-link library (xp_sqlbackup.dll) is incorrect" so I tried uninstalling the server components (from the server) and reinstalling using SQBServerSetup. This fails with the error "C:\Program Files (x86)\Common Files\Red Gate\SQL Backup\SQBShellExt.dll. An error occurred trying to replace the existing file: DeleteFile failed: code 5. Access is denied"

I ran this upgrade on several other servers without issue. 

Dan B

Hi Thomas,

I believe this issue is resolved from your support ticket but for anyone else reading

the solution is to navigate toC:\Program Files (x86)\Common Files\Red Gate\SQL Backup\ and delete the SQBShellExt.dll manually, I would also remove any other files here and then retry the installation.

If you can't manually delete the file you would need to reboot SQL Server or the Physical Server itself to release whatever has a lock on this file.