DB/SQL Server2 docker / SQLSERVER / MSSQL / 데이터베이스복원 / 계정생성 / 권한부여 / 백업스크립트 실행 1. docker CONTAINER ID 확인 user@PC:/$ docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES ab11426a70ce mcr.microsoft.com/mssql/server:2019-latest "/opt/mssql/bin/perm…" 9 minutes ago Up 9 minutes 0.0.0.0:11433->1433/tcp, :::11433->1433/tcp sql-server-container user@PC:/$ 2. sqlcmd 실행 2.1 docker 내부 Container console 실행 user@PC:/$ docker exec -it ab11426a70ce /opt/mssql-tools/bin/sqlcmd.. 2024. 2. 29. docker / SQLSERVER / MSSQL / 데이터베이스생성 / 계정생성 / 권한부여 1. docker CONTAINER ID 확인 user@PC:/$ docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES 7c226918297a mcr.microsoft.com/mssql/server:2019-latest "/opt/mssql/bin/perm…" 9 minutes ago Up 9 minutes 0.0.0.0:11433->1433/tcp, :::11433->1433/tcp sql-server-container user@PC:/$ 2. sqlcmd 실행 2.1 docker 내부 Container console 실행 user@PC:/$ docker exec -it 7c226918297a /opt/mssql-tools/bin/sqlcmd.. 2024. 2. 29. 이전 1 다음 반응형