Installing SQL Backup server components unattended

Category: Installing and upgrading
Date: 22 May 2012
Product: SQL Backup
Versions: 5.2 and later

To install the SQL Backup server components, run SQBServerSetup.exe. This file is copied to the SQL Backup program folder (%Program Files%\Red Gate\SQL Backup <version number> for 32-bit servers, %Program Files (x86)%\Red Gate\SQL Backup <version number> for 64-bit servers) when the SQL Backup user interface is installed.

To install the server components unattended, call SQBServerSetup.exe from the command line with /VERYSILENT and /SUPPRESSMSGBOXES. For example:

SQBServerSetup.exe /VERYSILENT /SUPPRESSMSGBOXES

The server components will be installed on the local instance using the default settings unless you specify otherwise using the parameters described below.

SQL Backup server components installation parameters

`/VERYSILENT`	Performs an installation without launching the SQL Backup (server components) Setup wizard. All the values that would normally be entered in the wizard must be defined at the command line, otherwise the default values will be used. Use in combination with `/SUPPRESSMSGBOXES`.
`/SUPPRESSMSGBOXES`	Suppresses any warning or information boxes that would appear. No information will be returned if an error arises. Use in combination with `/VERYSILENT`.
`/I <instance>`	Specifies the instance to install on. If this parameter is not specified, the default instance is used. Do not specify more than one instance.
`/PATH <folder>`	Installs the server components in the specified directory. When installing on a cluster, the directory can be a shared drive. If this parameter is not specified, the server components are installed in the default location (%Program Files%\Red Gate\SQL Backup <version number>\<instance name> on 32-bit machines and %Program Files (x86)%\Red Gate\SQL Backup <version number>\<instance name> on 64-bit machines).
`/SVCUSER <name> \| <enc_name>`	Specifies the user account used to log on to the SQL Backup Agent service (the startup account). Use either clear-text or an encrypted format. If this parameter is not specified, the account the SQL Server instance is currently running as is used. For details of the permissions required by the startup account, see Security Model.
`/SVCPW <pass> \| <enc_pass>`	Specifies the password for the user account used to log on to the SQL Backup Agent service (the startup account). Use either clear-text or an encrypted format. Must be used with `/SVCUSER`.
`/SQLUSER <name> \| <enc_name>`	Specifies that the SQL Backup Agent service should connect to the SQL Server using the specified SQL Server authenticated account. Use either clear-text or an encrypted format. If this parameter is not specified, Windows authentication is used. For details of the permissions required by the SQL Server authenticated account, see Security Model.
`/SQLPW <pass> \| <enc_pass>`	Specifies the password for the specified SQL Server authenticated account. Use either clear-text or an encrypted format. Must be used with `/SQLUSER`.
`/DATAPATH <folder>`	Specifies the location in which the SQL Server Compact database is created. The SQL Server Compact database stores SQL Backup backup and restore information. If this parameter is not specified, the Compact database is created in the default location: %ProgramData%\Red Gate\SQL Backup\Data (Windows Vista, Windows 2008 and later) or %ALLUSERSPROFILE%\Application Data\Red Gate\SQL Backup\Data (Windows XP and Windows 2003).
`/LOGPATH <folder>`	Specifies the location in which the SQL Backup logs are stored. SQL Backup creates a log for each backup or restore process it runs. If this parameter is not specified, the logs are stored in the default location: %ProgramData%\Red Gate\SQL Backup\Log (Windows Vista, Windows 2008 and later) or %ALLUSERSPROFILE%\Application Data\Red Gate\SQL Backup\Log (Windows XP and Windows 2003).
`/CLUSTERINSTALL`	Installs SQL Backup server components as a clustered service. SQL Server must be installed as a clustered resource on the host machine.
`/CLUSTERUSER <name> \| <enc_name>`	Specifies the user name of the user that the installer will run as for clustering registration. Use either clear-text or an encrypted format. Use in combination with `/CLUSTERINSTALL`.
`/CLUSTERPW <pass> \| <enc_pass>`	Specifies the password of the user that the installer will run as for clustering registration. Use either clear-text or an encrypted format. Must be used with `/CLUSTERUSER`.
`/CLUSTERNODE`	Specifies a cluster-based install on a secondary node (rather than the primary node). The server components will not be installed on other nodes in the cluster.
`/LOG`	Writes information from the installation to a log file, which can be found in %TEMP% as "Setup Log yyyy-mm-dd #nnn.txt"
`/EXITCODEFILE <file>`	Logs the outcome of the installation to the specified text file using the exit codes listed below.

Example 1

The following command installs SQL Backup server components in the default location on the local instance, specifies the account the SQL Backup Agent service should run as, and specifies that it should use SQL Server authentication to connect to the local instance (the specified accounts should have sysadmin privileges):

SQBServerSetup.exe /VERYSILENT /SUPPRESSMSGBOXES /SVCUSER "user name" /SVCPW "password" /SQLUSER "user name" /SQLPW "password"

Note that the /SQLUSER and /SQLPW parameters are only necessary if you want the SQL Backup Agent service to connect to the SQL Server instance using SQL authentication rather than Windows authentication.

Example 2

The following command installs SQL Backup server components on the SQL2008 server in D:\SQLBackup\ServerComponents, specifies the locations of the data and log stores (D:\SQLBackup\ServerComponents\SQBData and D:\SQLBackup\ServerComponents\SQBLog respectively), and specifies the account the SQL Backup Agent service should run as:

SQBServerSetup.exe /verysilent /SUPPRESSMSGBOXES /i (SQL2008) /Path D:\SQLBackup\ServerComponents /DATAPATH D:\SQLBackup\ServerComponents\SQBData /LOGPATH D:\SQLBackup\ServerComponents\SQBLog /svcuser "SQLBACKUPsERVICEUSER" /svcpw "password"

The SQL Backup Agent Service will connect to the SQL Server using the Windows authentication of the startup account, because SQL Server authentication has not been specified.

SQL Backup Exit Codes


Exit Code	Definition
0	Installation was successful
Pre-installation Failures
5	Another installation is in progress. Try again later.
6000	Current user has insufficient permissions to modify Windows Services.
6010	Windows 2003 Itanium edition requires SP1 to be installed before installing SQL Backup server components.
6020	The user account specified for the SQL Backup Agent service to log on as could not be verified.
6030	The user account specified for the SQL Backup Agent service to log on as was ambiguous. Ensure the account details are fully qualified.
6040	The password for the SQL Backup Agent service user account was invalid.
6100	The user account specified for the SQL Backup Agent service to log on as does not have permission to log on as a service.
6110	Unable to grant 'log on as a service' rights.
6200	SQL authenticated user name or password is invalid.
6210	SQL authenticated account is not a member of the sysadmin role.
Post-installation failures
8192	SQL Backup Agent service executable (SQBCoreService.exe) is not installed.
16384	The version of the SQL Backup Agent service is incorrect.
32768	The SQL Backup Agent service could not be registered correctly.
65536	The SQL Backup Agent service was unable to start within 1 minute.
131072	The SQL Backup extended stored procedure dynamic-link library (xp_sqlbackup.dll) was not installed correctly.
262144	The version of the SQL Backup extended stored procedure dynamic-link library (xp_sqlbackup.dll) is incorrect.
524288	Unable to confirm that the SQL Backup extended stored procedure dynamic-link library (xp_sqlbackup.dll) was registered correctly (connection error).
1048576	Some SQL Backup extended stored procedures were not registered correctly.
2097152	The installer could not set the SQL Backup Agent service's instance (-I) flag.

The exit codes can be combined to form a bitmask. For example, a value of 278528 would mean that the versions of the SQL Backup Agent service and the SQL Backup extended stored procedure dynamic-link library are incorrect.

You may find this Simple Talk article about installing SQL Backup on multiple servers using SQL Multiscript useful.

Was this article helpful?

Search support