关于数据库备份的问题? VB中如何通过SQLDMO对象实现数据库的备份? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 '参考一下 '需要添加一个commondialog控件On Error GoTo errnum dlg.CancelError = True cn1.Execute "use master" dlg.Filter = "(*.bak)|*.bak" dlg.ShowSave MousePointer = 11 cn1.Execute "BACKUP DATABASE databasename TO DISK = '" & dlg.FileName & "'" '备份数据库 MousePointer = 0 Set cn1 = Nothing '重新建立连接errnum: Set cn1 = New ADODB.Connection cn1.Open "Driver={SQL Server};Server=" & SQL_SRV & ";Uid=" & SA & ";Pwd=" & PA & ";Database=" & SJK & "" CSDN上真的没人了吗?自己顶一下! '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 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 的备份方法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) --------------------------------------------------------------- 添加进度条ProgressBar1控件 引用Microsoft SQLDMO Object Library '声明 Public WithEvents bkps As SQLDMO.Backup '数据库备份操作 Private Sub Command3_Click() Dim oSvr As SQLDMO.SQLServer Set oSQLServer = CreateObject("SQLDMO.SQLServer") oSQLServer.LoginSecure = False oSQLServer.Connect ("(local)"), ("sa"), ("")'连接服务器 Screen.MousePointer = 11 Set bkps = CreateObject("SQLDMO.Backup") bkps.Database = "db"'指定需备份的数据库 bkps.Action = 0 bkps.Files = "c:\backup\db.bak"'指定备份文件 bkps.Initialize = True ProgressBar1.Value = 0 ProgressBar1.max = 100 Screen.MousePointer = 0 DoEvents Err = 0 bkps.SQLBackup oSQLServer Screen.MousePointer = 11 ProgressBar1.Value = 100 DoEvents Set bkps = Nothing Screen.MousePointer = 0 MsgBox "数据库备份完成" End Sub '显示进度 Private Sub bkps_PercentComplete(ByVal Message As String, ByVal Percent As Long) ProgressBar1.Value = ProgressBar1.max * (Percent / 100) End Sub 恢复的时候连接master数据库cn.execute "restore Database xxx from disk='d:\......... 菜鸟请高手帮忙,access两个数据库的数据插入问题 【求代码】 VB提取EXE图标资源 如何在软件中嵌入关机功能? 在vb中如何得到excle的图表中的SourceData 如何象FPE一样,在游戏中用热键激活后,自动取得游戏进程? 急、急、急问题,简单问题,请各位帮忙! 关于用VB连接硬件的问题 on error 拦截错误为何只能成功一次? 放分了 各位大虾,vb中是否有定义矩阵的控件?谢谢*999次 ★★★★★★★★★★★★★★★★★★★散完分,将废出此ID.以免被认为是倒分者.希望victorycyz(中海)正名给我.★★★★★ 各位高手,请教如何读AUTOCAD文件?
'需要添加一个commondialog控件
On Error GoTo errnum
dlg.CancelError = True
cn1.Execute "use master"
dlg.Filter = "(*.bak)|*.bak"
dlg.ShowSave
MousePointer = 11
cn1.Execute "BACKUP DATABASE databasename TO DISK = '" & dlg.FileName & "'" '备份数据库
MousePointer = 0
Set cn1 = Nothing
'重新建立连接
errnum:
Set cn1 = New ADODB.Connection
cn1.Open "Driver={SQL Server};Server=" & SQL_SRV & ";Uid=" & SA & ";Pwd=" & PA & ";Database=" & SJK & ""
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)
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)
添加进度条ProgressBar1控件
引用Microsoft SQLDMO Object Library
'声明
Public WithEvents bkps As SQLDMO.Backup
'数据库备份操作
Private Sub Command3_Click()
Dim oSvr As SQLDMO.SQLServer
Set oSQLServer = CreateObject("SQLDMO.SQLServer")
oSQLServer.LoginSecure = False
oSQLServer.Connect ("(local)"), ("sa"), ("")'连接服务器
Screen.MousePointer = 11
Set bkps = CreateObject("SQLDMO.Backup")
bkps.Database = "db"'指定需备份的数据库
bkps.Action = 0
bkps.Files = "c:\backup\db.bak"'指定备份文件
bkps.Initialize = True
ProgressBar1.Value = 0
ProgressBar1.max = 100
Screen.MousePointer = 0
DoEvents
Err = 0
bkps.SQLBackup oSQLServer
Screen.MousePointer = 11
ProgressBar1.Value = 100
DoEvents
Set bkps = Nothing
Screen.MousePointer = 0
MsgBox "数据库备份完成"
End Sub
'显示进度
Private Sub bkps_PercentComplete(ByVal Message As String, ByVal Percent As Long)
ProgressBar1.Value = ProgressBar1.max * (Percent / 100)
End Sub