首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > SQL Server >

SQL Server做完整备份方法

2012-12-24 
SQL Server做完整备份步骤四个步骤: 1.Checkpoint database means that SQL Server writes all dirty page

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.

热点排行
Bad Request.