Ubuntu上SQL Server更新和维护指南

?Ubuntu??????SQL Server??????,?????????????????????????????????:

??SQL Server

1. ??????:

• ?????????2 GB?
• ????XFS?EXT4?????
• 6 GB??????
• x64???,????????,?????2 GHz?

2. ???????GPG??:

wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo tee /etc/apt/trusted.gpg.d/microsoft.asc

3. ??SQL Server Ubuntu???:

??SQL Server 2022:

sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/20.04/mssql-server-2022.list)"

??SQL Server 2019:

sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/18.04/mssql-server-2019.list)"

4. ??SQL Server:

sudo apt-get update
sudo apt-get install -y mssql-server

5. ??SQL Server:

sudo /opt/mssql/bin/mssql-conf setup

??????????????SA???

??SQL Server

???SQL Server?????,????????:

sudo apt-get update
sudo apt-get install -y mssql-server

??SQL Server

1. ??SQL Server??:

sudo /opt/mssql/bin/mssql-conf set sqlagent.enabled true
sudo systemctl restart mssql-server

2. ?????????????:

??filelocation.defaultdatadir?filelocation.defaultlogdir????????????????????

sudo mkdir /home/d/mssql/data
sudo chown mssql /home/d/mssql/data
sudo chgrp mssql /home/d/mssql/data

3. ????:

• ??/etc/security/limits.d/mssql-server.conf??,???????????????
• ??tuned-master???????????

??????

• ??:error while loading shared libraries: liblber-2.4.so.2:

  ????:????libldap-2.4-2_2.4.47+dfsg.4-1+eagle_amd64??

  wget https://community-packages.deepin.com/deepin/pool/main/o/openldap/libldap-2.4-2_2.4.47+dfsg.4-1+eagle_amd64.debs
  sudo dpkg -i libldap-2.4-2_2.4.47+dfsg.4-1+eagle_amd64.deb
  

• ??:error while loading shared libraries: libssl1.1:

  ????:????libssl1.1_1.1.1-1ubuntu2.1~18.04.23_amd64??

  wget http://security.ubuntu.com/ubuntu/pool/main/o/openssl/libssl1.1_1.1.1-1ubuntu2.1~18.04.23_amd64.debs
  sudo dpkg -i libssl1.1_1.1.1-1ubuntu2.1~18.04.23_amd64.deb
  

????Ubuntu?????????SQL Server?????????,????????SQL Server????????????????????Microsoft???????????????