To restore the MSSQL database on linux hosted MSSQL Server follow the following steps:
The following steps requires that you install MSSQL server in you linux OS. If not installed please follow this guide to install the server.
After installing the MSSQL server and its command tools,
Step 1: Prepare
Move the .bak file (i.e. the backup file of the MSSQL database) into mssql opt backup folder.
$ sudo mv yourpath/yourdb.bak /var/opt/mssql/backup
Step 2: Reconnaissance
Get the names of the files compacted in the .bak file
$ sqlcmd -U yourMsSQLUSername -P password > RESTORE FILELISTONLY FROM DISK = '/var/opt/mssql/backup/yourdb.bak' > GO
Check the logical names and the physical names ending with .mdf and .ldf
So now we have everything we need to backup the MSSQL database. Then to backup the database.
Step 3 : Restore
Then restore with following command
> RESTORE DATABASE NewDatabaseName > FROM DISK = '/var/opt/mssql/backup/yourdb.bak' > WITH MOVE 'logical_name_for_mdf' to '/var/opt/mssql/data/logical_name.mdf' > MOVE 'logical_name_for_ldf' to '/var/opt/mssql/data/logical_name.ldf' > GO