Restoring mssql .bak file Linux mssql server

To restore a mssql database backup to a linux host, using default microsoft install locations: /opt/mssql-tools/bin/sqlcmd -S hostname -U user -P Password! -Q "RESTORE DATABASE [mydatabase] FROM DISK = N'/tmp/backupStandard.bak' WITH FILE = 1, NOUNLOAD, REPLACE, NORECOVERY, STATS = 5" If you see an error…

Installing MS-SQL on CentOS 7

This setup is using an instance within Google Cloud Platform's Compute Engine, but it should work about anywhere running CentOS 7+. I added this here because I needed to try mssql on Centos, an unsupported distro. Other howto's online I found did not work, or did not completely set it…