====== SQL Server in Linux ======

===== Installation =====

^ Distro ^ Instructions ^
| Red Hat | [[https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-red-hat|link]] |
| Suse | [[https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-suse|link]] |
| Ubuntu | [[https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu|link]] |
| Docker | [[https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker|link]] |

===== Server Control =====

**Check status of SQL Server Service**

<code bash>	
systemctl status mssql-server
</code>

**Stop the SQL Server Service**

<code bash>
sudo systemctl stop mssql-server
</code>

**Start the SQL Server Service**

<code bash>
sudo systemctl start mssql-server
</code>

**Restart the SQL Server Service**

<code bash>
sudo systemctl restart mssql-server
</code>

**Disable the SQL Server Service**

<code bash>
sudo systemctl stop mssql-server
 
sudo systemctl disable mssql-server
</code>

**Enable the SQL Server Service**

<code bash>
sudo systemctl enable mssql-server
 
sudo systemctl start mssql-server
</code>

(You can get a script to simplify these commands [[https://github.com/jfcarr/shell-scripts/blob/master/ssctrl.sh|here]].)
===== Log Files =====

^ Type ^ Location ^
| SQL Server engine | /var/opt/mssql/log/errorlog |
| Installer | /var/opt/mssql/setup-< time stamp representing time of install> |

Log files are UTF-16 encoded.  If needed (e.g., for 'more' or 'less' commands), you can encode in UTF-8 as follows:

<code bash>
sudo iconv –f UTF-16LE –t UTF-8 <errorlog> -o <output errorlog file>
</code>

{{tag>database}}