###

DOI:

计算机系统应用英文版:2013,22(6):18-23,74

View/Add Comment 过刊浏览高级检索 HTML

←前一篇 | 后一篇→

码上扫一扫！

下载全文

SQL SERVER 2005基于事务日志的备份与恢复深入研究

向猛, 谢立靖

(湖南商务职业技术学院实训部, 长沙 410205)

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

XIANG Meng, XIE Li-Jing

(Training Department, Hunan Vocational College of Commerce, Changsha 410205, China)

摘要

图/表

参考文献

相似文献

本文已被：浏览 1495次下载 2933次
Received:November 01, 2012 Revised:December 02, 2012

中文摘要: SQL SERVER 2005的备份/恢复功能表面上看似简单, 但实际上其实现机制相当复杂并且微软公司并没有对外公布其备份/恢复机制的具体实现细节. 包括专业数据库管理员在内很少有人能将SQL SERVER 2005的备份/恢复机制解释清楚, 力图从一个较深入的层次研究分析SQL SERVER 2005的事务日志以及基于事务日志的备份与恢复.

中文关键词: 数据库管理系统备份恢复事务日志最小恢复日志序列号

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.

keywords: DBMS backup recovery transaction log minimum recovery LSN

文章编号： 中图分类号： 文献标志码：

基金项目:

Author Name	Affiliation
XIANG Meng	Training Department, Hunan Vocational College of Commerce, Changsha 410205, China
XIE Li-Jing	Training Department, Hunan Vocational College of Commerce, Changsha 410205, China

Author Name	Affiliation
XIANG Meng	Training Department, Hunan Vocational College of Commerce, Changsha 410205, China
XIE Li-Jing	Training Department, Hunan Vocational College of Commerce, Changsha 410205, China

引用文本：
向猛,谢立靖.SQL SERVER 2005基于事务日志的备份与恢复深入研究.计算机系统应用,2013,22(6):18-23,74
XIANG Meng,XIE Li-Jing.In-Depth Research of SQL SERVER 2005 Backup and Recovery Based on the Log of Transactions.COMPUTER SYSTEMS APPLICATIONS,2013,22(6):18-23,74