Tim Ritberg (t...@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 '<path>',
MOVE 'db_log' TO '<path>'
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.