2023年7月30日发(作者：)

SQLServer中的数据库备份和还原过程–系列简介It’s a time to turn the corner from “DBA” to “DBA specialist”. This in-depth guide explores the importance of databasebackup-and-restore features and skills you’ll need to build good backup-and-restore strategies using the available toolsand techniques. Along the way, you’ll pick up some interesting insights and most of the concepts of database backup andrestore procedures.现在是时候从“ DBA”转向“ DBA专家”了。 本深⼊指南探讨了使⽤可⽤⼯具和技术建⽴良好的备份和还原策略所需的数据库备份和还原功能和技能的重要性。 在此过程中，您将获得⼀些有趣的见解以及数据库备份和还原过程的⼤多数概念。Ready to dive-deep into Backup-and-Restore procedures? Let’s go!准备好深⼊了解“备份和还原”过程了吗？ 我们⾛吧！Data is the key to your organization’s future, but if it’s outdated, irrelevant or hidden, then it’s no good. Maintaining andadministrating the databases takes a lot of work. As DBAs, we often tend to automate most of the tasks.数据是组织未来的关键，但是，如果数据过时，不相关或隐藏，那就不好了。 维护和管理数据库需要⼤量⼯作。 作为DBA，我们通常倾向于⾃动化⼤多数任务。After a quick refresher on database design concepts, followed by several hands-on examples and scenarios designed toteach how best the solutions works and how to apply it correctly. You’ll also learn about designing good backup andrestore and recovery solutions.在快速回顾了数据库设计概念之后，接下来是⼀些动⼿操作的⽰例和⽅案，旨在教授最佳解决⽅案的⼯作⽅式以及如何正确应⽤它们。 您还将学习设计良好的备份，还原和恢复解决⽅案。As you move through the list of 20+ articles, you’ll see most of the features that include all of the various databaseBackup-and-Restore concepts, T-SQL programming techniques, learn PowerShell Scripting, implementation of backupsolutions to Docker containers, data management using SQL Ops Studio, handling

bacpac and

dacpac files, ingress andegress data from Cloud and more. The articles are organized to make specific topics easy to find so that you can jump startdepending on your skill level.在浏览20余篇⽂章的列表时，您将看到⼤多数功能，其中包括所有各种数据库备份和还原概念，T-SQL编程技术，学习PowerShell脚本编写，对Docker容器的备份解决⽅案的实现，使⽤SQL Ops Studio进⾏数据管理，处理bacpac和dacpac⽂件，来⾃Cloud的⼊⼝和出⼝数据等。 ⽂章经过整理，使特定主题易于查找，因此您可以根据⾃⼰的技能⽔平快速⼊门。1.

2.

3.

4.

5.

6.

7.

8.

9.

10.

11.

12.

13.

14.

15.

16.

17. 18.

19.

20.

21.

第1条： (Article 1: )This article takes the reader through the database backup concepts and gives an overview to understand the basic designprinciples of database backup. Also, it describes the various type of backup destination and covers the definition of RPOand RTO at a very high-level.本⽂向读者介绍了数据库备份的概念，并概述了数据库备份的基本设计原理。 此外，它还描述了各种类型的备份⽬标，并在⾮常⾼的层次上介绍了RPO和RTO的定义。Number of words: ~1000+字数：〜1000 +Time to read: ~5 minutes阅读时间：〜5分钟Level: Beginner级别：初学者Link:链接：第2条： (Article 2: )In this article, we will discuss the different phases of Data Management Life-Cycle. This article is an effort to take a detailedlook at all of the Data Generation, Data Analysis, Data Corruption, Data Prevention, Data Protection, Data Archival, DataPurging stages, and more.在本⽂中，我们将讨论数据管理⽣命周期的不同阶段。 本⽂旨在详细介绍所有数据⽣成，数据分析，数据损坏，数据预防，数据保护，数据归档，数据清除阶段等。Number of words: ~1000+字数：〜1000 +Time to read: ~5 minutes阅读时间：〜5分钟Level: Beginner/Intermediate级别：初学者/中级Link:链接：第3条： (Article 3: )In this article, we will walk-though the database recovery model. It’s a database setting or configuration option thatdetermines the type of backup that one could perform. It provides an option or ability to restore the data or recover it froma failure.在本⽂中，我们将深⼊研究数据库恢复模型。 这是⼀个数据库设置或配置选项，⽤于确定可以执⾏的备份类型。 它提供了还原数据或从故障中恢复数据的选项或能⼒。Also, it comprises multi-server PowerShell and T-SQL script to capture the database recovery model, and more…此外，它包括多服务器PowerShell和T-SQL脚本以捕获数据库恢复模型，等等。Number of words: ~1500+字数：〜1500 +Time to read: ~6 minutes阅读时间：〜6分钟Level: Beginner/Intermediate级别：初学者/中级Link:链接：第4条： (Article 4: )SQL Server backup is a vast topic; so vast; However, this article is an effort to outlay on the types of backups that areavailable, understand the importance, and how to pick what we need, and what aspects we base that decision on. Thisunderstanding of every option would, in turn, help us decide our backup-and-restore strategy. It also covers how to takestandard and compressed database backups of all Server备份是⼀个⼴泛的主题。 如此巨⼤ 但是，本⽂的⼯作是花费可⽤的备份类型，了解其重要性，以及如何选择我们需要的内容以及该决定基于哪些⽅⾯。 对每个选项的了解反过来将有助于我们确定备份和还原策略。 它还介绍了如何进⾏所有类型的标准和压缩数据库备份。Number of words: ~1500+字数：〜1500 +Time to read: ~7 minutes阅读时间：〜7分钟Level: Beginner/ Intermediate级别：初学者/中级Link:链接：第5条： (Article 5: )In this article, we will discuss the various factors to consider for designing a good backup-and-recovery strategy. This articletakes the reader on how to use native T-SQL and PowerShell for data gathering tasks. Out of that, it also details thedifferent ways to baseline the data for effective backup-and-restore planning.在本⽂中，我们将讨论设计良好的备份和恢复策略时要考虑的各种因素。 本⽂向读者介绍了如何使⽤本机T-SQL和PowerShell执⾏数据收集任务。 除此之外，它还详细介绍了为有效的备份和还原计划制定基准数据的不同⽅法。The additional link for reference:附加链接供参考：Number of words: ~1250+字数：〜1250 +Time to read: ~7 minutes阅读时间：〜7分钟Level: Beginner/ Intermediate/Expert级别：初学者/中级/专家Link:链接：第6条： (Article 6: )In the previous articles, we’ve gotten to know about more of design concepts and guidelines of database backup-and-restore operations. In this article, we start with the implementations. The database backup, copy operation using Robocopyutility, and database restore operation steps are scripted using sqlcmd mode. We work with process and teach how toschedule them using SQL Server agent.在前⾯的⽂章中，我们已经了解了更多有关数据库备份和还原操作的设计概念和准则。 在本⽂中，我们从实现开始。 数据库备份，使⽤Robocopy实⽤程序进⾏的复制操作以及数据库还原操作步骤均使⽤sqlcmd模式编写脚本。 我们处理流程，并讲授如何使⽤SQL Server代理计划它们。Additional links:附加链接：Number of words: ~1250+字数：〜1250 +Time to read: ~5 minutes阅读时间：〜5分钟Level: Beginner/ Intermediate/Expert级别：初学者/中级/专家Link:链接：第7条： (Article 7: )In the article, we’ll walk through the concepts to understand database snapshots, and their benefits and limitations. Thisarticle will help you decide when to use a database snapshot, and when to use a backup. In some cases, the database relyingon database backup and restore operation is not a viable option. It also covers “the difference between database backupand database snapshot” topic.在本⽂中，我们将逐步介绍概念，以了解数据库快照及其优点和局限性。 本⽂将帮助您决定何时使⽤数据库快照以及何时使⽤备份。 在某些情况下，依赖数据库备份和还原操作的数据库不是可⾏的选择。 它还涵盖了“数据库备份和数据库快照之间的区别”主题。Number of words: ~2250+字数：〜2250 +Time to read: ~10 minutes阅读时间：〜10分钟Level: Beginner/ Intermediate/Expert级别：初学者/中级/专家Link:链接：第8条： (Article 8: )In the article, we’ll discuss the “Database cross-platform tool—”. This article the details the preparationof the PowerShell script to automate database restoration process using the SqlPackage; a SQL Server Data Tools suite.在本⽂中，我们将讨论“数据库跨平台⼯具”。 本⽂详细介绍了PowerShell脚本的准备⼯作，以使⽤SqlPackage⾃动执⾏数据库还原过程。 SQL Server数据⼯具套件。Number of words: ~1000+字数：〜1000 +Time to read: ~5 minutes阅读时间：〜5分钟Level: Beginner/ Intermediate/Expert级别：初学者/中级/专家Link:链接：第9条： (Article 9: )So far, we’ve discussed several concepts of backup-and-restore that start with planning, creating, strategizing andimplementing. In this article, we are going to see how database administrators can define the strategy to improve backupperformance and efficiently manage backups in SQL Server 2017. Also, briefs the concepts of indirect checkpoints, DCM,DMVs, and DMFs.到⽬前为⽌，我们已经讨论了备份和还原的⼏个概念，这些概念从计划，创建，制定战略和实施开始。 在本⽂中，我们将了解数据库管理员如何在SQL Server 2017中定义策略来提⾼备份性能和有效管理备份。此外，还将简要介绍间接检查点，DCM，DMV和DMF的概念。Number of words: ~2000+字数：〜2000 +Time to read: ~5 minutes阅读时间：〜5分钟Level: Beginner/ Intermediate/Expert级别：初学者/中级/专家Link:链接：第10条： (Article 10: )The pre-requisite for an efficient restore operation is always a good backup. In this article, we will walk-through, theconcepts of page-level restore; what are the ways the data gets corrupted; brief introduction of tool; how to dealwith the corruption; how to do a page-level restore with SSMS and T-SQL interface, and more.有效还原操作的前提条件始终是良好的备份。 在本⽂中，我们将逐步介绍页⾯级还原的概念； 数据损坏的⽅式是什么？ ⼯具的简要介绍； 如何处理腐败； 如何使⽤SSMS和T-SQL接⼝等进⾏页⾯级还原。Number of words: ~1000+字数：〜1000 +Time to read: ~4 minutes阅读时间：〜4分钟Level: Beginner/ Intermediate/Expert级别：初学者/中级/专家Link:链接：第11条： (Article 11: )This article takes the reader through the concepts and in-depth guide on how PowerShell provides a platform to maintainand manage SQL Server database backup on cross-platform systems. It covers the technical details of how to load the SQLServer modules, manage security using .NET class libraries, and more.本⽂为读者提供有关PowerShell如何提供平台来维护和管理跨平台系统上SQL Server数据库备份的概念和深⼊指南。 它涵盖了有关如何加载SQL Server模块，使⽤.NET类库管理安全性等技术细节。Number of words: ~2000+字数：〜2000 +Time to read: ~5 minutes阅读时间：〜5分钟Level: Beginner/ Intermediate/Expert级别：初学者/中级/专家Link:链接：第12条： (Article 12: )This article introduces the administrators to what Offsite and Onsite are; what is Cloud backup; how it’s implemented withT-SQL or SSMS. It covers the required technical specification to be met before jump start into the Cloud backup. We willwalk-through the creation of Azure account, Storage container configuration, Credential authorization, GUI tools to performdatabase backup and restore, Implementation of database backup and restore using T-SQL and PowerShell, and more.本⽂向管理员介绍“⾮现场”和“现场”。 什么是云备份？ 如何使⽤T-SQL或SSMS实施。 它涵盖了在开始进⼊云备份之前要满⾜的必需技术规范。 我们将逐步介绍Azure帐户的创建，存储容器配置，凭据授权，执⾏数据库备份和还原的GUI⼯具，使⽤T-SQL和PowerShell执⾏数据库备份和还原等。Number of words: ~2000+字数：〜2000 +Time to read: ~10 minutes阅读时间：〜10分钟Level: Beginner/ Intermediate/Expert级别：初学者/中级/专家Link :链接：第13条： (Article 13: )This article covers how to take Tail-log backups, and then use them in conjunction with other database backup types. Also, itdetails the steps to restore or recover a database to a particular point- in-time. They also cover common Tail-log scenariosand how to resolve them.本⽂介绍如何进⾏尾⽇志备份，然后将其与其他数据库备份类型结合使⽤。 另外，它详细介绍了将数据库还原或恢复到特定时间点的步骤。 它们还介绍了常见的尾⽇志⽅案以及如何解决它们。Number of words: ~1000+字数：〜1000 +Time to read: ~5 minutes阅读时间：〜5分钟Level: Beginner/ Intermediate/Expert级别：初学者/中级/专家Link:链接：第14条： (Article 14: )In this article, we will discuss the importance of database backup reports and how to generate the report using T-SQL andPowerShell. Also, it covers the important baseline metrics of the report.在本⽂中，我们将讨论数据库备份报告的重要性以及如何使⽤T-SQL和PowerShell⽣成报告。 此外，它涵盖了报告的重要基准指标。Number of words: ~2000+字数：〜2000 +Time to read: ~8 minutes阅读时间：〜8分钟Level: Beginner/ Intermediate/Expert级别：初学者/中级/专家Link:链接：第15条： (Article 15: )This article explains the de-facto details of the database file and filegroup architectures that enable file-based backup-and-restore and the process of capturing the necessary file backups and transaction-log backups, and using them in variousrestore operations.本⽂说明了⽀持基于⽂件的备份和还原的数据库⽂件和⽂件组体系结构的实际细节，以及捕获必要的⽂件备份和事务⽇志备份并在各种还原操作中使⽤它们的过程。Number of words: ~2000+字数：〜2000 +Time to read: ~8 minutes阅读时间：〜8分钟Level: Beginner/ Intermediate/Expert级别：初学者/中级/专家Link:链接：第16条： (Article 16: )In this article, we will discuss High-level components, concepts of Memory-optimized database backup, and the recoveryphases. It also details the internals of In-Memory OLTP engine and transaction logging mechanism, and more.在本⽂中，我们将讨论⾼级组件，内存优化的数据库备份的概念以及恢复阶段。 它还详细介绍了内存中OLTP引擎的内部结构和事务记录机制等。Number of words: ~2500+字数：〜2500 +Time to read: ~8 minutes阅读时间：〜8分钟Level: Beginner/ Intermediate/Expert级别：初学者/中级/专家Link:链接：第17条： (Article 17: )This article would help the reader to perform database backup on the SQL Server Docker containers. It discusses thedifferent scenario of data persistence and data externalization process.本⽂将帮助读者在SQL Server Docker容器上执⾏数据库备份。 它讨论了数据持久性和数据外部化过程的不同情况。Number of words: ~2000+字数：〜2000 +Time to read: ~8 minutes阅读时间：〜8分钟Level: Beginner/ Intermediate/Expert级别：初学者/中级/专家Link:链接：第18条： (Article 18:)In this article, you will learn how to use Azure Data Studio (Preview) to do backup a database, view the status of thedatabase backup with backup history tab, how to restore a database and integrated terminal, and more.在本⽂中，您将学习如何使⽤Azure Data Studio（Preview）进⾏数据库备份，通过“备份历史记录”选项卡查看数据库备份的状态，如何还原数据库和集成终端，以及更多。Number of words: ~1000+字数：〜1000 +Time to read: ~5 minutes阅读时间：〜5分钟Level: Beginner/ Intermediate/Expert级别：初学者/中级/专家Link:链接：第19条： (Article 19: )Finally, these articles provide a quick overview and reference of backup and restore commands, illustrated with definition,important tips and examples formulated as potential interview questions.最后，这些⽂章提供了备份和还原命令的快速概述和参考，并给出了定义，重要提⽰和⽰例（作为潜在的采访问题）进⾏了说明。Number of words: ~2500+字数：〜2500 +Time to read: ~30 minutes阅读时间：〜30分钟Level: Beginner/ Intermediate/Expert级别：初学者/中级/专家Link:链接：第20条： (Article 20: )Finally, these articles provide a quick overview and reference of backup and restore commands, illustrated with definition,important tips and examples formulated as potential interview questions.最后，这些⽂章提供了备份和还原命令的快速概述和参考，并给出了定义，重要提⽰和⽰例（作为潜在的采访问题）进⾏了说明。Number of words: ~2500+字数：〜2500 +Time to read: ~30 minutes阅读时间：〜30分钟Level: Beginner/ Intermediate/Expert级别：初学者/中级/专家Link:链接：第21条： (Article 21: )Finally, these articles provide a quick overview and reference of backup and restore commands, illustrated with definition,important tips and examples formulated as potential interview questions.最后，这些⽂章提供了备份和还原命令的快速概述和参考，并给出了定义，重要提⽰和⽰例（作为潜在的采访问题）进⾏了说明。Number of words: ~2500+字数：〜2500 +Time to read: ~30 minutes阅读时间：〜30分钟Level: Beginner/ Intermediate/Expert级别：初学者/中级/专家Link:链接：