62,041
社区成员
发帖
与我相关
我的任务
分享
protected void Button1_Click(object sender, EventArgs e)
{
SQLDMO.Backup oBackup = new SQLDMO.BackupClass();
SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
try
{
oSQLServer.LoginSecure = false;
oSQLServer.Connect("localhost", "sa", "daili");
oBackup.Action = SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
oBackup.Database = "electricity";
oBackup.Files = @Server.MapPath("/images/");
oBackup.BackupSetName = "electricity";
oBackup.BackupSetDescription = DateTime.Now.ToString();
oBackup.Initialize = true;
oBackup.SQLBackup(oSQLServer);
}
catch (Exception ex)
{
throw ex;
}
finally
{
oSQLServer.DisConnect();
}
}