title: Cannot restore mssql database because .mdf file is missing
body: <p>I am trying to backup a database from SqlServer 2014 (in Windows 10 OS) and restore it to SqlServer 2017 (in Ubunutu 18.04 Digital Ocean).</p>
  
  <p>I'm used the following SQL Command to Backup:</p>
  
  <pre><code>USE [master]
  GO
  BACKUP DATABASE [SampleDb] TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Backup\SampleDb.bak' WITH CHECKSUM, COPY_ONLY, FORMAT, INIT, STATS = 10;
  </code></pre>
  
  <p>I'm trying to use the following SQL Command to Restore:</p>
  
  <pre><code>RESTORE DATABASE [SampleDb] FROM DISK = '/home/faizan/SampleDb.bak' WITH CHECKSUM, MOVE 'SampleDb_Data' TO '/home/faizan/SampleDb_Data.mdf', MOVE 'SampleDb_Log' TO '/home/faizan/SampleDb_log.ldf', RECOVERY, REPLACE, STATS = 10;
  </code></pre>
  
  <p>However, I'm getting the following error in my Ubuntu server when I try to restore the database:
  <a href="https://i.stack.imgur.com/BqcjW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BqcjW.png" alt="Error message"></a></p>
  
  <p>When I ran the following Command to check the status of the .mdf and .ldf files,</p>
  
  <pre><code>RESTORE FILELISTONLY FROM DISK = '/home/faizan/SampleDb.bak'
  </code></pre>
  
  <p>I get the following result:
  <a href="https://i.stack.imgur.com/A6ejV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/A6ejV.png" alt="enter image description here"></a></p>
  
  <p>I am an ubuntu newbie and I don't see an mdf file here at all. And when I try to restore without the mdf file I get an error.</p>
  
  <p>So how do I restore this Mssql backup in ubuntu when the .mdf file is missing?</p>
  
  <p>(Extra note: The SampleDb.mdf file is present in Windows 10, in C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA, it just doesnt get transfered to Ubuntu)</p>