SQL Server is a popular database management system. However, if you are facing performance issues with, or if you don’t need it anymore, then you may need to uninstall SQL Server from your system. In this article, we will learn how to uninstall SQL server in Ubuntu.
How to Uninstall SQL Server in Ubuntu
Here are the steps to uninstall SQL Server in Ubuntu.
1. Check SQL Server Status
Open terminal and run the following command to check SQL server status.
# sudo systemctl status mssql-server
If the output of above command shows Active: active (running) then it means SQL server is running on your system.
2. List Log and Data Files
You can run the following commands to view the content of data and log files of SQL Server.
# cd /var/opt/mssql/data # ls -lrt
3. Uninstall SQL Server Service
Before you uninstall MSSQL, make sure you have taken backup of your SQL Server database. Run the following command to stop SQL Server.
$ sudo service mssql-server stop
Run the following command to uninstall SQL Server.
$ sudo apt-get remove mssql-sever
If you see any prompts during the process, enter ‘Y’ to proceed. The above command will read the package list and build dependence tree.
4. Verify Uninstallation
Run the following command to verify uninstallation.
$ sudo systemctl status mssql-server
This time you should see the following two lines in the output.
Loaded: not-found (Reason: No such file or directory) Active: inactive (dead)
5. Remove Log & Data Files
Please note that the above uninstallation removes only the software installation files but not the log files or data files. Run the following command to remove log and data files.
$ sudo rm -rf /var/opt/mssql
In the above command -r option recursively removes subfolders & their contents. -f option ignores nonexistent arguments and removes files forcefully.
How to Install or Upgrade Software from Unsupported Releases
Shell Script to Check if Script is Already Running
How to Check if Input Argument Exists in Shell Script
How to Check if Variable is Empty or Not in Shell Script
How to Check if File Exists in Shell Script