Ubuntu下 SQL Server 的更新与维护实操指南
一 更新与升级流程
sudo apt update && sudo apt upgrade -ywget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo tee /etc/apt/trusted.gpg.d/microsoft.ascsudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/20.04/mssql-server-2022.list)"sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/20.04/mssql-server-2019.list)"sudo apt-get update && sudo apt-get install -y mssql-serversudo apt-get update && sudo apt-get install -y mssql-serversudo systemctl restart mssql-serversystemctl status mssql-server --no-pagersqlcmd -S localhost -E -Q "SELECT @@VERSION, SERVERPROPERTY('ProductLevel')"。二 日常维护要点
sqlcmd -S localhost -E -Q "BACKUP DATABASE [YourDB] TO DISK = N'/var/opt/mssql/backup/YourDB.bak' WITH INIT, COMPRESSION"。sudo /opt/mssql/bin/mssql-conf set sqlagent.enabled true && sudo systemctl restart mssql-serverUPDATE STATISTICS [Schema].[Table];sudo ufw allow 1433 && sudo ufw enablesudo /opt/mssql/bin/mssql-conf set <property> <value>sudo mkdir -p /home/d/mssql/data && sudo chown mssql:mssql /home/d/mssql/datasudo /opt/mssql/bin/mssql-conf set filelocation.defaultdatadir /home/d/mssql/data,重启生效。三 常见问题与排障
sudo systemctl start|stop|restart mssql-serversystemctl status mssql-server --no-pagerlibldap-2.4-2、libssl1.1(按需安装对应版本)四 实践建议