Understanding Backup and Restore Operations in SQL Server Docker Containers
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.
Join the DZone community and get the full member experience.
Join For FreeRavenDB vs MongoDB: Which is Better? This White Paper compares the two leading NoSQL Document Databases on 9 features to find out which is the best solution for your next project.
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.
Get comfortable using NoSQL in a free, self-directed learning course provided by RavenDB. Learn to create fully-functional real-world programs on NoSQL Databases. Register today.
Like This Article? Read More From DZone
Published at DZone with permission of Prashanth Jayaram , DZone MVB. See the original article here.
Opinions expressed by DZone contributors are their own.
{{ parent.title || parent.header.title}}
{{ parent.tldr }}
{{ parent.linkDescription }}
{{ parent.urlSource.name }}