Installing or upgrading on a SQL Server instance

You can install or upgrade the SQL Backup server components on a SQL Server instance in two ways:

• using the SQL Backup GUI
• installing manually

Usually, using the SQL Backup GUI is the easiest way to install or upgrade the server components. However, if you are installing or upgrading the server components on a SQL Server 2012 instance, you are recommended to use manual installation. See Installing or upgrading server components on SQL Server 2012 for more information.

You may also prefer to install the server components manually if your SQL Server security does not allow you to install remotely, or if you want to choose the location of the SQL Backup files.

Note that version 6 of SQL Backup introduced changes to the SQL Backup file format (.sqb). To restore backup files created by SQL Backup 6 or 7 using an earlier version of SQL Backup, you must use the SQL Backup File Converter to convert the files first. When upgrading to version 7 of the server components, we recommend that you upgrade all SQL Server instances to maintain compatibility.

Installing or upgrading server components using the GUI

1. Start the graphical user interface.
2. If the SQL Server instance is not listed, add the SQL Server instance with which you want to use SQL Backup.

   The SQL Server instance is displayed in the Registered SQL Servers pane. If one of the following icons is displayed to the right of the name of the SQL Server instance, you can install or upgrade the server components on the SQL Server:

   	SQL Backup is installed and activated on this SQL Server, but the version of server components is not up-to-date compared with your version of the graphical user interface. Move the mouse pointer over the icon for further information: You can continue to use SQL Backup with this SQL Server instance without upgrading. However, you are recommended to upgrade to get the latest features, enhancements and bug fixes. This icon does not show you when new versions of SQL Backup become available for download; you can use Check for updates for this.
   	SQL Backup version 4 (or earlier) server components are installed on the SQL Server. You must upgrade the server components to use SQL Backup 7 with this SQL Server instance.
   	You have not installed the SQL Backup server components on the SQL Server. You must install the server components to use SQL Backup 7 with this SQL Server instance.

3. Click the icon, or from the Actions menu, select Install or Upgrade Server Components.

   If you are installing SQL Backup for the first time on this server, the wizard guides you through the installation process. You will be asked to specify the account details for the SQL Backup Agent service (the startup account) and the authentication mode for the service to connect to the SQL Server instance. See Security Model for more information.

4. Ensure that no other SQL Backup processes are currently running on the SQL Server instance, and 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 7\<instance name> for 32-bit machines or %ProgramFiles (x86)%\Red Gate\SQL Backup 7\<instance name> for 64-bit machines. When upgrading to a new version, the server components remain in the folder they were installed in.

5. When the installation has completed, click Close.

You may also be prompted to install or upgrade the server components when setting up a backup or restore, or configuring log shipping. When you select a server that does not have the SQL Backup server components installed, a warning icon is displayed and you will not be able to click Next to proceed.

Click the Install Server Components link to install the components.

Installing or upgrading server components manually

You may wish to install or upgrade SQL Backup on your SQL Server instances manually using the SQBServerSetup.exe executable if your SQL Server security does not allow you to install remotely, or if you want to customize the installation.

The server components of SQL Backup comprise:

To install these files manually:

1. Copy SQBServerSetup.exe from your SQL Backup installation folder to the server on which you want to install the components.

   By default, for 32-bit servers the installation folder is %Program Files%\Red Gate\SQL Backup 7; for 64-bit servers it is %Program Files (x86)%\Red Gate\SQL Backup 7.

2. Run SQBServerSetup.exe from the server. The Setup wizard guides you through the installation process. You can specify:
   • the instance on which you want to install the server components
   • the folder in which you want to install the server components
   • the startup user for the SQL Backup Agent Service application
   • the authentication method to be used for the SQL Server
   • the folder in which you want to create the SQL Backup data store
   • the folder in which you want to store SQL Backup log files
   • the folder in which you want to install files relating to the SQL Server Compact database (SQL Backup uses a SQL Server Compact database to store information about backup and restore operations)

   Note that SQBShellExt.dll and SQBShellExt.reg are always installed in %Program Files%\Common Files\Red Gate\SQL Backup for 32-bit versions of Windows (Win32), or %Program Files (x86)%\Common Files\Red Gate\SQL Backup for 64-bit versions of Windows (x64 and Itanium).

3. Use the SQL Backup GUI to activate SQL Backup on the SQL Server instances as required.

Note: When upgrading to a later version, it is not possible to change the location the server components are installed in. To install the server components in a different location, first uninstall the current server components, then install the new server components, specifying the path.

For information on installing SQL Backup unattended using the command line, see Installing SQL Backup server components unattended.