Esteemed,
I would like a support with a horrible situation that I am going through.
I have an instance in GCP for my company's SQL Server databases. Each sector of my company has an instance of SQL Server and each instance is inside its own container separately. I currently have five containers with approximately 300 databases.
The backups of these databases are made via scheduling on the sql server agent and later copied to google storage from a shell script using the gpc agent gsutil -m mv /var/lib/docker/overlay2/*/var/opt/mssql/agent/backups/*.bak gs://mybucket/.
Backups work perfectly! However in the docker I have a storage problem, because the space that is used for backups is only released after I restart the docker service. This is a horrible job because the disk is always full and all my users are disconnected when I need to restart the docker and free up that space.
What would help me:
Option 1: A shell script that clears the empty space of the docker without having to restart the container. I tried this option a lot and nothing helped me. People always talk about cleaning unused containers and etc ... But that is not my case. I need to free up space that is no longer used inside a container that is running HOT!
Option 2: Use gstuil directly on the SQL Server agent for backups to be forwarded directly to google storage without needing to be saved on my server before going to storage. I also didn't find anything that could help me.
question from:
https://stackoverflow.com/questions/65828973/sql-server-backup-docker-google-storage-full-disk-help-me 与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…
