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

Error upgrading server components from 5.1 to 5.3

willow_techiewillow_techie Posts: 14
edited March 20, 2008 11:15AM in SQL Backup Previous Versions
I am getting an error installing the server components on a box when clicking the upgrade icon: all steps are sucessful except the "Check Installed Versions" which says:

wh_reporting\sql2000: Server Component Installation - Failed


Check installed versions - Failed

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


Target box is SQL 2000 (latest SP). That same box runs an instance of SQL2005 as well, which was fine w/ the upgrade.

any ideas?

Comments

  • Options
    peteypetey Posts: 2,358 New member
    edited March 20, 2008 11:32AM
    During an upgrade, SQL Backup needs to replace the extended stored procedure library, xp_sqlbackup.dll. On SQL Server 2000, this sometimes fails as the command to release the library (DBCC xp_sqlbackup(FREE) )fails.

    The only way then to release the library cleanly is to restart the SQL Server service. Perform the upgrade again before any SQL Backup processes are started.

    The workaround is to redirect the SQL Backup extended stored procedures. See this documentfor details.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    a simple restart of sql worked great, thanks.

    finally, all production is on 5.3... :-)
Sign In or Register to comment.