Upgrading server components from UI fails

brosatobrosato Posts: 89 Bronze 2
edited August 20, 2010 11:37AM in SQL Backup Previous Versions
I get errors and have to manually install on 30+ servers. It never has worked for me.


sv0220sqlmon1\dba: Server Component Installation - Failed
=========================================================

Checking Permissions - Successful

Click 'Retry' to reinstall the server components. If this problem persists, it may be necessary to uninstall the server components manually, and then reinstall by running SQBServerSetup.exe on the server. See red-gate.com/sqbmanualinstall


Copy SQBServerSetup.exe to server - Successful

Click 'Retry' to reinstall the server components. If this problem persists, it may be necessary to uninstall the server components manually, and then reinstall by running SQBServerSetup.exe on the server. See red-gate.com/sqbmanualinstall


Run setup on server - Successful

Click 'Retry' to reinstall the server components. If this problem persists, it may be necessary to uninstall the server components manually, and then reinstall by running SQBServerSetup.exe on the server. See red-gate.com/sqbmanualinstall


Start SQL Backup Agent service - Successful

Click 'Retry' to reinstall the server components. If this problem persists, it may be necessary to uninstall the server components manually, and then reinstall by running SQBServerSetup.exe on the server. See red-gate.com/sqbmanualinstall


Check installed versions - Failed

The SQL Backup extended stored procedure DLL version is 6.3.0.48, and 6.4.0.56 was expected.

Click 'Retry' to reinstall the server components. If this problem persists, it may be necessary to uninstall the server components manually, and then reinstall by running SQBServerSetup.exe on the server. See red-gate.com/sqbmanualinstall


Check SQLBackup extended stored procedures - Successful

Click 'Retry' to reinstall the server components. If this problem persists, it may be necessary to uninstall the server components manually, and then reinstall by running SQBServerSetup.exe on the server. See red-gate.com/sqbmanualinstall


Delete setup file from server - Successful

Click 'Retry' to reinstall the server components. If this problem persists, it may be necessary to uninstall the server components manually, and then reinstall by running SQBServerSetup.exe on the server. See red-gate.com/sqbmanualinstall


Verifying Installation - Failed

Click 'Retry' to reinstall the server components. If this problem persists, it may be necessary to uninstall the server components manually, and then reinstall by running SQBServerSetup.exe on the server. See red-gate.com/sqbmanualinstall

Comments

  • brosatobrosato Posts: 89 Bronze 2
    Can't even run it locally. Can't replace xp_sqlbackup.dll :evil:
  • Hi there,

    Sorry you are running into this. The sure fire way to install the server side components is to perform this manually.

    To do can follow the instructions detailed on the below link for manual installation (about 2/3rds of the way down the page):

    http://www.red-gate.com/supportcenter/C ... 923310.htm

    If you are still having issues, then this is more than likely because SQL Server is not releasing that particualr dll. This is particularly prevalent with SQL Server 2000, but has been known in 2005 and 2008. The way to resolve this is as follows:

    If SQL Server Service cannot be stopped:

    1. Find the Version 6.4 of xp_sqlbackup.dll (a copy can be found in the SQL Backup 6.4 installation folder)
    2. Copy it somewhere else
    3. Rename the copied file from step 2, e.g. xp_sqlbackup64.dll
    4. Stop the SQL Server Agent
    5. Run:

    DBCC xp_sqlbackup(FREE)
    EXEC sp_dropextendedproc sqlbackup
    EXEC sp_dropextendedproc sqbstatus
    EXEC sp_dropextendedproc sqbutility
    EXEC sp_dropextendedproc sqbmemory
    EXEC sp_dropextendedproc sqbdata
    EXEC sp_dropextendedproc sqbdir
    EXEC sp_dropextendedproc sqbtest
    EXEC sp_dropextendedproc sqbtestcancel
    EXEC sp_dropextendedproc sqbteststatus

    6. Find the renamed version from step 3, e.g. xp_sqlbackup64.dll and copy this to the SQL Server instance BINN folder.
    7. Run:

    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”

    8. Start the SQL Server Agent

    If SQL Server Service can be stopped:

    1. Open a new query windows in SQL Server Management Studio (SQL Server 2005) or Query Analyzer (SQL Server 2000)
    2. Type the following:

    DBCC xp_sqlbackup(FREE)
    EXEC sp_dropextendedproc sqlbackup
    EXEC sp_dropextendedproc sqbstatus
    EXEC sp_dropextendedproc sqbutility
    EXEC sp_dropextendedproc sqbmemory

    3. Stop the SQL Server Service.
    4. Find all previous versions of xp_sqlbackup on your system and remove them including the installation folder.
    5. Find xp_sqlbackup.dll (a copy can be found in the SQL Backup installation folder) and copy this to the SQL Server instance BINN folder.
    6. Start the SQL Server Service.
    7. Reinstall the SQL Backup server components.

    HTH!

    Pete
    Peter Peart
    Red Gate Software Ltd
    +44 (0)870 160 0037 ext. 8569
    1 866 RED GATE ext. 8569
  • I'm having similar problems when trying to install on SQL2000 SP4 (w2k3 server). I get the following errors when I run the SQL commands in step 5.

    ~~~~~~~~~~~~~~~

    DBCC execution completed. If DBCC printed error messages, contact your system administrator.
    Server: Msg 3701, Level 11, State 5, Procedure sp_dropextendedproc, Line 18
    Cannot drop the procedure 'sqlbackup', because it does not exist in the system catalog.
    Server: Msg 3701, Level 11, State 5, Procedure sp_dropextendedproc, Line 18
    Cannot drop the procedure 'sqbstatus', because it does not exist in the system catalog.
    Server: Msg 3701, Level 11, State 5, Procedure sp_dropextendedproc, Line 18
    Cannot drop the procedure 'sqbutility', because it does not exist in the system catalog.
    Server: Msg 3701, Level 11, State 5, Procedure sp_dropextendedproc, Line 18
    Cannot drop the procedure 'sqbmemory', because it does not exist in the system catalog.
    Server: Msg 3701, Level 11, State 5, Procedure sp_dropextendedproc, Line 18
    Cannot drop the procedure 'sqbdata', because it does not exist in the system catalog.
    Server: Msg 3701, Level 11, State 5, Procedure sp_dropextendedproc, Line 18
    Cannot drop the procedure 'sqbdir', because it does not exist in the system catalog.
    Server: Msg 3701, Level 11, State 5, Procedure sp_dropextendedproc, Line 18
    Cannot drop the procedure 'sqbtest', because it does not exist in the system catalog.
    Server: Msg 3701, Level 11, State 5, Procedure sp_dropextendedproc, Line 18
    Cannot drop the procedure 'sqbtestcancel', because it does not exist in the system catalog.
    Server: Msg 3701, Level 11, State 5, Procedure sp_dropextendedproc, Line 18
    Cannot drop the procedure 'sqbteststatus', because it does not exist in the system catalog.
  • Hi there,

    I am guessing this is step 5 of when the instance cannot be stopped? Can you try re-running SQBServerSetup.exe a couple of times to see if you can persist the installation that way?

    If not, let me know.

    Many thanks,

    Pete
    Peter Peart
    Red Gate Software Ltd
    +44 (0)870 160 0037 ext. 8569
    1 866 RED GATE ext. 8569
  • It was generating similar error messages whichever method I tried.

    I ran SQBServerSetup.exe manually and this did sort it.
  • Glad to hear it's now working for you!

    Pete
    Peter Peart
    Red Gate Software Ltd
    +44 (0)870 160 0037 ext. 8569
    1 866 RED GATE ext. 8569
Sign In or Register to comment.