| 一种基于触发器技术的 SQL Server 数据库实时备份方案 |
| |
| 引用本文： | 周舟. 一种基于触发器技术的 SQL Server 数据库实时备份方案[J]. 广西科学院学报, 2009, 25(3): 210-212 |
| |
| 作者姓名： | 周舟 |
| |
| 作者单位： | 广西建设职业技术学院城市建设与交通工程系,广西南宁,530003 |
| |
| 摘 要： | 基于触发器技术的SQLServer数据库实时备份方案使用双机备份方式，根据触发器自动执行数据备份的代码和关系数据库存储数据变化前后的状态检索、数据变化痕迹，可以快捷地实现数据恢复，具有很强的实时性和直观性。
|
| 关 键 词： | 数据库 备份 触发器 |
| 收稿时间： | 2009-04-13 |
Real-time Backup Solution for SQL Server Database Based on Trigger Technique |
| |
| ZHOU Zhou. Real-time Backup Solution for SQL Server Database Based on Trigger Technique[J]. Journal of Guangxi Academy of Sciences, 2009, 25(3): 210-212 |
| |
| Authors: | ZHOU Zhou |
| |
| Affiliation: | ZHOU Zhou(Department of Urban Construction and Traffic Engineering, Guangxi Polytechnic of Construction, Nanning, Guangxi, 530003,China) |
| |
| Abstract: | SQL Server database real-time backup based on the trigger techniques is double sever backup method. Database automatically backup by running the special procedure deployed in the trigger and realizes database recovery rapidly according to the data states and the modification tracks stored in relation tables. It is shown that the proposed solution is real-time and intuitive. |
| |
| Keywords: | database backup trigger |
| 本文献已被 维普 万方数据 等数据库收录！ |
| 点击此处可从《广西科学院学报》浏览原始摘要信息 |
|
点击此处可从《广西科学院学报》下载免费的PDF全文 |
