Hi, everyone. This is first my post in dev.to and my first time for write article in second language. today I want to share some trick for backup your database from docker container. let's begin... 😊
Note I assume your already running container.
For example I use TutorialDB database for demonstrate purpose. Your can create same database click Create a database
PRINT "Start Backup process..."; DECLARE @MyFileName varchar(200) SELECT @MyFileName=N'/tmp/Backup_' + convert(nvarchar(20),GetDate(),112)+'_'+convert(nvarchar(20),GetDate(),108)+ '.bak' BACKUP DATABASE [TutorialDB] TO DISK=@MyFileName PRINT "Finished backup process...";
Then save above T-SQL to backup-database.sql
Go inside your container by docker exec cli as below
Note You need to use --user root (option) for update package list.
Now, update package list by apt-get update -y as below
Then you will installing 2 package such as vim and cron as below
For example above configuration is running backup-database.sql every 1 minute. Keep in mind it's just example for show how it work. Next you want to restart crontab for start your schedule job like this
Until we meet again. Thank you 🚀 🚀 🚀