備份SQL,在網上找到的,很簡單,不錯!

用asp.net線上備份SQL Server資料庫

當然要用到 sqldmo 來做這個工作 找到 sqldmo.dll這個檔案 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqldmo.dll 用.Net架構提供的工具轉成受託管代碼 tlbimp sqldmo.dll /out: c:\SQLDMO.dll 這樣就可以如下例所示引用了 <%@ Import Namespace="SQLDMO" %> 具體代碼如下     Dim oBackup As SQLDMO.Backup = new SQLDMO.BackupClass()     Dim oSQLServer As SQLDMO.SQLServer = new SQLDMO.SQLServerClass()     oSQLServer.LoginSecure = false     oSQLServer.Connect("localhost", "sa", "密碼")     oBackup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database     oBackup.Database = "資料庫"     oBackup.Files = "D:\Jnszf.bak"     oBackup.BackupSetName = "資料庫"     oBackup.BackupSetDescription = "Database Backup"     oBackup.Initialize = true     oBackup.SQLBackup(oSQLServer)     oSQLServer.DisConnect()     Dim fi As System.IO.FileInfo = new System.IO.FileInfo("D:\Jnszf.bak")