Sharing these scripts that I always use to backup Sql Databases within the docker container.
<h4>The Why</h4>
I personally use the backup as some sort of “save point” when doing local tests. Sometimes its much faster than prepping data, especially for repeated tests.
<h4>The Prerequisites</h4>
<ol>
<li><a href="https://learn.microsoft.com/en-us/sql/tools/sqlcmd/sqlcmd-utility?view=sql-server-ver16&amp;tabs=go%2Cwindows&amp;pivots=cs1-bash" title="https://learn.microsoft.com/en-us/sql/tools/sqlcmd/sqlcmd-utility?view=sql-server-ver16&amp;tabs=go%2Cwindows&amp;pivots=cs1-bash" target="_blank" rel="noopener nofollow">Sqlcmd</a> - Included in many Visual Studio workflows. Check if you have it using <code>sqlcmd -?</code></li>
</ol>
<h4>The Backup Script</h4>
<pre><code class="language-powershell">sqlcmd -S localhost,2436 -U SA -P Your_password123 
BACKUP DATABASE [DatabaseName] TO DISK = N&#x27;/var/opt/mssql/backup/DatabaseName.bak&#x27; WITH INIT
GO
QUIT

docker exec -it mssql bash
ls var/opt/mssql/backup -a # This will list all files in this directory
exit
</code></pre>
<h4>The sample to restore the database.</h4>
When you backup, you gotta restore it right?
<pre><code class="language-powershell">sqlcmd -S localhost,2436 -U SA -P your_sa_password
ALTER DATABASE [DatabaseName] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
DROP DATABASE [DatabaseName];
RESTORE DATABASE [DatabaseName] FROM DISK = N&#x27;/var/opt/mssql/backup/DatabaseName.bak&#x27;;
USE [DatabaseName];
SELECT name FROM sys.databases WHERE name = &#x27;DatabaseName&#x27;;
GO
QUIT
</code></pre>
Let me know what you think 😁

CLI is rising. This squad is created for all things CLI but for Windows only. Command tips, new CLI tools, TUI apps are welcome as well.

Sample script: Backup (and restore) an Sql database inside a docker container.