当前位置: 代码迷 >> SQL >> SQL Server做完整备份方法
  详细解决方案

SQL Server做完整备份方法

热度:6   发布时间:2016-05-05 12:43:20.0
SQL Server做完整备份步骤

四个步骤:

 

1.       Checkpoint database means that SQL Server writes all dirty pages (pages that have changed since loaded into memory) to disk to ensure only committed transactions included in full backup.

2.       Mark beginning of transaction log to validate backup file(s) whether it could be used in restore process.

3.       Read data file and write into backup device.

4.       Mark end of transaction log when full backup has finished.

  相关解决方案