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.