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

Mass upgrading Red Gate

We have the following problem, we have about 100 instances running that we need to upgrade from version 4.1.0.207 and 4.2.0.511 to 4.6.0.815. 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 ?
BRohrbock
0

Comments

1 comment

Sort by
  • petey
    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
    petey
    0

Add comment

Please sign in to leave a comment.