如何用代码实现数据库的备份与恢复 谢谢,up者有分 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 sql server 7种的备份方法If cn.State = adStateOpen Then cn.Close cn.ConnectionTimeout = 10 connstr = "Driver={SQL Server};Server=" & LocalServer & ";UID=" & LocalUser & ";PWD=" & LocalPw & ";DATABASE=" & LocalDb cn.Open connstrNowtime = Format(Now, "hh-mm-ss")dd = Str(Date)riqi = dd + "-" + NowtimeSQL = "BACKUP DATABASE tablename TO disk='D:\mssql7\BACKUP\tablename" & riqi & "' with noinit"cn.Execute (SQL) sql server 7种的备份方法If cn.State = adStateOpen Then cn.Close cn.ConnectionTimeout = 10 connstr = "Driver={SQL Server};Server=" & LocalServer & ";UID=" & LocalUser & ";PWD=" & LocalPw & ";DATABASE=" & LocalDb cn.Open connstrNowtime = Format(Now, "hh-mm-ss")dd = Str(Date)riqi = dd + "-" + NowtimeSQL = "BACKUP DATABASE tablename TO disk='D:\mssql7\BACKUP\tablename" & riqi & "' with noinit"cn.Execute (SQL)http://expert.csdn.net/Expert/topic/1617/1617533.xml?temp=.3604853 我这儿都收着呢:http://expert.csdn.net/Expert/topic/1602/1602588.xml?temp=.5743524 谢谢楼上的.如何备份access数据库呢 拷贝文件.mdb 就可以filecopy "c:\a.mdb","d:\a.mdb" 如何用代码动态添加vsFlexGrid??急在线等 请会水晶报表的高手进来指教一下,小弟遇到一打印方面的问题,请帮帮忙谢谢!! 关于菜单问题,大家帮帮,谢谢!! 子类化mshflexgrid问题 超级搞笑的计算机管理人员对白 四个角角了,散点分-贴中提到的网友来领分(没提的也可,大家不要说倒分啊。UP无分) 谁能帮我,一定给分! VB做读取电表总电量的程序。求大哥帮忙 滚动条显示问题(送分) 请问谁能帮我的忙?多谢! 求购套打报表工具源码,或者与我公司合作按单购买成熟套打软件(另需要财务同上) VB与EXCEL报表
If cn.State = adStateOpen Then cn.Close
cn.ConnectionTimeout = 10
connstr = "Driver={SQL Server};Server=" & LocalServer & ";UID=" & LocalUser & ";PWD=" & LocalPw & ";DATABASE=" & LocalDb
cn.Open connstr
Nowtime = Format(Now, "hh-mm-ss")
dd = Str(Date)
riqi = dd + "-" + NowtimeSQL = "BACKUP DATABASE tablename TO disk='D:\mssql7\BACKUP\tablename" & riqi & "' with noinit"
cn.Execute (SQL)
If cn.State = adStateOpen Then cn.Close
cn.ConnectionTimeout = 10
connstr = "Driver={SQL Server};Server=" & LocalServer & ";UID=" & LocalUser & ";PWD=" & LocalPw & ";DATABASE=" & LocalDb
cn.Open connstr
Nowtime = Format(Now, "hh-mm-ss")
dd = Str(Date)
riqi = dd + "-" + NowtimeSQL = "BACKUP DATABASE tablename TO disk='D:\mssql7\BACKUP\tablename" & riqi & "' with noinit"
cn.Execute (SQL)
http://expert.csdn.net/Expert/topic/1617/1617533.xml?temp=.3604853
http://expert.csdn.net/Expert/topic/1602/1602588.xml?temp=.5743524