What are the challenges you face when working across database platforms? Take the survey
Options

RESOLVED: Upgrade fails to verify version.

bboicebboice Posts: 24
edited January 12, 2009 7:27PM in SQL Backup Previous Versions
I'm clicking on the "gear" icon to update SQL Backup 5 on my SQL Server 2005 box. I experience the following error during the "Check installed versions" step (see below). Is there a better way to handle the upgrade?

HKSQL: Server Component Installation - Failed
=============================================

Copy SQBServerSetup.exe to server - Successful

This operation completed successfully.


Run setup on server - Successful

This operation completed successfully.


Start SQL Backup Agent service - Successful

This operation completed successfully.


Check installed versions - Failed

The SQL Backup extended stored procedure DLL version is 5.3.0.178, and 5.4.0.55 was expected.


Check SQLBackup extended stored procedures - Successful

This operation completed successfully.


Delete setup file from server - Successful

This operation completed successfully.


Updating SQL Server information - Successful

This operation completed successfully.

Comments

  • Options
    Hi bboice,

    Unfortunately when upgrading the SQL Backup Server Components, occasionally SQL Server will not correctly release our sqlbackup dll from memory preventing the file from being overwritten with the new version.

    In these cases a reboot or restart of the SQL Server/Service will allow you to successfully upgrade, obviously this is not always feasible with production systems etc so a workaround is available.

    To use the workaround please follow these steps :

    First confirm this is the case by running the following command DBCC xp_sqlbackup(FREE) in SSMS or Query Analyzer and try to delete the file xp_sqlbackup.dll from the following location :

    SQL Server 2000 x86 : %:\Program Files (x86)\Microsoft SQL Server\MSSQL\Binn

    SQL Server 2000 x64 : %:\Program Files\Microsoft SQL Server\MSSQL\Binn

    SQL Server 2005 x86 : %:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Binn

    SQL Server 2005 x64 : %:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn

    If you can delete this file please run the Server Components installer again, if you cannot follow these steps :

    Locate the new version of xp_sqlbackup.dll from the Server Components installation folder, by default this is :

    %:\Program Files\Red Gate\SQL Backup\<instance name>\Win32 (x86 Windows, x86 SQL Server)

    %:\Program Files (x86)\Red Gate\SQL Backup\<instance name>\Win32 (x64 Windows, x86 SQL Server)

    %:\Program Files (x86)\Red Gate\SQL Backup\<instance name>\Win64 (x64 Windows, x64 SQL Server)

    Make a copy of the file and rename it to xp_sqlbackup_new.dll, now place the renamed file into your SQL Server Instances' Binn folder.

    Unregister the extended stored procedures using the following commands in SSMS or Query Analyzer :

    EXEC master..sp_dropextendedproc sqlbackup
    EXEC master..sp_dropextendedproc sqbstatus
    EXEC master..sp_dropextendedproc sqbmemory
    EXEC master..sp_dropextendedproc sqbdir
    EXEC master..sp_dropextendedproc sqbutility
    EXEC master..sp_dropextendedproc sqbdata
    EXEC master..sp_dropextendedproc sqbtest
    EXEC master..sp_dropextendedproc sqbteststatus
    EXEC master..sp_dropextendedproc sqbtestcancel

    Register the extended stored procedures using the renamed file with the following :

    EXEC master..sp_addextendedproc sqlbackup, 'xp_sqlbackup_new.dll'
    EXEC master..sp_addextendedproc sqbstatus, 'xp_sqlbackup_new.dll'
    EXEC master..sp_addextendedproc sqbmemory, 'xp_sqlbackup_new.dll'
    EXEC master..sp_addextendedproc sqbdir, 'xp_sqlbackup_new.dll'
    EXEC master..sp_addextendedproc sqbutility, 'xp_sqlbackup_new.dll'
    EXEC master..sp_addextendedproc sqbdata, 'xp_sqlbackup_new.dll'
    EXEC master..sp_addextendedproc sqbtest, 'xp_sqlbackup_new.dll'
    EXEC master..sp_addextendedproc sqbteststatus, 'xp_sqlbackup_new.dll'
    EXEC master..sp_addextendedproc sqbtestcancel, 'xp_sqlbackup_new.dll'

    The Server Components should now function correctly, when using this workaround please replace the xp_sqlbackup.dll in the Binn folder after your next reboot.

    I hope this helps,
    Matthew Flatt
    Redgate Foundry
  • Options
    Thank you for the suggestions. Unfortunately, still no luck.

    When I deleted the file I was unable to run the update by clicking on the gear icon within SQL Backup. The error referenced the missing DLL.

    I rebooted the server and tried again, but received the same error (see below). Should I just remove SQL Backup and re-install it?

    HKSQL: Server Component Installation - Failed
    =============================================

    Copy SQBServerSetup.exe to server - Successful

    This operation completed successfully.


    Run setup on server - Successful

    This operation completed successfully.


    Start SQL Backup Agent service - Successful

    This operation completed successfully.


    Check installed versions - Failed

    The SQL Backup extended stored procedure DLL version is 5.3.0.178, and 5.4.0.55 was expected.


    Check SQLBackup extended stored procedures - Successful

    This operation completed successfully.


    Delete setup file from server - Successful

    This operation completed successfully.


    Updating SQL Server information - Successful

    This operation completed successfully.
  • Options
    I copied the setup executable to the server in question and ran it while logged into the server. This time the update appears to have been successful.

    Thanks for the assistance.
Sign In or Register to comment.