aspnet 在线备份 SQL Server 数据库

aspnet 在线备份 SQL Server 数据库

http://hi.baidu.com/crestcloud/blog/item/77bac52a63e59b9a023bf60e.html

 

 

vb版本：

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 = "数据库备份"
     oBackup.Initialize = true
     oBackup.SQLBackup(oSQLServer)
     oSQLServer.DisConnect()
     Dim fi As System.IO.FileInfo = new System.IO.FileInfo("D:/Jnszf.bak")

c＃版本：

SQLDMO.Backup oBackup=new SQLDMO.BackupClass();
         SQLDMO.SQLServer oSQLServer=new SQLDMO.SQLServerClass();
         oSQLServer.LoginSecure=false;
         oSQLServer.Connect("localhost", "sa", "密码");
         oBackup.Action=SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
         oBackup.Database = "baoan";
         oBackup.Files = "D:/baoan.bak";
         oBackup.BackupSetName = "baoan";
         oBackup.BackupSetDescription = "保安数据库备份";
         oBackup.Initialize = true;
         oBackup.SQLBackup(oSQLServer);
         oSQLServer.DisConnect();
         System.IO.FileInfo fi= new System.IO.FileInfo("D:/baoan.bak");