How to Restore a SQL Server Database on macOS Using Docker

In this video, I’ll show you how to create a Microsoft SQL Server instance using Docker, connect to SQL Server using a program called SQL Operations Studio, and restore a copy of the AdventureWorks2016.bak database. Finally, I’ll show you how to restart an inactive SQL Server container in Docker.

Notes in the video here: https://docs.google.com/document/d/1G…

Command to create SQL instance:

docker run -e ACCEPT_EULA=Y -e SA_PASSWORD=StrongPa$$word123 -p 1433:1433 -d mcr.microsoft.com/mssql/server:2019-latest 

docker run -e ACCEPT_EULA=Y -e SA_PASSWORD=StrongPa$$word123 -p 1433:1433 -d mcr.microsoft.com/mssql/server:2019-latest 

Command to copy AdventureWorks2016.bak to docker container:

docker cp ~/Downloads/AdventureWorks2016.bak CONTAINER_ID:/var/opt/mssql/data/ 

xxxxxxxxxx

docker cp ~/Downloads/AdventureWorks2016.bak CONTAINER_ID:/var/opt/mssql/data/ 

where CONTAINER_ID is the docker container id for the sql server instance.

People Also View

Database Logical Data Modeling (Ep. 1)

Overview Part 1: In this video, I'll talk about the "Logical Data Modeling", one of the three stages of database design: Conceptual data modeling Logical data modeling Physical data modeling Part 2: Three Types of Relationships in Databases Using ERD Diagram Part 3: Entity-Relationship Design (ERD) Demo Step-by-Step https://youtu.be/nzUaNyyN9jk

February 8, 2023

Complete Database Normalization Step-by-Step

Normalization is the process of eliminating redundancies and decomposing relations with anomalies to produce smaller, well-structured relations. In this lecture, we will learn the concepts and processes of normalization. Then we will do a step-by-step walkthrough to normalize an unnormalized table. First Normal Form (1NF) In all tables look for…

March 1, 2023

Three Types of Relationships in Databases Using ERD Diagram (Ep. 2)

Overview Part 2: In this video, I'll briefly go over the three common types of relationships between two tables in rDBMS: one-to-one, one-to-many, many-to-many. I'll explain this using simple ERD diagrams. Part 1: Database Logical Data Modeling Part 3: Entity-Relationship Design (ERD) Demo Step-by-Step https://youtu.be/nzUaNyyN9jk

February 9, 2023