I am doing this, from an Azure DevOps agent.
kubectl -n [namespace] exec [pod] -- /opt/mssql-tools18/bin/sqlcmd -U [user] -P [pass] -Q "RESTORE DATABASE [db_name] FROM DISK = '/mnt/share/db.bak' WITH STATS = 10, RECOVERY" -C
The restore works, but I recently added the WITH STATS = 10 part. This is supposed to make sqlcmd print a message for every 10% completion. It seems because this is run in the pod via kubectl exec, output streamed to console during the long-running restore does not reach the kubectl client (Azure DevOps agent) until the process is complete, rendering the WITH STATS = 10 fairly useless for this use-case.
I tried adding the -i and -t options on kubectl exec, and they didn’t help.
So ultimately I’m trying to get real-time progress prints while the DB is restoring. Has anyone run into or tried anything like this before, have any ideas, etc? Thanks!
