How can we help you today? How can we help you today?

Error upgrading server components from 5.1 to 5.3

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?
willow_techie
0

Comments

2 comments

Sort by
  • petey
    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.
    petey
    0
  • willow_techie
    a simple restart of sql worked great, thanks.

    finally, all production is on 5.3... :-)
    willow_techie
    0

Add comment

Please sign in to leave a comment.