From: esquel@sommarskog.se   
      
   Tim Ritberg (tim@server.invalid) writes:   
   > Can't login today. The server instance is a Linux MsSQL 15.   
   > On Desktop is a (Express) SQL Server 2016 SP1.   
   >   
      
   So the server is of a later version that the the Express instance. That's   
   good, because then you can use BACKUP/RESTORE.   
      
   BACKUP DATABASE db TO DISK = 'C:\temp\backup.bak' WITH INIT   
      
   And then on the server:   
      
   RESTORE DATABASE db FROM DISK = '/path/backup.bak'   
   WITH MOVE 'db' TO '',   
        MOVE 'db_log' TO ''   
      
   When it comes to the names that follow MOVE, these are the logical names of   
   the devices. They often follow the pattern shown here, but this is not   
   always the case. Run sp_helpdb on the database on the source server to   
   see the names. They are in the first column of the second result set.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)