计算机系统应用
計算機繫統應用
계산궤계통응용
APPLICATIONS OF THE COMPUTER SYSTEMS
2013年
6期
18-23,74
,共7页
数据库管理系统%备份%恢复%事务日志%最小恢复日志序列号
數據庫管理繫統%備份%恢複%事務日誌%最小恢複日誌序列號
수거고관리계통%비빈%회복%사무일지%최소회복일지서렬호
DBMS%backup%recovery%transaction log%minimum recovery LSN
SQL SERVER 2005的备份/恢复功能表面上看似简单,但实际上其实现机制相当复杂并且微软公司并没有对外公布其备份/恢复机制的具体实现细节。包括专业数据库管理员在内很少有人能将SQL SERVER 2005的备份/恢复机制解释清楚,力图从一个较深入的层次研究分析SQL SERVER 2005的事务日志以及基于事务日志的备份与恢复。
SQL SERVER 2005的備份/恢複功能錶麵上看似簡單,但實際上其實現機製相噹複雜併且微軟公司併沒有對外公佈其備份/恢複機製的具體實現細節。包括專業數據庫管理員在內很少有人能將SQL SERVER 2005的備份/恢複機製解釋清楚,力圖從一箇較深入的層次研究分析SQL SERVER 2005的事務日誌以及基于事務日誌的備份與恢複。
SQL SERVER 2005적비빈/회복공능표면상간사간단,단실제상기실현궤제상당복잡병차미연공사병몰유대외공포기비빈/회복궤제적구체실현세절。포괄전업수거고관리원재내흔소유인능장SQL SERVER 2005적비빈/회복궤제해석청초,력도종일개교심입적층차연구분석SQL SERVER 2005적사무일지이급기우사무일지적비빈여회복。
SQL SERVER 2005 backup and recovery function looks very simple on the surface, but in fact, the realization mechanism is very complex and Microsoft did not announce concrete implementation details of backup and recovery. Including professional database administrator, very few people can explain SQL SERVER backup/recovery's implementation details clearly, this paper strive to research and analysis of the SQL SERVER Transaction Log and backup and recovery based on the log of transaction from a deeper level.