linux下的sql server日常管理

环境:
OS:Centos 7
DB:sql server 2017

 

1.数据存放目录:
[root@cdc-henan-cdhworker02 data]# pwd
/var/opt/mssql/data

 

2.登录查询(必须输入go):
sqlcmd -S localhost -U sa -P 'Aa123456'

1> SELECT Name from sys.databases;
2> go
1> select @@VERSION
2> go

 

3.查看是否安装过sql server
[root@cdc-henan-cdhworker02 data]# rpm -qa | grep mssql
mssql-server-14.0.3192.2-2.x86_64
mssql-tools-17.3.0.1-1.x86_64

 

4.查看启动状态
systemctl status mssql-server