期待高手,如何用vb6.0实现sql数据库的备份和还原。(请付代码) 如何用vb6.0实现sql数据库的备份和还原。(请付代码) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 http://expert.csdn.net/Expert/FAQ/FAQ_Index.asp?id=144507 '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) 还原的时候连接master数据库,执行:restore database name from DISK='e:\backup\bak' Set Conn = New ADODB.ConnectionConn.ConnectionString = strCnnConn.Open’打开需导出数据库的表'开始备份(对整个数据库进行备份) SQL = "EXEC sp_addumpdevice 'disk', '" & sGetDate & "Database'," & _ "'" & sServerFile & "\BACKUP\" & sGetDate & "Database.dat'" SQL = SQL & " BACKUP DATABASE " & sInitialCatalog & " TO [" & sGetDate & "Database]"Conn.Execute SQL’还原数据库(此时应打开主表Master进行还原操作)Set Conn = New ADODB.Connection Conn.ConnectionString = strCnn Conn.Open'恢复数据库 SQL = "RESTORE DATABASE " & sInitialCatalog & " from [" & txtRestorePath.Text & "] " Conn.Execute SQL'sInitialCatalog 为当前数据库名 txtRestorePath.Text为Dat文件保存的路径 用SQL DEMO也一样的,在SQL的帮助联机从书里就有详细的例子 用SQLDMO实现备份http://expert.csdn.net/Expert/FAQ/FAQ_Index.asp?id=127326 为什么这样做是错的呢?请各位帮帮忙 获取WebBrowser滚动条的位置 文件命名 请看我这段在服务器上使用FSO的小代码如何修改?谢谢! 【小票打印】关于小票打印机打印方法。 在线等!好简单好简单的问题!一分钟搞定! 请教如何自动引用的问题 请教:调用系统文件! 这个问题能解决吗? 如何判断collection是否为空? 有关datagrid控件的问题 关于ACTIVEX DLL的问题,急急!
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)
还原的时候连接master数据库,执行:
restore database name from DISK='e:\backup\bak'
Conn.ConnectionString = strCnn
Conn.Open’打开需导出数据库的表'开始备份(对整个数据库进行备份)
SQL = "EXEC sp_addumpdevice 'disk', '" & sGetDate & "Database'," & _
"'" & sServerFile & "\BACKUP\" & sGetDate & "Database.dat'"
SQL = SQL & " BACKUP DATABASE " & sInitialCatalog & " TO [" & sGetDate & "Database]"
Conn.Execute SQL’还原数据库(此时应打开主表Master进行还原操作)
Set Conn = New ADODB.Connection
Conn.ConnectionString = strCnn
Conn.Open'恢复数据库
SQL = "RESTORE DATABASE " & sInitialCatalog & " from [" & txtRestorePath.Text & "] "
Conn.Execute SQL
'sInitialCatalog 为当前数据库名 txtRestorePath.Text为Dat文件保存的路径