【SQLServer】SQLServer2017安装部署过程

关闭防火墙、selinux、挂载磁盘等

这里省略…

部署及配置

可参考官网配置文档：https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configure-mssql-conf?view=sql-server-2017#change-the-default-error-log-file-directory-location
可参考官网部署文档：https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-red-hat?view=sql-server-ver15

安装部署

sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2017.repo

yum install -y mssql-server
/opt/mssql/bin/mssql-conf setup (然后根据提示操作即可)

ps -ef | grep mssql

配置默认数据和日志目录

chown mssql. /mnt/data1/ -R
/opt/mssql/bin/mssql-conf set filelocation.defaultdatadir /mnt/data1/data
/opt/mssql/bin/mssql-conf set filelocation.defaultlogdir /mnt/data1/logs
systemctl restart mssql-server.service
mkdir /mnt/data1/masterdatabasedir
chown mssql. /mnt/data1/ -R

更改默认master文件默认位置

/opt/mssql/bin/mssql-conf set filelocation.masterdatafile /mnt/data1/masterdatabasedir/master.mdf
/opt/mssql/bin/mssql-conf set filelocation.masterlogfile /mnt/data1/masterdatabasedir/mastlog.ldf
systemctl stop mssql-server
mv /var/opt/mssql/data/master.mdf /var/opt/mssql/data/mastlog.ldf /mnt/data1/masterdatabasedir/
sudo systemctl start mssql-server

更改默认转储目录位置

mkdir /mnt/data1/dump
chown mssql. /mnt/data1/ -R
/opt/mssql/bin/mssql-conf set filelocation.defaultdumpdir /mnt/data1/dump
systemctl restart mssql-server

更改默认的错误日志文件目录位置

mkdir /mnt/data1/err_log
chown mssql. /mnt/data1/ -R
/opt/mssql/bin/mssql-conf set filelocation.errorlogfile /mnt/data1/err_log/errorlog
systemctl restart mssql-server

更改默认备份目录位置

mkdir /mnt/data1/backup
chown mssql. /mnt/data1/ -R
/opt/mssql/bin/mssql-conf set filelocation.defaultbackupdir /mnt/data1/backup
systemctl restart mssql-server

客户端工具连接

/opt/mssql-tools/bin/sqlcmd -S localhost -U sa
密码：Abc!@#135