From: tim@server.invalid   
      
   Am 19.04.21 um 22:53 schrieb Erland Sommarskog:   
   > 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.   
   >   
   >   
   And what about users/permissions etc?   
      
   Tim   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)