Skip to content

SQL Server

Jump to bottom
Néville Dubuis edited this page Feb 16, 2026 · 1 revision

Restore Backup file (.bak) on a new machine (or in a new DB)

First look at logical name of files

RESTORE FILELISTONLY FROM DISK = '/docker-mount/BOLLINI_backup_2026_02_15_121503_6788858.bak'

will give you

LogicalName PhysicalName Type FileGroupName Size MaxSize FileId CreateLSN DropLSN UniqueId ReadOnlyLSN ReadWriteLSN BackupSizeInBytes SourceBlockSize FileGroupId LogGroupGUID DifferentialBaseLSN DifferentialBaseGUID IsReadOnly IsPresent TDEThumbprint SnapshotUrl
BAUBIT_GO D:\ARC\BAUBITPRO\MSSQL15.BBPRO2019\MSSQL\DATA\BOLLINI.mdf D PRIMARY 15453257728 35184372080640 1 0 0 D6643FBD-FCC1-4039-9D75-A4760DF9060E 0 0 12357074944 4096 1 219772000001832000037 E93F0C04-3D93-4950-B18E-175818A307CD 0 1
BAUBIT_GO_log D:\ARC\BAUBITPRO\MSSQL15.BBPRO2019\MSSQL\DATA\BOLLINI.ldf L 445382656 2199023255552 2 0 0 CEC34B69-E780-4FF2-A67A-3F28B91ADBBF 0 0 0 4096 0 0 00000000-0000-0000-0000-000000000000 0 1

Form that you can craft the following request to do the import :

RESTORE DATABASE [BOLLINI]
FROM DISK = '/docker-mount/BOLLINI_backup_2026_02_15_121503_6788858.bak'
WITH 
    MOVE 'BAUBIT_GO' TO '/var/opt/mssql/data//BOLLINI.mdf', 
    MOVE 'BAUBIT_GO_log' TO '/var/opt/mssql/data//BOLLINI.ldf', 
RECOVERY, REPLACE

Clone this wiki locally