Utility/Back.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace Utility
{
   public class Back
    {
        public static string conStr = ConfigurationManager.ConnectionStrings["connStr"].ToString().ToLower();//需要引用System.Configuration组件
        public void Backup()
        {
            SQLDMO.Backup oBackup = new SQLDMO.BackupClass();//用SQLDMO可以实现对数据库的备份与恢复，首先需要添加对SQLDMO引用MIcrosoft SQLMDO Object Library组件(com组件)
            SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
            try
            {

                //Integrated Security=True
                if (conStr.Contains("integrated security"))
                {
                    oSQLServer.LoginSecure = true;//True 是混合验证模式  FALSE 是sql server验证模式

                    oSQLServer.Connect(".", null, null);
                }
                else
                {
                    string Uid = conStr.Substring(conStr.IndexOf("uid"));

                    Uid = Uid.Substring(0, Uid.IndexOf(";")).Split('=')[1];
                    string Pwd = conStr.Substring(conStr.IndexOf("pwd"));
                    Pwd = Pwd.Substring(0, Pwd.IndexOf(";")).Split('=')[1];

                    oSQLServer.LoginSecure = false;//True 是混合验证模式  FALSE 是sql server验证模式

                    oSQLServer.Connect(".", Uid, Pwd);

                }
                oBackup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;//声明备份整个数据库
                oBackup.Database = "ExamdaSys";
                oBackup.Files = System.Web.HttpContext.Current.Server.MapPath("~/DBBackup\\") + "ExamdaSys.bak";//在类内运用Server时需要运用System.Web.HttpContext.Current
                oBackup.BackupSetName = "ExamdaSys";//要备份的数据库
                oBackup.BackupSetDescription = "数据库备份";//描述说明  这个可以不写
                oBackup.Initialize = true;//表示是追加备份还是重新备份，原来如果有同名的备份是否覆盖它
                oBackup.SQLBackup(oSQLServer);

            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                oSQLServer.DisConnect();
            }
        }