Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Understanding Backup and Restore Operations in SQL Server Docker Containers

DZone's Guide to

Understanding Backup and Restore Operations in SQL Server Docker Containers

In this article, we will discuss the concepts of database backup-and-restore operations on SQL Server Docker containers.

· Database Zone ·
Free Resource

Download "Why Your MySQL Needs Redis" and discover how to extend your current MySQL or relational database to a Redis database.

In this article, we'll cover the concepts of database backup-and-restore operations using SQL Server Docker containers. This is certainly the era of containers era, and it is buzzing right now, so let's understand the importance of the backup-and-restore function on the databases on the Docker containers.

This article discusses the following topics:

  • Prerequisites
  • Initiate database backup
  • Copy the backup file to another container
  • Restore database
  • Pull SQL Server 2017 container images
  • Run SQL Server 2017 docker container image using docker run
  • Create the database 
  • Explain data persistence

Continue reading...

https://www.sqlshack.com/backup-and-restore-operations-with-sql-server-2017-on-docker-containers-using-sql-operations-studio/


See More

To manage SQL Server backups, consider ApexSQL Backup, a tool that offers automation of backup, restore, and log shipping jobs, stores details of all backup activities, and enables easy cross server backup management and maintenance.

Read "Developing Apps Using Active-Active Redis Enterprise" and discover the advantages over other active-actve databases.

Topics:
database ,tutorial ,sql server ,docker containers ,backup and restore

Published at DZone with permission of

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}