Total docker noob here. Please forgive me for the lengthy post.
We are currently use SQL Server 2019 on Windows for our database. In an effort to "dockerize" the applications and database in our environment, I am looking into moving our database into a SQL Server 2019 Linux Container.
Our current database is 400 GB and is growing at the rate of around 5-10 GB a month. Including backups and logs files and database audit files, I'm looking at an overall space requirement of around 2TB for now.
I want to know if there is a "maximum size of SQL Server database" beyond which it isn't recommended to move to Docker.
Would the Docker container need to be configured to be the whole 2 TB ? Or could I just configure docker to have the database files internal to it and be able to create backups and audit files outside the container ? Or would I have to configure the backups and audit files to be created inside the container and then periodically move them off of the container to manage space ?
Thanks in advance.