/opt/mssql-tools/bin/sqlcmd -H localhost -U sa -Q ‘BACKUP DATABASE [matrix] TO DISK = /backup/matrixbackup.bak WITH NOFORMAT, NOINIT, NAME = matrixbackup, SKIP, NOREWIND, NOUNLOAD, STATS = 10’ /opt/mssql-tools/bin/sqlcmd -H localhost -U sa -Q ‘RESTORE DATABASE [MATRIX] FROM DISK = /home/data/matrixbackup.bak WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 5’
SELECT name FROM master.dbo.sysdatabases;
GO;