Mass upgrading Red Gate

BRohrbock

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 ?

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