如果用vb备份sql server的数据库啊? 要安装SQL的客户端。http://www.csdn.net/expert/Topic/450/450108.shtm 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 回复人: i_need_mana(小岭) ( ) 信誉:100 2002-3-19 13:46:56 得分:20 VB:Private Sub Command1_Click()connectit_1 cn_w Dim cmd_bp As ADODB.Command Set cmd_bp = New ADODB.Command Set cmd_bp.ActiveConnection = cn_w cmd_bp.CommandTimeout = 900 sql = "backupit" cmd_bp.CommandText = sql cmd_bp.Execute Set cmd_bp = Nothing closeit cn_wEnd SubPrivate Function connectit_1(ByRef cn) Set cn = CreateObject("ADODB.Connection") Connstring = "Provider=SQLOLEDB.1;Password=1245;" & _ "User ID=sa;" & _ "database=yourdb;" & _ "server=yourserver;Connect Timeout=15" cn.Open ConnstringEnd FunctionPrivate Function closeit(ByRef cn) cn.Close Set cn = NothingEnd FunctionSP:restoreCREATE PROCEDURE Loaddata @databasenm varchar(30),@pathnm varchar(100) ASdeclare @sql varchar(500)select @sql="restore database "+@databasenm+" from disk='"+@pathnm+"' WITH replace"execute(@sql)backup:CREATE PROCEDURE backupit @databasenm varchar(30),@pathnm varchar(100) ASselect @sql="backup database "+@databasenm+" to disk='"+@pathnm+".bak' WITH INIT"execute(@sql) 求sql句法:更新字段数据为原有数据+新数据 晕,刚写错了一点,关于Trigger的问题? 老是不能安装sql server 2000 送20分来了,统计两个表的记录数 sql脚本生成数据库的问题 查询 周,月 的问题 局域网类的2台sql不连接 关于票号的处理,通过库存信息和已使用的信息,算出还可以使用的票号信息 为什么自建的表是无效的啊? 还是链接服务器! ::把一个表中的数据导出到一个excel文件中的存储过程应该怎么写:: sql server的数据自动备份问题7.0??(刚才发的那个为什么是空的没找到?????)
VB:
Private Sub Command1_Click()
connectit_1 cn_w
Dim cmd_bp As ADODB.Command
Set cmd_bp = New ADODB.Command
Set cmd_bp.ActiveConnection = cn_w
cmd_bp.CommandTimeout = 900
sql = "backupit"
cmd_bp.CommandText = sql
cmd_bp.Execute
Set cmd_bp = Nothing
closeit cn_wEnd Sub
Private Function connectit_1(ByRef cn)
Set cn = CreateObject("ADODB.Connection")
Connstring = "Provider=SQLOLEDB.1;Password=1245;" & _
"User ID=sa;" & _
"database=yourdb;" & _
"server=yourserver;Connect Timeout=15"
cn.Open ConnstringEnd FunctionPrivate Function closeit(ByRef cn)
cn.Close
Set cn = Nothing
End FunctionSP:
restore
CREATE PROCEDURE Loaddata
@databasenm varchar(30)
,@pathnm varchar(100)
AS
declare @sql varchar(500)
select @sql="restore database "+@databasenm+" from disk='"+@pathnm+"' WITH replace"
execute(@sql)backup:
CREATE PROCEDURE backupit
@databasenm varchar(30)
,@pathnm varchar(100)
AS
select @sql="backup database "+@databasenm+" to disk='"+@pathnm+".bak' WITH INIT"
execute(@sql)