반응형
Environment variables
Environment variableDescription
ACCEPT_EULA | Set the ACCEPT_EULA variable to any value to confirm your acceptance of the End-User Licensing Agreement. Required setting for the SQL Server image. |
MSSQL_SA_PASSWORD | Configure the SA user password. The SA_PASSWORD environment variable is deprecated. Please use MSSQL_SA_PASSWORD instead. |
MSSQL_PID | Set the SQL Server edition or product key. Possible values include: Evaluation Developer Express Web Standard Enterprise A product key If specifying a product key, it must be in the form of #####-#####-#####-#####-#####, where '#' is a number or a letter. |
MSSQL_LCID | Sets the language ID to use for SQL Server. For example 1036 is French. |
MSSQL_COLLATION | Sets the default collation for SQL Server. This overrides the default mapping of language ID (LCID) to collation. |
MSSQL_MEMORY_LIMIT_MB | Sets the maximum amount of memory (in MB) that SQL Server can use. By default, it's 80% of the total physical memory. |
MSSQL_TCP_PORT | Configure the TCP port that SQL Server listens on (default 1433). |
MSSQL_IP_ADDRESS | Set the IP address. Currently, the IP address must be IPv4 style (0.0.0.0). |
MSSQL_BACKUP_DIR | Set the Default backup directory location. |
MSSQL_DATA_DIR | Change the directory where the new SQL Server database data files (.mdf) are created. |
MSSQL_LOG_DIR | Change the directory where the new SQL Server database log (.ldf) files are created. |
MSSQL_DUMP_DIR | Change the directory where SQL Server will deposit the memory dumps and other troubleshooting files by default. |
MSSQL_ENABLE_HADR | Enable Availability Group. For example, '1' is enabled, and '0' is disabled |
MSSQL_AGENT_ENABLED | Enable SQL Server Agent. For example, 'true' is enabled and 'false' is disabled. By default, agent is disabled. |
MSSQL_MASTER_DATA_FILE | Sets the location of the master database data file. Must be named master.mdf until first run of SQL Server. |
MSSQL_MASTER_LOG_FILE | Sets the location of the master database log file. Must be named mastlog.ldf until first run of SQL Server. |
MSSQL_ERROR_LOG_FILE | Sets the location of the errorlog files. |
* 한글 Language & collation
MSSQL_LCID=1042
한국어(한국어 사전 정렬) | 0x0412 | 0x0412 | Korean_Wansung_CI_AS |
반응형
'Database > MS SQL' 카테고리의 다른 글
[docker] MS SQL SERVER 2022 docker /opt/mssql/bin/permissions_check.sh: line 4: [: : integer expression expected (0) | 2023.04.12 |
---|---|
SQL Server 2017 Graph Good & Bad (0) | 2018.05.24 |
SQL Server 2017 JDK 9 설치 안됨.(Polybase) (0) | 2018.03.14 |
Updatable Transaction replication Error 20515 20512 (0) | 2015.04.08 |
SQL Server Service Starting 상태 Kill (0) | 2015.04.06 |