Dim cn As New ADODB.Connection
cn.ConnectionString = "provider=SQLOLEDB;server=(local);uid=sa;pwd="
cn.CursorLocation = adUseClient
cn.Open
cn.Execute "BACKUP DATABASE ysgl TO DISK = 'c:\mssql7\backup\fdc.bak'" '备份数据库
MsgBox "备份成功!"
cn.Execute "RESTORE DATABASE ysgl FROM DISK = 'c:\mssql7\backup\fdc.bak' with replace " '恢复数据库
MsgBox "恢复成功!"
cn.Close: Set cn = Nothing
cn.ConnectionString = "provider=SQLOLEDB;server=(local);uid=sa;pwd="
cn.CursorLocation = adUseClient
cn.Open
cn.Execute "BACKUP DATABASE ysgl TO DISK = 'c:\mssql7\backup\fdc.bak'" '备份数据库
MsgBox "备份成功!"
cn.Execute "RESTORE DATABASE ysgl FROM DISK = 'c:\mssql7\backup\fdc.bak' with replace " '恢复数据库
MsgBox "恢复成功!"
cn.Close: Set cn = Nothing
cn.ConnectionString = "provider=SQLOLEDB;server=(local);uid=sa;pwd="