| 摘要: |
| 基于触发器技术的SQL Server数据库实时备份方案使用双机备份方式,根据触发器自动执行数据备份的代码和关系数据库存储数据变化前后的状态检索、数据变化痕迹,可以快捷地实现数据恢复,具有很强的实时性和直观性。 |
| 关键词: 数据库 备份 触发器 |
| DOI： |
| 投稿时间：2009-04-13 |
| 基金项目:广西社科基金项目(06FTQ002)资助。 |
|
| Real-time Backup Solution for SQL Server Database Based on Trigger Technique |
|
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. |
| Key words: database backup trigger |
