sqlservr

Section: User Commands (1)
Updated: 2017
Index Return to Main Contents

NAME

sqlservr - SQL Server Database Engine

SYNOPSIS

sqlservr

DESCRIPTION

sqlservr is the Microsoft® SQL Server® relational database engine.

ENVIRONMENT VARIABLES

SQL Server supports a number of configuration settings that can be specified via environment variables.

MSSQL_MEMORY_LIMIT_MB

: Memory limit for SQL Server (in megabytes).

MSSQL_TCP_PORT

: TCP port to listen on for database engine connections.

MSSQL_IP_ADDRESS

: IP address to listen on for database engine connections.

MSSQL_DATA_DIR

: Default location for data files.

MSSQL_LOG_DIR

: Default location for log files.

MSSQL_DUMP_DIR

: Default location for crash dump files.

MSSQL_BACKUP_DIR

: Default location for backup files.

MSSQL_NUMBER_ERROR_LOGS

: Number of error log files maintained before cycling.

MSSQL_ENABLE_HADR

: Enable High Availability / Disaster Recovery (HADR) subsystem.

MSSQL_FORCE_ENCRYPTION

: Require TLS encryption on all database engine connections.

MSSQL_TLS_CERTIFICATE_FILE

: Location of certificate file for TLS connections to the database engine.

MSSQL_TLS_KEY_FILE

: Location of key file for TLS connections to the database engine.

MSSQL_TLS_PROTOCOLS

: List of supported TLS protocols.

MSSQL_TLS_CIPHERS

: List of supported TLS ciphers.

MSSQL_LCID

: Default locale ID.

FILES

/var/opt/mssql/mssql.conf

: Configuration file for database engine settings.

/var/opt/mssql/data

: The default location where data files are stored.

/var/opt/mssql/log

: The default location where trace and log files are stored.

ADDITIONAL HELP

Microsoft SQL Server Documentation <URL: https://msdn.microsoft.com/en-us/library/bb545450.aspx >

COPYRIGHT

This document was created by man2html, using the manual pages.
Time: 14:44:50 GMT, May 18, 2024