asp.net在线备份SQL Server数据库
DimoBackupAsSQLDMO.Backup=newSQLDMO.BackupClass()
DimoSQLServerAsSQLDMO.SQLServer=newSQLDMO.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() DimfiAsSystem.IO.FileInfo=newSystem.IO.FileInfo("D:\Jnszf.bak") <!--Content End--> | |