| 用VB实现数据库的备份与恢复 |
| |
| 引用本文： | 孙汪泉,刘志勤,王洪涛.用VB实现数据库的备份与恢复[J].兵工自动化,2003,22(2):58-60. |
| |
| 作者姓名： | 孙汪泉 刘志勤 王洪涛 |
| |
| 作者单位： | 1. 西南科技大学,计算机科学学院,四川,绵阳,621002
2. 山东经济学院,计算机管理系,山东,济南,250014 |
| |
| 摘 要： | 使用VB通过调用MS SQL SERVER 2000提供的编程接口，可实现数据库的备份与恢复。完全、差异、日志、文件或文件组等备份可调用MS SQL SCRVER接口命令直接完成。数据库恢复的必要条件是备份文件及其路径。其过程是：连接msster数据库，强行关掉访问该数据库的其他进程，选择备份文件的记录，通过其ID号查找备份文件及其路径，再调用恢复命令恢复备份文件。
|
| 关 键 词： | VB 数据库 备份 恢复 “MS SQL SERVER” master数据库 |
| 文章编号： | 1006-1576(2003)02-0058-03 |
| 修稿时间： | 2002年11月28日 |
Backup and Restore Database Realized by Visual Basic |
| |
| SUN Wang-Quan,LIU Zhi-qin,WANG Hong-tao.Backup and Restore Database Realized by Visual Basic[J].Ordnance Industry Automation,2003,22(2):58-60. |
| |
| Authors: | SUN Wang-Quan LIU Zhi-qin WANG Hong-tao |
| |
| Affiliation: | SUN Wang-Quan1,LIU Zhi-qin1,WANG Hong-tao2 |
| |
| Abstract: | The backup and restoring of database is implemented by Visual Basic via program interface that provided by MS SQL SERVER 2000 itself. The backup of full log and file or file group is completed with MS SQL SERVER. The requirement of restoring database is that restoring interface of database has self reductive item? Select backup file needs to restore in restoring interface of database. Its processes are that closes other process accessed the database, select the record of backup file, the name and backup path of database needs to backup is searched by using ID, and then restore full backup, difference, log and file backup. Restoring command implements connection between the database and master database. |
| |
| Keywords: | Backup Restore Database MS SQL SERVER |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
