creación de carpeta para backup
sudo mkdir -p /backups/sql-server
permisos para usuario mssql
sudo chown mssql /backups/sql-server
testeando la conexión
sqlcmd -U sa -Q 'select "test ok"'
creando backup
sqlcmd -U sa -Q 'BACKUP DATABASE dummy TO DISK = "/backups/sql-server/full.bak";'
restore de la base
sqlcmd -U sa -Q 'RESTORE DATABASE dummy FROM DISK = "/backups/sql-server/full.bak" WITH REPLACE;'
creando base nueva desde backup
sqlcmd -U sa -Q 'RESTORE DATABASE dummy FROM DISK = "/backups/sql-server/full.bak" WITH MOVE "dummy" TO "/var/opt/mssql/data/dummy.mdf", MOVE "dummy_log" TO "/var/opt/mssql/data/dummy_log.ldf", RECOVERY, REPLACE'
