vb中能进行数据库备份吗? DBEngine.CompactDatabase "old.mdb", "new.mdb", dbLangGeneral 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 SQL Server可以使用SQL-DMO来做:恢复数据库:Private Sub Command2_Click() Dim sFile As String sFile = "N_1" Dim oServer As New SQLDMO.SQLServer Dim oDatabase As New SQLDMO.Database Dim oRestore As New SQLDMO.Restore oServer.Connect servername, username, password With oRestore .Files = sFile .Database = "Northwind" .ReplaceDatabase = True .SQLRestore oServer End With Set oRestore = Nothing Set oDatabase = Nothing oServer.DisConnect Set oServer = Nothing MsgBox ("OK") End Sub备份:Dim oBackup As New SQLDMO.BackupoBackup.Action = SQLDMOBackup_DatabaseoBackup.Database = "Northwind"oBackup.Devices = "[NorthDev1],[NorthDev2]"oBackup.BackupSetName = "Northwind_Full"oBackup.BackupSetDescription = "Full backup of Northwind sample."oBackup.SQLBackup oSQLServer如果你按照上述方法做好一个通用的过程把原代码给我看看!!我也是抄来的我不懂vb,[email protected]或[email protected] 我可不可以问你一个问题(请教关于有vb程序在sqlsever中创建视图):我写了这样的语句:sql12 = "CREATE VIEW dbjl1" & _ " AS" & _ " SELECT dbjl.jmh AS jmh1, jmk.jj AS jj1, jmk.bt AS bt1, jmk.gslx" & _ " FROM dbjl INNER JOIN" & _ " jmk ON dbjl.jmh = jmk.jmh"执行后,总出现这样的错误: 实时错误'-2147217865(80040e37)': [microsoft][odbc sql server driver][sql server] invalod object name 'gbzb' 我刚刚作完数据库备份,运行通过,供你参考:If cn.State = adStateOpen Then cn.Close cn.ConnectionTimeout = 10 connstr = "Driver={SQL Server};Server=" & LocalServer & ";UID=" & LocalUser & ";PWD=" & LocalPw & ";DATABASE=" & LocalDb cn.Open connstrdd = Datesql = "BACKUP DATABASE xhj TO disk='D:\mssql7\backup\xhj" & Trim(dd) & "'"cn.Execute (sql) 当然可以进行备份,只要调用T-SQL构成的stored procedure即可 VB检查字符串里面不含星号和问号 怎么处理? 初学者请教~关于建立数据库表格列数和列名未定的问题,急! 节日快乐 [急!]如何响应运行添加的控件的事件 Visual Basic 6编程技术大全 配套光盘哪儿有下??? 请各位帮忙啊!找一本书,进来者都有分! vb 调用Access2000创建的查询遇到麻烦。 如何制作判断是否关闭窗口的事件?? 请问如何在IE中加一个自己程序的菜单,在右键中也增加一个? 我的6.0一半简体中文,一半繁体中文,咋办? 这个问题本不该贴在这里,但我贴在其它区半天没人理我.只想请教一下经验.不过加分不一定加得了. 这是DataGrid的Bug吗?
恢复数据库:
Private Sub Command2_Click()
Dim sFile As String
sFile = "N_1"
Dim oServer As New SQLDMO.SQLServer
Dim oDatabase As New SQLDMO.Database
Dim oRestore As New SQLDMO.Restore
oServer.Connect servername, username, password
With oRestore
.Files = sFile
.Database = "Northwind"
.ReplaceDatabase = True
.SQLRestore oServer
End With
Set oRestore = Nothing
Set oDatabase = Nothing
oServer.DisConnect
Set oServer = Nothing
MsgBox ("OK")
End Sub备份:
Dim oBackup As New SQLDMO.Backup
oBackup.Action = SQLDMOBackup_Database
oBackup.Database = "Northwind"
oBackup.Devices = "[NorthDev1],[NorthDev2]"
oBackup.BackupSetName = "Northwind_Full"
oBackup.BackupSetDescription = "Full backup of Northwind sample."oBackup.SQLBackup oSQLServer
如果你按照上述方法做好一个通用的过程把原代码给我看看!!
我也是抄来的我不懂vb,
[email protected]或[email protected]
我写了这样的语句:sql12 = "CREATE VIEW dbjl1" & _
" AS" & _
" SELECT dbjl.jmh AS jmh1, jmk.jj AS jj1, jmk.bt AS bt1, jmk.gslx" & _
" FROM dbjl INNER JOIN" & _
" jmk ON dbjl.jmh = jmk.jmh"
执行后,总出现这样的错误:
实时错误'-2147217865(80040e37)':
[microsoft][odbc sql server driver][sql server]
invalod object name 'gbzb'
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
dd = Date
sql = "BACKUP DATABASE xhj TO disk='D:\mssql7\backup\xhj" & Trim(dd) & "'"
cn.Execute (sql)