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 FreeDownload the Altoros NoSQL Performance Benchmark 2018. Compare top NoSQL solutions – Couchbase Server v5.5, MongoDB v3.6, and DataStax Enterprise v6 (Cassandra).
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.
Download the whitepaper, Moving From Relational to NoSQL: How to Get Started. We’ll take you step by step through your first NoSQL project.
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 }}