Installing SQL Backup unattended

Category: Installing & upgrading
Date: 13 Jul 2009
Product: SQL Backup
Versions: 4 through 5.1

In some enterprise environments, it may be desirable to automate the installation of software using tools such as Systems Management Server (SMS) or Active Directory Group Policy. SQL Backup's installation is designed to be interactive, but it can be made to run silently in a way that requires no input from the user.

To install SQL Backup in an unattended, silent fashion, use the following command-line:

SQLBackupSetup /S /V"INSTALLSTOREDPROCEDURE=\"\" /qn"

Please note that this does not install the server components. In order to do this, it is necessary to specify the instance of SQL Server on the local machine, which cannot be done automatically on the command line.

To deploy server components remotely, please use SQBServerSetup.exe. This file is copied to the SQL Backup program folder after a successful client installation. The correct arguments to use would be:

SQBServerSetup /verysilent /sqbminimal /i (instance name) /svcuser (user name) /svcpw (password) /sqluser (user name) /sqlpw (password) /SUPPRESSMSGBOXES

Note that the /sqluser and /sqlpw arguments are only necessary if you want the SQL Backup Agent Service to use SQL Authentication rather than default Windows authentication.

SQL Backup 5.2 and up use a standard MSI, suitable for Active Directory or SMS deployment out of the box. To access it, run the Toolbelt Installer and left-click on the icon in the window titlebar and select "Show Temporary Files". While the Toolbelt Installer is still open, copy and paste this MSI to another folder so that you will have a permanent copy after closing the Toolbelt Installer, which will delete all of the temporary files.

The deployment of the server components using the new installer is identical to the procedure above, by executing SQBServerSetup.exe.