Competition: What’s your favorite Redgate tool? Enter now.

Upgrade 5.2 to 5.3

krhyllkrhyll Posts: 6
edited February 27, 2008 4:12PM in SQL Backup Previous Versions
The server components upgrades correctly for two databases, and fails for two. Check installed versions fails as shown below.

How do I manually upgrade server component?

Kristian




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.2.0.2825, and 5.3.0.178 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

  • Eddie DEddie D Posts: 1,688 Rose Gold 5
    Sorry that you are recieving this issue.

    This issue is normally caused by SQL Server not releasing the xp_sqlbackup.dll located in the Server's Binn for upgrade.

    To manually upgrade the xp_sqlbackup.dll, please follow the steps below:

    Open a new query window and excute the following:

    DBCC xp_sqlbackup(FREE)

    sp_dropextendedproc sqlbackup, ‘xp_sqlbackup.dll’
    sp_dropextendedproc sqbstatus, ‘xp_sqlbackup.dll’
    sp_dropextendedproc sqbutility, ‘xp_sqlbackup.dll’
    sp_dropextendedproc sqbmemory, ‘xp_sqlbackup.dll’
    sp_dropextendedproc sqbdata, ‘xp_sqlbackup.dll’
    sp_dropextendedproc sqbdir, ‘xp_sqlbackup.dll’
    sp_dropextendedproc sqbtest, ‘xp_sqlbackup.dll’
    sp_dropextendedproc sqbtestcancel, ‘xp_sqlbackup.dll’
    sp_dropextendedproc sqbteststatus, ‘xp_sqlbackup.dll’


    Stop the SQL Server Service.

    Find all previous versions of xp_sqlbackup on your system.

    Find the Version 5.3 of xp_sqlbackup.dll ( a copy can be found in the SQL Backup 5.3 installation folder) and copy this to the SQL Server instance BINN folder.

    Start the SQL Server Service.

    sp_addextendedproc sqlbackup, ‘xp_sqlbackup.dll’
    sp_addextendedproc sqbstatus, ‘xp_sqlbackup.dll’
    sp_addextendedproc sqbutility, ‘xp_sqlbackup.dll’
    sp_addextendedproc sqbmemory, ‘xp_sqlbackup.dll’
    sp_addextendedproc sqbdata, ‘xp_sqlbackup.dll’
    sp_addextendedproc sqbdir, ‘xp_sqlbackup.dll’
    sp_addextendedproc sqbtest, ‘xp_sqlbackup.dll’
    sp_addextendedproc sqbtestcancel, ‘xp_sqlbackup.dll’
    sp_addextendedproc sqbteststatus, ‘xp_sqlbackup.dll’

    Normally the above action resolves this upgrading issue.

    Many Thanks
    Eddie

    Eddie Davis
    Technical Support Engineer
    Red Gate Software Ltd
    E-Mail: [email protected]
    Eddie Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
  • Thanks for your response.

    Before I read your response I tried:
    - stop backup agent
    - run SQBServerSetup.EXE manually

    Seems it also solved the problem with xp_sqlbackup.dll.

    But running backup I receive errors like:
    2008-02-27 22:04:23.53 Backup BACKUP failed to complete the command BACKUP DATABASE NordlandTest. Check the backup application log for detailed messages.
    2008-02-27 22:04:32.06 Backup Error: 3201, Severity: 16, State: 7.
    2008-02-27 22:04:32.06 Backup Cannot open backup device 'SQLBACKUP_9DCDA396-4890-4A20-AB5F-8D3808BCE491'. Operating system error 0x80070002(The system cannot find the file specified.).
    2008-02-27 22:04:32.06 Backup Error: 3041, Severity: 16, State: 1.
    2008-02-27 22:04:32.06 Backup BACKUP failed to complete the command BACKUP DATABASE model. Check the backup application log for detailed messages.

    Do you immediately understand the problem? The backups stopped working 10 days ago, not sure why. Any hints?

    Kristian
Sign In or Register to comment.