Silently installing Data Protection for SQL Server with the setup program

You can use the setup program (setup.exe) to silently install Data Protection for SQL Server. If you are protecting Microsoft SQL Server 2012 and later versions, you can also use the setup program to silently install Data Protection for SQL Server on Windows Server Core.

Before you begin

If you want to install Data Protection for SQL Server on Windows Server Core, first install the IBM Spectrum Protect™ client on the same computer as Data Protection for SQL Server.
The Data Protection for SQL Server Management Console and Data Protection for SQL Server must be installed from an account that is a member of the local Administrators group for the system on which the SQL Server is running.

About this task

The Data Protection for SQL Server setup program is on the installation media (where x: is your DVD drive):

(32-bit) x:\fcm\x86\sql\7140\enu\setup.exe
(64-bit) x:\fcm\x64\sql\7140\enu\setup.exe

Procedure

Issue the following command to silently install both Data Protection for SQL Server components to the default installation directory:
```
x:\fcm\aaa\sql\7140\enu\setup.exe /s /v/qn
```
where x: is your DVD drive and aaa is either x64 or x86. The following command is an example.
```
x:\fcm\x64\mmc\4140\enu\setup.exe /s /v/qn
x:\fcm\x64\sql\7140\enu\setup.exe /s /v/qn
```
where x: is your DVD drive.

The following examples are commands that specify the target directory, the features, start suppression, and logging. Specify each command on a single line from a Run as Administrator command prompt window.

x:\fcm\x64\mmc\4140\enu\setup.exe /s /v"INSTALLDIR=\"C:\Program Files\Tivoli\" 
ADDLOCAL=\"Client\" TRANSFORM=1033.mst REBOOT=ReallySuppress /qn /l*v 
\"C:\Temp\DpSqlMmcSetupLog.txt\""

x:\fcm\x64\sql\7140\enu\setup.exe /s /v"INSTALLDIR=\"C:\Program Files\Tivoli\tsm\"
ADDLOCAL=\"Client\" TRANSFORM=1033.mst REBOOT=ReallySuppress /qn /l*v 
\"C:\Temp\DpSqlSetupLog.txt\""

Review these guidelines as you complete the installation process:
- You must place a backslash (\) before each quotation mark that is within an outer set of quotation marks (").
- For a single-line command, press Enter only when all the parameters are entered.
- You must place quotation marks (") around the following text:
  - A directory path that contains spaces.
  - An argument that specifies multiple features. Although you must use quotation marks around the complete argument, you must still place a backslash before each internal quotation mark.
- All features that are listed in a custom installation must be listed after the addlocal option.
- Setting the rebootyesno option to No applies only to the installation of the Data Protection for SQL Server software. The installation package includes a number of prerequisites that is installed by Data Protection for SQL Server. Ensure that all the prerequisites are installed before starting the silent installation, then set the rebootyesno option to No so that no system restart is required after the silent installation process finishes.