需要加入SQL的Com+组件才可用,又学一老大的一招啊.
private void Back()
{
try
{
if(!Directory.Exists(Server.MapPath("../backDate/")))
{
Directory.CreateDirectory(Server.MapPath("../backDate/"));
}
PBackup.Initialize = true;
SQLDMO.SQLServer SQLSER=new SQLDMO.SQLServerClass();
SQLSER.Connect("127.0.0.1","sa","");
PBackup.Database = "pubs";
string filename="back"+DateTime.Now.Year+"_"+System.DateTime.Now.Month+"_"+DateTime.Now.Day+".rbk";
PBackup.Files = Server.MapPath("../backDate/")+filename;
PBackup.SQLBackup(SQLSER);
SQLSER.DisConnect();
Response.Write("<script>window.alert('成功备份!');window.location='ControlPm.aspx'</script>");
}
catch
{
Response.Write("<script>window.alert('备份失败,请检查源数据库是否存在、角色权限是否足够或SQL SERVER服务是否被打开');");
}