Then it saves the original file in the original location. In these scenarios, the program first creates a backup file that contains the information from the old file and saves it with the BAK extension.

This typically happens automatically when you (or the program) are saving the file or when you are exiting the program. Many different types of programs protect data by creating a BAK file. JOIN (SELECT * FROM sys.master_files WHERE type_desc = 'LOG' ) LDF ON MDF.database_id = LDF.In general terms, the BAK file extension is simply a backup file. Log_size_mb = CAST((LDF.size * 8.0 / 1024) AS DECIMAL(8,2))įROM (SELECT * FROM sys.master_files WHERE type_desc = 'ROWS' ) MDF If you are unsure of the current filepaths in use, you can query them from the database: SELECTĭb_size_mb = CAST((MDF.size * 8.0)/1024 AS DECIMAL(8,2)), MOVE 'YourDB_Log' TO '/var/opt/mssql/data/YourDB_Log.ldf'īut read through the docs for the specific restoration sequence and parameters for your needs. WITH MOVE 'YourDB' TO '/var/opt/mssql/data/YourDB.mdf',

This is an example: RESTORE DATABASE YourDBįROM DISK = '/var/opt/mssql/backup/YourDB.bak' So the first step is to copy the backup file to a location that the database engine has file system level access to, then use that path in the SQL scripts. The complicating factor for many in SQL Backup/Restore operations is that the paths that you specify in the SQL commands to perform the operations is relative to the server, NOT to your workstation where you are executing the command from. If you are using vscode then you are only looking for the SQL syntax/commands to complete the task, so ignore the solutions that use management studio and the UI.

Migrate a SQL Server database from Windows to Linux using backup and restore.

RESTORE Statements (Transact-SQL) - SQL Server.

How to: Restore Files and Filegroups (Transact-SQL).

Restoring databases in MS SQL is covered extensively in the documentation and even on SO:

Bak file reader