摘 要：首先给出 SQL Server 全库备份内容的结论，详细列出 SQL Server 执行全库备份时要执行的各个任务，指出全库备份中不同范围的事务日志备份在执行数据库恢复时的不同作用，列举全库备份操作中容易忽视和混淆的几个注意事项，解释了涉及数据库备份的几个 LSN 属性，最后以实例说明了 SQL Server 2019 全库备份的 first_lsn 和 last_lsn 产生的过程。
关键词：SQL Server 2019；数据库全库备份；备份内容；备份过程
DOI:10.19850/j.cnki.2096-4706.2021.05.031
中图分类号：TP311 文献标识码：A 文章编号：2096-4706（2021）05-0128-04
Study on the Process and Content of SQL Server 2019 Full Database Backup
LI Aiwu
（Guangdong Vocational College of Post and Telecom，Guangzhou 510630，China）
Abstract：Firstly，it gives the conclusion of the content of SQL Server full database backup，lists in detail the various tasks to be performed when SQL Server performs full database backup，points out the different roles of different ranges of transaction log backups in full database backup when performing database recovery，lists several considerations that are easily overlooked and confused in the full database backup operations，explains several attributes of LSN related with the database backup. Finally，an example is constructed to illustrate the generating process of first_lsn and last_lsn for SQL Server 2019 full database backup.
Keywords：SQL Server 2019；full database backup；backup content；backup process
参考文献：
[1] HENDERSON K. The Guru’s Guide to SQL Server Architecture and Internals [M].Hoboken：Pearson Education，2004.
[2] DELANEY K. Inside Microsoft SQL Server 2005 [M]. Microsoft Press，2007.
[3] DELANEY K. Microsoft SQL Server 2012 Internals [M]. Microsoft Press，2013.
[4] KOROTKEVITCH D. Pro SQL Server Internals [M].2nd ed.New York：Apress，2016.
[5] 李爱武 .SQL Server 2008 数据库技术内幕 [M]. 北京： 中国铁道出版社，2012.
作者简介：李爱武（1969.07—），男，汉族，河北肃宁人， 副教授，理学硕士，研究方向：数据库技术、数据分析。