期刊文献+
任意字段
题名或关键词
题名
关键词
文摘
作者
第一作者
机构
刊名
分类号
参考文献
作者简介
基金资助
栏目信息

SQL SERVER 2005基于事务日志的备份与恢复深入研究 被引量：3

In-Depth Research of SQL SERVER 2005 Backup and Recovery Based on the Log of Transactions
下载PDF
导出
摘要 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.
作者 向猛 谢立靖
机构地区 湖南商务职业技术学院实训部
出处 《计算机系统应用》 2013年第6期18-23,74,共7页 Computer Systems & Applications
关键词 数据库管理系统 备份 恢复 事务日志 最小恢复日志序列号 DBMS backup recovery transaction log minimum recovery LSN
分类号 TP311.138 [自动化与计算机技术—计算机软件与理论] TP309.3 [自动化与计算机技术—计算机系统结构]
  • 相关文献

参考文献10

  • 1Delaney K. Inside Microsoft SQL Server^TM 2005: The Storage Engine. US: Microsoft Press, 2006.
  • 2李爱武.SQL Server实例恢复中重做日志记录定位机制研究[J].现代计算机,2009,15(9):107-109. 被引量：2
  • 3Paul SR. Understanding SQL Server Backups. [2011-08-14]. http://teclmet.mierosoft.com/zh-cn/magazine/2009.07.sqlbac kup.aspx#MtViewDropDownText.
  • 4Suhas D. Truncating a Transaction Log File. [2011-12-21]. http://blogs.msdn.com/b/suhde/archive/2OOg/O7/18/revealing- the-secrets-mmcating-a-transaction-log-file.aspx.
  • 5Randal PS. Understanding Logging and Recovery in SQL Server. [2011-12-26]. http://technet.microsofl.com/en-us/ magazine/2009.02.1ogging.aspx.
  • 6Randal PS. Using fn dblog to tell if a transaction is contained in a backup. [2012-02-17]. http:// sqlskills.com/BLOGS/ PAUL/post/Scarch-Enginc-QA-6-Using-fn_dblog-to-tcU-if-a- transaction-is-containcd-in-a-backup.aspx.
  • 7Randal PS. How do checkpoints work and what gets logged. [2012-02-11 ].http://sqlskills.com/BLOGS/PAUL/post/How-do-checkpoints-work.aspx.
  • 8Raadal PS.Dcbunking a couple of myths around full database backups. [2012-02-11]. http://www.sqlskills.com/BLOGS/ PALIL/post/Dcbunking-a-couple-of-myths-around-full-databa sc-backups.aspx.
  • 9Randal PS. Morv on how much transaction log a full backup includes. [2012-04-18]. http://www.sqlskills.com/BLOGS/ PAUL/post/More-on-how-much-transaction-log-a-full-back up-includes.aspx.
  • 10宋云剑.SQLServer中灾难时备份结尾日志(Tailoflog)的两种方法.[2012-04-19].http://www.cnblogs.com/CareyS0n/archive/2012/02/23/2365006.html.

二级参考文献3

  • 1Kalen Delaney. Inside Microsoft SQL Server 2005: the Storage Engine, Microsoft Press, 2007.
  • 2Kalen Delaney. Inside Microsoft SQL Server 2005:Query Tuning and Optimization, Microsoft Press, 2007.
  • 3Ken Henderson. Guru's Guide to SQL Server Architecture and Internals, Addison Wesley Professional, 2004.

共引文献1

同被引文献10

  • 1黄志刚,郭玉东,杨宗博.文件级CDP的设计和实现[J].计算机应用,2008,28(S2):277-279. 被引量：2
  • 2WaUis J. Common causes for data loss. http://www.isnare. com/?aid=222505&ca=Computers+and+Technology. [2008- 10-08].
  • 3Patterson DA, Gibson C Katz RH. A case for redundant arrays of inexpensive disks (RAID). ACM, 1988:109-116.
  • 4Rock M, Poresky E Shorten your backup window. Special Issue on Managing the Information that Drives the Enterprise, 2005: 28-34.
  • 5Continuous data protection, https://snia.org/sites/default/files/ SNIA DMF V6 DPI_Guide_4WEB.pdf.
  • 6Flouris M, Bilas A. Clotho: transparent data versioning at the block I/O level. Proc. of the 21st IEEE/12th NASA Goddard Conference on Mass Storage Systems and Technologies. Washington, DC, USA. IEEE Computer Society. 2004: 315-328.
  • 7Wang C, Li ZH, Hu N, Nie YM. S-TRAP: Optimization and evaluation of timely recovery to any point-in-time (TRAP). Computer Science and Information Systems/ComSIS, 2012, 9(1): 431-454.
  • 8李爱武.SQL Server实例恢复中重做日志记录定位机制研究[J].现代计算机,2009,15(9):107-109. 被引量：2
  • 9邹先霞,贾维嘉,潘久辉.基于数据库日志的变化数据捕获研究[J].小型微型计算机系统,2012,33(3):531-536. 被引量：19
  • 10余晓娜.浅谈SQL Server 2005数据库备份与还原[J].电脑知识与技术（过刊）,2014,20(7X):4654-4656. 被引量：2

引证文献3

二级引证文献5

计算机系统应用
2013年 第6期

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

内容加载中请稍等...
;
使用帮助 返回顶部