---------------Docker with SQL-------------
Docker commands:
docker run -d -p 8080:1433 --name docker_sql2017 -e sa_password=Test123456test -e ACCEPT_EULA=Y microsoft/mssql-server-windows-developer:2017-latest
To See docker images:
docker images
For ex:
PS C:\Users\usename> docker images
To see docker all containers:
docker ps -a
To see docker container ip address:
docker inspect -f "{{range .NetworkSettings.Networks}}{{.IPAddress}}{{end}}" containername
docker inspect -f "{{range .NetworkSettings.Networks}}{{.IPAddress}}{{end}}" docker_sql2017
To see logs of container:
Docker container logs containername
Docker container logs docker_sql2017
To login to the sql cmd:
PS C:\Users\jar> sqlcmd -U sa -S Ipaddressofserver(which we got from inspect command above)
PS C:\Users\jar> sqlcmd -U sa -S 172.31.240.15
Once logeed into to we can see version and servername as below
PS C:\Users\jar> sqlcmd -U sa -S 172.31.240.15
Password:Test123456test
1> go
1> select @@version
2> go
1> select @@servername
2> go
To create loginname with sysadmin as below:
1> create login testlogin with password='test@123';
2> go
1>
2> exec master..sp_addsrvrolemember @loginame='testlogin',@rolename='sysadmin';
3> go
Now we can go with loginto the SSMS as see below
Servername: Ipaddress,portno
Ex:
172.31.240.15,1433
Username:testlogin
Password:test@123
-------------------------------------------------------
ref:
https://www.digitalocean.com/community/tutorials/how-to-remove-docker-images-containers-and-volumes
Docker commands:
docker run -d -p 8080:1433 --name docker_sql2017 -e sa_password=Test123456test -e ACCEPT_EULA=Y microsoft/mssql-server-windows-developer:2017-latest
To See docker images:
docker images
For ex:
PS C:\Users\usename> docker images
To see docker all containers:
docker ps -a
To see docker container ip address:
docker inspect -f "{{range .NetworkSettings.Networks}}{{.IPAddress}}{{end}}" containername
docker inspect -f "{{range .NetworkSettings.Networks}}{{.IPAddress}}{{end}}" docker_sql2017
To see logs of container:
Docker container logs containername
Docker container logs docker_sql2017
To login to the sql cmd:
PS C:\Users\jar> sqlcmd -U sa -S Ipaddressofserver(which we got from inspect command above)
PS C:\Users\jar> sqlcmd -U sa -S 172.31.240.15
Once logeed into to we can see version and servername as below
PS C:\Users\jar> sqlcmd -U sa -S 172.31.240.15
Password:Test123456test
1> go
1> select @@version
2> go
1> select @@servername
2> go
To create loginname with sysadmin as below:
1> create login testlogin with password='test@123';
2> go
1>
2> exec master..sp_addsrvrolemember @loginame='testlogin',@rolename='sysadmin';
3> go
Now we can go with loginto the SSMS as see below
Servername: Ipaddress,portno
Ex:
172.31.240.15,1433
Username:testlogin
Password:test@123
-------------------------------------------------------
ref:
https://nexxtjump.com/2017/12/12/step-by-step-guide-to-run-sql-server-in-a-windows-docker-container/
https://www.digitalocean.com/community/tutorials/how-to-remove-docker-images-containers-and-volumes
Purging All Unused or Dangling Images, Containers, Volumes, and Networks
Docker provides a single command that will clean up any resources — images, containers, volumes, and networks — that are dangling (not associated with a container):
- docker system prune
To additionally remove any stopped containers and all unused images (not just dangling images), add the
-a flag to the command:
- docker system prune -a
Removing Docker Images
Remove one or more specific images
Use the
docker images command with the -a flag to locate the ID of the images you want to remove. This will show you every image, including intermediate image layers. When you've located the images you want to delete, you can pass their ID or tag to docker rmi:
List:
- docker images -a
Remove:
- docker rmi Image Image
Remove dangling images
Docker images consist of multiple layers. Dangling images are layers that have no relationship to any tagged images. They no longer serve a purpose and consume disk space. They can be located by adding the filter flag,
-f with a value of dangling=true to the docker imagescommand. When you're sure you want to delete them, you can use the docker images purgecommand:
Note: If you build an image without tagging it, the image will appear on the list of dangling images because it has no association with a tagged image. You can avoid this situation by providing a tagwhen you build, and you can retroactively tag an images with the docker tag command.
List:
- docker images -f dangling=true
Remove:
- docker images purge
Removing images according to a pattern
You can find all the images that match a pattern using a combination of
docker images and grep. Once you're satisfied, you can delete them by using awk to pass the IDs to docker rmi. Note that these utilities are not supplied by Docker and are not necessarily available on all systems:
List:
- docker images -a | grep "pattern"
Remove:
- docker images -a | grep "pattern" | awk '{print $3}' | xargs docker rmi
Remove all images
All the Docker images on a system can be listed by adding
-a to the docker images command. Once you're sure you want to delete them all, you can add the -q flag to pass the Image ID to docker rmi:
List:
- docker images -a
Remove:
- docker rmi $(docker images -a -q)
Removing Containers
Remove one or more specific containers
Use the
docker ps command with the -a flag to locate the name or ID of the containers you want to remove:
List:
- docker ps -a
Remove:
- docker rm ID_or_Name ID_or_Name
Remove a container upon exit
If you know when you’re creating a container that you won’t want to keep it around once you’re done, you can run
docker run --rm to automatically delete it when it exits.
Run and Remove:
- docker run --rm image_name
Remove all exited containers
You can locate containers using
docker ps -a and filter them by their status: created, restarting, running, paused, or exited. To review the list of exited containers, use the -f flag to filter based on status. When you've verified you want to remove those containers, using -q to pass the IDs to the docker rm command.
List:
- docker ps -a -f status=exited
Remove:
- docker rm $(docker ps -a -f status=exited -q)
Remove containers using more than one filter
Docker filters can be combined by repeating the filter flag with an additional value. This results in a list of containers that meet either condition. For example, if you want to delete all containers marked as either Created (a state which can result when you run a container with an invalid command) or Exited, you can use two filters:
List:
- docker ps -a -f status=exited -f status=created
Remove:
- docker rm $(docker ps -a -f status=exited -f status=created -q)
Remove containers according to a pattern
You can find all the containers that match a pattern using a combination of
docker ps and grep. When you're satisfied that you have the list you want to delete, you can use awk and xargs to supply the ID to docker rmi. Note that these utilities are not supplied by Docker and not necessarily available on all systems:
List:
- docker ps -a | grep "pattern”
Remove:
- docker ps -a | grep "pattern" | awk '{print $3}' | xargs docker rmi
Stop and remove all containers
You can review the containers on your system with
docker ps. Adding the -a flag will show all containers. When you're sure you want to delete them, you can add the -q flag to supply the IDs to the docker stop and docker rm commands:
List:
- docker ps -a
Remove:
- docker stop $(docker ps -a -q)
- docker rm $(docker ps -a -q)
Removing Volumes
Remove one or more specific volumes - Docker 1.9 and later
Use the
docker volume ls command to locate the volume name or names you wish to delete. Then you can remove one or more volumes with the docker volume rm command:
List:
- docker volume ls
Remove:
- docker volume rm volume_name volume_name
Remove dangling volumes - Docker 1.9 and later
Since the point of volumes is to exist independent from containers, when a container is removed, a volume is not automatically removed at the same time. When a volume exists and is no longer connected to any containers, it's called a dangling volume. To locate them to confirm you want to remove them, you can use the
docker volume ls command with a filter to limit the results to dangling volumes. When you're satisfied with the list, you can remove them all with docker volume prune:
List:
- docker volume ls -f dangling=true
Remove:
- docker volume prune
Remove a container and its volume
If you created an unnamed volume, it can be deleted at the same time as the container with the
-vflag. Note that this only works with unnamed volumes. When the container is successfully removed, its ID is displayed. Note that no reference is made to the removal of the volume. If it is unnamed, it is silently removed from the system. If it is named, it silently stays present.
Remove:
- docker rm -v container_name
Helpful
Not helpful
