microsoft / mssql-docker

Official Microsoft repository for SQL Server in Docker resources
MIT License
1.72k stars 759 forks source link

How to set Single User Mode in mssql-docker #610

Open davidt922 opened 4 years ago

davidt922 commented 4 years ago

I'mk trying to run mssql server using a single user mode for a backup purpose but I don't find the wat to add the "-m" flag

Is this possible?

Thank you

rodrigo-zuolo commented 4 years ago

According to this

https://github.com/Microsoft/mssql-docker/issues/348

yes, you just need to add "-m"

docker run -e ACCEPT_EULA=Y -e SA_PASSWORD=SomePassword1234 -p 1433:1433 -d microsoft/mssql-server-linux:2017-latest "/opt/mssql/bin/sqlservr" "-m"