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

Mass upgrading Red Gate

BRohrbockBRohrbock Posts: 2
edited August 3, 2007 6:07AM in SQL Backup Previous Versions
We have the following problem, we have about 100 instances running that we need to upgrade from version and to Besides this some of the instances are running on a cluster and since SQB 4 is not cluster aware there's 2 installments for these instances.

Is it possible to just overwrite the DLL of the older versions with the newer version and run DBCC xp_sqlbackup(FREE) ?

Or is it possible to give the installation procedure parameters so the people upgrading don't have to click through all the screens ?


  • Options
    peteypetey Posts: 2,358 New member
    If you prefer to upgrade the minimum of files manually:

    To upgrade the extended stored procedure library:
    - run DBCC xp_sqlbackup(FREE) to release the SQL Backup extended stored procedure library from SQL Server's process space. However, this may not always work on SQL Server 2000 if you have ever ran 2 or more SQL Backup tasks concurrently. You would need to stop the SQL Server service in this case.

    - replace xp_sqlbackup.dll in the SQL Server Binn folder with the later version

    To upgrade the service:
    - stop the SQL Backup Agent service

    - replace SQBCoreServer.exe in the SQL Backup installation folder with the latest version

    Optional files to upgrade:
    - SQLBackupC.exe, SQLBackup.chm
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.