2013Unpublished venueRequires access

In-Depth Research of SQL SERVER 2005 Backup and Recovery Based on the Log of Transactions

Xie Li

0 citations

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.

About this research paper

What this paper is about

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.

Why it matters

A significance statement is not available in the OpenAlex record.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available 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.

Key concepts: Backup, Log shipping, Computer science, Backup software, Autocommit, Transaction log, Data Transformation Services, User-defined function

Related papers

Back to paper searchBrowse research topicsOriginal source link unavailable
In-Depth Research of SQL SERVER 2005 Backup and Recovery Based on the Log of Transactions — Research Paper | ScholarLens