Hi WARMAN,

The database consists of files. If the server is not running, then you can copy these files to another location to restore them later. To get a list of database files execute the following T-SQL query:

SELECT
db.name AS DBName,
type_desc AS FileType,
Physical_Name AS Location
FROM
sys.master_files mf
INNER JOIN
sys.databases db ON db.database_id = mf.database_id

Hi John,

Yes, you can use SqlBak on Linux, here are more details: https://sqlbak.com/blog/how-to-automate-mysql-database-backups-in-linux