Changing Data Protection for SQL Server configuration values on Windows Server Core

To configure preferences for Data Protection for SQL Server, use the set command at the Windows Server Core command prompt.

About this task

The values that you change are saved in the Data Protection for SQL Server configuration file. The default configuration file is tdpsql.cfg.

Procedure

At the command prompt, enter the following command:

tdpsqlc set parameter=value [/configfile=filename]

where parameter is the Data Protection for SQL Server parameter or option for which you want to change the value, and value is the new value that you want to specify. /configfile is the optional parameter for the configuration file name. If you do not specify the /configfile parameter, the default configuration file (tdpsql.cfg) is used.

Examples:

Task

Set the preferred SQL Server in the tdpsql.cfg file.

Command: tdpsqlc set sqlserver=your_SQL_instance /configfile=tdpsql.cfg

Command: tdpsqlc set fromsqlserver=your_SQL_instance /configfile=tdpsql.cfg

Task

Change the name of the Data Protection for SQL Server activity log file to tdpsql.log.

Command: tdpsqlc set logfile=tdpsql.log