In-Depth Research of SQL SERVER 2005 Backup and Recovery Based on the Log of Transactions
Xie Li
Abstract
Xie Li
Abstract
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.
A significance statement is not available in the OpenAlex record.
A contribution statement is not available in the OpenAlex record.
Method details are not available in the OpenAlex metadata.
Findings are not separately available in the OpenAlex metadata.
Limitations are not available in the OpenAlex metadata.
Application details are not available in the OpenAlex metadata.
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.
Key concepts: Backup, Log shipping, Computer science, Backup software, Autocommit, Transaction log, Data Transformation Services, User-defined function