5.2 Upgrade Issue

Comments

• petey Redgate › Posts: 2,358 New member

  February 21, 2008 7:42PM

  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.

  Peter Yeoh
  SQL Backup Consultant Developer
  Associate, Yohz Software
  Beyond compression - SQL Backup goodies under the hood, updated for version 8

  0 · Share on Twitter
• aaronakin Posts: 4

  February 22, 2008 9:39AM

  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?

  0 · Share on Twitter
• aaronakin Posts: 4

  February 22, 2008 9:43AM

  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

  0 · Share on Twitter