| 基于SQLDMO的数据库备份与恢复的实现 |
| |
| 引用本文： | 邵国强,郝凤鹰,杨晓刚,邵国东.基于SQLDMO的数据库备份与恢复的实现[J].佳木斯大学学报,2006,24(4):495-497. |
| |
| 作者姓名： | 邵国强 郝凤鹰 杨晓刚 邵国东 |
| |
| 作者单位： | 大庆师范学院计算机系,黑龙江,大庆,163712;胜利油田渤海钻井总公司钻前公司劳资办公室,山东,东营,257200;大庆市房屋产权市场管理中心,黑龙江,大庆,163316;吉林建工学院勘测公司,吉林,长春,130721 |
| |
| 基金项目： | 石油石化软件火炬计划项目 |
| |
| 摘 要： | 介绍了数据库备份与恢复的基本方法,特别是封装数据库操作的作用.以SQL Server2000为例,在ASP.NET(C#语言)环境下实现了基于SQLDMO的数据库备份和还原.分析了备份和还原的几种方法、选择策略和SQLDMO的功能.详细给出了备份和还原的具体思路和类实现,存储过程和游标在还原中的应用.
|
| 关 键 词： | 分布式管理对象 备份与恢复 存储过程 游标 |
| 文章编号： | 1008-1402（2006）04-0495-03 |
| 收稿时间： | 2006-08-08 |
| 修稿时间： | 2006年8月8日 |
The Implementation to Backup and Restore the Database Based on SQLDMO |
| |
| SHAO Guo- qiang, HAO Feng - ying.The Implementation to Backup and Restore the Database Based on SQLDMO[J].Journal of Jiamusi University(Natural Science Edition),2006,24(4):495-497. |
| |
| Authors: | SHAO Guo- qiang HAO Feng - ying |
| |
| Institution: | 1. Computer Department, Daqing Normal University, Daqing 163712, China; 2. Labor datum of Before- drilling company, Bohai drilling head orifice, Shengoli oilfldd, Dongying 257200, China |
| |
| Abstract: | In this article,we introduce the basic methods to backup and restore the database,especially,the function of encapsulating operations provided by database.SQL Server2000 is taken as an example to show how to backup and restore the database based on SQLDMO in C#,which is one of the languages supported by ASP.NET.We anglicize several methods to backup and restore database,the strategies to choose them,and the functions of SQLDMO.Finally,the detailed idea and class implementation to backup and restore database as well as the application of stored procedure and cursor in restoring database are given. |
| |
| Keywords: | SQLDMO backup and restore stored procedure cursor |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
