Skip to content

tutorial-restore-backup-in-sql-server-container.md

Latest commit

 

History

History
78 lines (56 loc) · 3.54 KB

tutorial-restore-backup-in-sql-server-container.md

File metadata and controls

78 lines (56 loc) · 3.54 KB
title Restore a SQL Server database in Docker | Microsoft Docs
description This tutorial shows how restore a SQL Server database backup in a new Linux Docker container.
author rothja
ms.author jroth
manager jhubbard
ms.date 09/11/2017
ms.topic article
ms.prod sql-linux
ms.technology database-engine

Restore a SQL Server database in a Linux Docker container

[!INCLUDEtsql-appliesto-sslinux-only]

This tutorial demonstrates how to move and restore a SQL Server backup file into a SQL Server 2017 container image running on Docker.

[!div class="checklist"]

  • Pull and run the latest SQL Server 2017 Linux container image.
  • Copy the World Wide Importers database file into the container.
  • Restore the database in the container.
  • Run Transact-SQL statements to view and modify the database.
  • Backup the modified database.

Prerequisites

Important

The default on Docker for Mac and Docker for Windows is 2 GB for the Moby VM, so you must change it to 4 GB. If you are running on Mac or Windows, increase your memory settings using the instructions in the Docker quickstart.

Pull and run the container image

  1. Pull the SQL Server 2017 Linux container image from Docker Hub.

    docker pull microsoft/mssql-server-linux

    [!TIP] For Linux, depending on your system and user configuration, you might need to preface each docker command with sudo.

  2. To run the container image with Docker, you can use the following command from a bash shell (Linux/macOS):

    docker run -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=<YourStrong!Passw0rd>' --name 'sqlcontianer1' -e 'MSSQL_PID=Developer' -p 1401:1433 -d microsoft/mssql-server-linux

    If you are using Docker for Windows, run an elevated PowerShell command prompt and use double-quotes for the string values:

    docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=<YourStrong!Passw0rd>" --name "sqlcontianer1" -e "MSSQL_PID=Developer" -p 1401:1433 -d microsoft/mssql-server-linux

    [!NOTE] This command creates a SQL Server 2017 container with the Developer Edition. SQL Server port 1433 is exposed on the host as port 1401. This means that to connect from outside from the container, you would also need to specify port 1401. Connecting externally is not part of this tutorial, but you can see an example in the Docker quickstart.

  3. To view your Docker containers, use the docker ps command.

    docker ps -a

  4. If the STATUS column shows a status of Up, then SQL Server is running in the container and listening on the port specified in the PORTS column. If the STATUS column for your SQL Server container shows Exited, see the Troubleshooting section of the configuration guide.

Next steps

In this tutorial, you learned how to back up a database on Windows and move it to a Linux server running SQL Server 2017 RC2. You learned how to:

[!div class="checklist"]

  • TBD

Next, explore other migration scenarios for SQL Server on Linux.

[!div class="nextstepaction"] Configuration guide for SQL Server 2017 on Docker