5.2 Upgrade Issue

aaronakin

I just upgraded from 5.1 to 5.2.0.2824. When I open the SQL Backup application and go to Help > About, it says the correct version, but when I run EXEC master..sqlbackup, it says SQL Backup v5.1.0.2781 as the column name.

What do I need to do to update the XP to the correct version?

petey

In the SQL Backup installation folder, there should be a file named xp_sqlbackup.dll in one of 3 possible subfolders (win32, x64, itanium) depending on your processor type.

Copy the file to your SQL Server instances' Binn folder e.g. \Program Files\Microsoft SQL Server\MSSQL\Binn. If the file is locked, run the following command:

DBCC xp_sqlbackup(FREE)

If the file is still locked, you would need to stop the SQL Server instances' service before you can replace the file.

aaronakin

I copied the DLL from "C:\Program Files\Red Gate\SQL Backup\(LOCAL)\Win32" to my binn directory and ran:

DECLARE @value varchar(32)
EXEC master..sqbutility 1030, @value OUTPUT
SELECT @value

This still returns 5.1.0.2781. I even tried to drop the extended procedure and readd it. I even tried to specify the full path to the binn directory just in case, but I still get the same version being returned.

The modified date for the DLL in both locations is 5/21/07. Is this the correct DLL?

aaronakin

Well, it looks like I found the fix.

Originally, I installed 5.1 and then ran the 5.2 install. Since this didn't work, I tried running the C:\Program Files\Red Gate\SQL Backup\SQBServerSetup.exe file. After running this, the version finally changed to 5.2