Installing the server components on a SQL Server instance
Published 23 March 2017
You can install the SQL Backup Pro server components on a SQL Server instance in two ways:
Usually, using the SQL Backup Pro GUI is the easiest way to install the server components. You may prefer to install the server components manually if your SQL Server security doesn't allow you to install remotely, or if you want to choose the location of the SQL Backup Pro files.
You should install the server components manually if:
- you're installing on a SQL Server cluster. See Installing the server components on a SQL Server cluster.
Installing the server components using the GUI
- Open the SQL Backup Pro graphical user interface.
In the Registered SQL Servers pane, select the SQL Server instance you want to install the server components on. One of the following icons should be displayed:
Indicates that the SQL Backup Pro server components aren't installed on the SQL Server. Indicates that the SQL Backup version 4 (or earlier) server components are installed on the SQL Server. You must upgrade the server components to use SQL Backup Pro 9 with this SQL Server instance. For more information, see Upgrading the server components. Indicates that the SQL Backup Pro server components are installed and licensed on this SQL Server, but the version of the server components isn't up to date compared with your version of the graphical user interface. For more information, see Upgrading the server components. If the SQL Server instance isn't listed, add the SQL Server instance with which you want to use SQL Backup Pro. For more information, see Adding SQL Server instances.- Click the icon, or from the Actions menu, select Install or Upgrade Server Components.
The Install Server Components wizard is displayed, showes the version of the server components you're about to install.
Click Next to proceed to step 2 of the wizard:
- If you're installing on a local machine, specify the account the SQL Backup Agent service will log on as (the startup account) and the authentication mode the service will use to connect to the SQL Server instance. For details of the permissions required by the SQL Backup Agent service startup account, see Permissions.
- If you're installing on a remote machine, specify:
A domain or built-in account for SQL Backup Pro to access the machine running the SQL Server instance and install the server components. The account must be an administrator on that machine.
It's not possible to install the server components on a remote machine using a local administrator account that isn't a built-in account.- The account the SQL Backup Agent service will log on as (the startup account) and the authentication mode the service will use to connect to the SQL Server instance. For details of the permissions required by the SQL Backup Agent service startup account, see Permissions.
- Click Finish to start the installation. A message dialog box shows the progress of the installation process. The server components are installed in the default location:
- %ProgramFiles%\Red Gate\SQL Backup 9\<instance name> on 32-bit machines
- %ProgramFiles(x86)%\Red Gate\SQL Backup 9\<instance name> on 64-bit machines
- If you're installing the server components for the first time, a 14 day trial of SQL Backup Pro will be started, during which you can evaluate the product. This is indicated by the trial icon . You can activate the server components with a SQL Backup Pro license at any point. For more information, see Activating.
Installing the server components manually
You may wish to install SQL Backup Pro on your SQL Server instances manually using the SQBServerSetup.exe executable if your SQL Server security doesn't allow you to install remotely, or if you want to customize the installation.
To install the server components manually:
- Copy SQBServerSetup.exe from your SQL Backup Pro installation folder to the server you want to install the components on. By default, for 32-bit servers the installation folder is %ProgramFiles%\Red Gate\SQL Backup 9; for 64-bit servers it is %ProgramFiles(x86)%\Red Gate\SQL Backup 9.
- Run SQBServerSetup.exe from the server. The Setup wizard guides you through the installation process. You can specify:
- The instance you want to install the server components on.
- The folder in which you want to install the server components. By default this is %ProgramFiles%\Red Gate\SQL Backup 9\<instance name> on 32-bit systems and %ProgramFiles(x86)%\Red Gate\SQL Backup 9\<instance name> on 64-bit systems.
- The startup account for the SQL Backup Agent service application. For details of the permissions required by the SQL Backup Agent service startup account, see Permissions.
- The authentication method the SQL Backup Agent service startup account uses to connect to the SQL Server.
- The folder in which you want to install files relating to the SQL Server Compact database, which SQL Backup Pro uses to store information about backup and restore operations. By default this is:
- %PROGRAMDATA%\Red Gate\SQL Backup\Data\<instance name> (Windows Vista, Windows 2008 and later), or
- %ALLUSERSPROFILE%\ Application Data\Red Gate\SQL Backup\Data\<instance name> (Windows XP and Windows 2003).
- The folder in which you want to store SQL Backup Pro activity log files. SQL Backup Pro creates a log for each backup or restore process it runs. By default this is:
- %PROGRAMDATA%\Red Gate\SQL Backup\Log\<instance name> (Windows Vista, Windows 2008 and later), or
- %ALLUSERSPROFILE%\ Application Data\Red Gate\SQL Backup\Log\<instance name> (Windows XP and Windows 2003).
- Use the SQL Backup Pro GUI to activate SQL Backup Pro on the SQL Server instances as required. For more information, see Activating.
For information on installing SQL Backup Pro unattended using the command line, see Installing the server components from the command line.
The SQL Backup Pro server components comprise:
SQBCoreService.exe | The SQL Backup Agent service application. |
xp_sqlbackup.dll | The SQL Backup Pro extended stored procedure dynamic-link library. This will be located in a subfolder called Win32, x64 depending on the SQL Server version. |
SQLBackupC.exe | The SQL Backup Pro command line interface. |
zlib1.dll,libeay32.dll, ssleay32.dll | The compression library used by SQBCoreService.exe and SQLBackupC.exe |
SQBHostedStorageClient.exe,AWSSDK.dll, RedGate.Shared.SQL.dll, RedGate.Shared.Utils.dll | The SQL Backup Pro command line utility for uploading backup files to an Amazon S3 Bucket. |
SQBHostedStorageClient.exe.config | The configuration file for SQBHostedStorageClient.exe |
RedGate.BackupReader.CryptoHelper.dll,RedGate.BackupReader.dll,RedGate.BackupReader.SqbReader.dll | The SQL Backup Pro Reader dynamic-link library. |
SQBShellExt.dll | The SQL Backup Pro Windows shell extension library. This will be located in %ProgramFiles%\Common Files\Red Gate\SQL Backup or %ProgramFiles(x86)%\Common Files\Red Gate\SQL Backup. |
SQBShellExt.reg | The registry information used to register the SQL Backup Pro shell extension. This will be located in %ProgramFiles%\Common Files\Red Gate\SQL Backup or %ProgramFiles(x86)%\Common Files\Red Gate\SQL Backup. |