如何在vc程序中备份还原sqlserver数据库???????[在线等待]. 如何在vc程序中备份还原sqlserver数据库?[在线等待]. 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 如果是sql sever按下面做就行了备份: CDatabase db; CString s1; s1.Format("ODBC;UID=sa;PWD=%s","wei147"); db.Open("odbcname",false,false,s1); s1.Format("backup database report to disk='e:\\report.bak\\backs.dat'"); //备份到E:\report.bak\backs.dat db.ExecuteSQL(s1); 恢复: 恢复时用户不能连接要恢复的数据库,这非常重要. CDatabase db1; s1.Format("ODBC;UID=sa;PWD=%s","wei147"); db1.Open("odbcname",false,false,s1); s1.Format("restore database report from disk='c:\\report.bak\\backs.dat'"); db1.ExecuteSQL(s1); db1.Close(); 使用SQL本身的备份存储过程BACKUP DATABASE { database_name | @database_name_var } TO < backup_device > [ ,...n ] [ WITH [ BLOCKSIZE = { blocksize | @blocksize_variable } ] [ [ , ] DESCRIPTION = { 'text' | @text_variable } ] [ [ , ] DIFFERENTIAL ] [ [ , ] EXPIREDATE = { date | @date_var } | RETAINDAYS = { days | @days_var } ] [ [ , ] PASSWORD = { password | @password_variable } ] [ [ , ] FORMAT | NOFORMAT ] [ [ , ] { INIT | NOINIT } ] [ [ , ] MEDIADESCRIPTION = { 'text' | @text_variable } ] [ [ , ] MEDIANAME = { media_name | @media_name_variable } ] [ [ , ] MEDIAPASSWORD = { mediapassword | @mediapassword_variable } ] [ [ , ] NAME = { backup_set_name | @backup_set_name_var } ] [ [ , ] { NOSKIP | SKIP } ] [ [ , ] { NOREWIND | REWIND } ] [ [ , ] { NOUNLOAD | UNLOAD } ] [ [ , ] RESTART ] [ [ , ] STATS [ = percentage ] ] ]备份特定的文件或文件组:BACKUP DATABASE { database_name | @database_name_var }还原整个数据库:RESTORE DATABASE { database_name | @database_name_var } 还原数据库的部分内容:RESTORE DATABASE { database_name | @database_name_var } 或者在后台使用BUCK和BCP命令后台备份数据库的表 MFC 请教关于升级程序中的文件日期? 多语言的问题:如何在一个ANSI文本文件中同时正确显示中文和日文 请教怎样在VC构造函数中初始化常量 我是VC++6.0初学者,怎样能够快速上手呢? 送分100!!!!!!!(能不能用web实现 视频适时监控) 高分求教:POP3的命令RETR 谁知道怎么想IE工具栏上加控件啊? 在VC环境下Debug,如何给Exe加命令行参数? 如何获取最新纪录中某个字段的值(ODBC+Access) 一个关于VC消息映射的问题 要做一个在网关截取数据报,并在数据区搜索关键字的东西。但是菜,没辙,。
备份:
CDatabase db;
CString s1;
s1.Format("ODBC;UID=sa;PWD=%s","wei147");
db.Open("odbcname",false,false,s1);
s1.Format("backup database report to disk='e:\\report.bak\\backs.dat'"); //备份到E:\report.bak\backs.dat
db.ExecuteSQL(s1);
恢复:
恢复时用户不能连接要恢复的数据库,这非常重要.
CDatabase db1;
s1.Format("ODBC;UID=sa;PWD=%s","wei147");
db1.Open("odbcname",false,false,s1);
s1.Format("restore database report from disk='c:\\report.bak\\backs.dat'");
db1.ExecuteSQL(s1);
db1.Close();
BACKUP DATABASE { database_name | @database_name_var }
TO < backup_device > [ ,...n ]
[ WITH
[ BLOCKSIZE = { blocksize | @blocksize_variable } ]
[ [ , ] DESCRIPTION = { 'text' | @text_variable } ]
[ [ , ] DIFFERENTIAL ]
[ [ , ] EXPIREDATE = { date | @date_var }
| RETAINDAYS = { days | @days_var } ]
[ [ , ] PASSWORD = { password | @password_variable } ]
[ [ , ] FORMAT | NOFORMAT ]
[ [ , ] { INIT | NOINIT } ]
[ [ , ] MEDIADESCRIPTION = { 'text' | @text_variable } ]
[ [ , ] MEDIANAME = { media_name | @media_name_variable } ]
[ [ , ] MEDIAPASSWORD = { mediapassword | @mediapassword_variable } ]
[ [ , ] NAME = { backup_set_name | @backup_set_name_var } ]
[ [ , ] { NOSKIP | SKIP } ]
[ [ , ] { NOREWIND | REWIND } ]
[ [ , ] { NOUNLOAD | UNLOAD } ]
[ [ , ] RESTART ]
[ [ , ] STATS [ = percentage ] ]
]
备份特定的文件或文件组:BACKUP DATABASE { database_name | @database_name_var }还原整个数据库:RESTORE DATABASE { database_name | @database_name_var } 还原数据库的部分内容:RESTORE DATABASE { database_name | @database_name_var }
或者在后台使用BUCK和BCP命令后台备份数据库的表