CATCHV Blog

[SQL SERVER] SQL SERVER DOCKER 설치 ENV 변수 본문

Database/MS SQL

[SQL SERVER] SQL SERVER DOCKER 설치 ENV 변수

catchv 2023. 4. 7. 08:34
반응형

https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-configure-environment-variables?view=sql-server-2017 

 

Configure environment variables for SQL Server on Linux - SQL Server

This article describes how to use environment variables to configure specific SQL Server settings on Linux.

learn.microsoft.com

 

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 

https://learn.microsoft.com/ko-kr/sql/relational-databases/collations/collation-and-unicode-support?view=sql-server-ver16 

 

데이터 정렬 및 유니코드 지원 - SQL Server

SQL Server의 데이터 정렬 및 유니코드 지원에 대해 알아봅니다.

learn.microsoft.com

한국어(한국어 사전 정렬) 0x0412 0x0412 Korean_Wansung_CI_AS

반응형
Comments