VB做程序时如何对SQL SERVER 数据库进行备份? 实战用过的方法.
解决方案 »
- 发现Camtasia Studio、Adobe Acrobat 7等软件的有些窗口上下高度超过屏幕高度,使得最下面一排的按钮看不到无法操作,只能将任务条改为隐藏才能勉强的操作到,怎么办?这总不是软件开发者故意这样做,造成我们操作不方便吧?
- 轻松拿50分,关于获取数据库主键问题
- VB新手,做练习遇到几个小问题,希望大家能帮帮忙,小弟感激不尽
- 关于把数据导入到DataGrid中的问题
- ado连接字符串问题????????????????????????????
- 请问各位高手如何用print语句在屏幕的预定位置输出
- 如何写从表中读取随机10条记录的SQL语句?或者是方法,或存储过程(在线等待)
- 串口接受到一个中断信号??
- 怎样能够最简单的执行写好的SQL语句?
- .gif文件可以加载到VB窗体吗?
- vb能连informix数据库吗?怎么连?
- 如何设置NTFS权限
建议先建一个excel或者acess表,然后将数据库内容导出到所建的表中。
最后再将把表的内容导入就可以了。推荐用excel,因为这个对所建的表的字符类型没有什么限制,而acess可能对都是char类型的比较好,但其它的类型有时候无法全部导入
strDate = Format(Now, "yyyymmddHhNnSs")
strSQL = "BACKUP database " & DatabaseName & " TO DISK='" _
& strPath & DatabaseName & strDate & ".bak'" _
& " WITH RESTART"
strServer = GetINI(gstrCurrPath & DSNINIFile, "Database", "Server", "?")
If strServer = "?" Then
Me.MousePointer = 0
MsgBox "服务器信息已被损坏,程序将用缺省值进行修复!", vbExclamation, "提示"
strServer = "(local)"
Me.MousePointer = 11
End If
CloseRS
Set con = New ADODB.Connection
con.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=master;Server=" & strServer
con.Open
con.Execute strSQL
Me.MousePointer = 0
strSQLRestore = "RESTORE DATABASE " & DatabaseName & " FROM DISK = '" _
& strPath & File1.FileName _
& "' with" _
& " MOVE '" & DatabaseName & "_data' TO '" _
& gstrCurrPath & DatabaseDir & DatabaseName & "_data.mdf'" _
& ",MOVE '" & DatabaseName & "_log' TO '" _
& gstrCurrPath & DatabaseDir & DatabaseName & "_log.ldf'" _
& ",replace,restart"
If Dir(strPath & DatabaseName & "_data.MDF", vbNormal) <> "" Then
Kill strPath & DatabaseName & "_data.MDF"
End If
strServer = GetINI(gstrCurrPath & DSNINIFile, "Database", "Server", "?")
If strServer = "?" Then
Me.MousePointer = 0
MsgBox "服务器信息已被损坏,程序将用缺省值进行恢复!", vbExclamation, "提示"
strServer = "(local)"
Me.MousePointer = 11
End If
CloseRS
' GCon.Close
Set GCon = Nothing
Set con = New ADODB.Connection
con.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=master;Server=" & strServer
con.Open
con.Execute strSQLRestore
con.Close
Set con = Nothing
ConnectDatabase GCon
Me.MousePointer = 0
MsgBox "数据库恢复成功!", vbInformation, "祝贺"
请问如果是oracle数据库改如何操作?