如何用VB代码实现对mssql数据库的备份和恢复? 请高手指点 解决方案 » 免费领取超大流量手机卡,每月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) restore DATABASE .........恢复 listview列?~达人来 急急急 excel取值问题。。 MSHFlexGrid能否实现不相邻的多行标题栏 如何确定check1的选定数目 VB编的程序在英文版XP下汉字显示不出 请问三层构造到底是什么意思呀?怎样才能领悟思想结构体系? 如何替换包含了六个图的图标啊? VB中如何动态调用dll 将一个recordset赋予 DataGrid 的问题? 小弟,迷茫困惑中,请各位大虾多多指教! 有关msflexgrid的一个问题 如何用代码实现和sql server 数据库的连接?
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)