Wednesday, June 14, 2017

Manage SQL server service on Linux(RHEL)


Check SQL server status

sudo systemctl status mssql-server

Start and Stop service
sudo systemctl stop mssql-server
sudo systemctl start mssql-server
sudo systemctl restart mssql-server


Access error log files

The SQL Server engine logs to the /var/opt/mssql/log

cd /var/opt/mssql/log
cat errorlog

Reset SA password

sudo systemctl stop mssql-server

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

No comments:

Post a Comment

How to add a Database to AlwaysOn Availability Group with four different options

To add a database to an existing AlwaysOn availability group, MS has given us four options to choose from Automatic seeding Full database an...