备份还原 数据库

终于 完成 测试
--备份
backup database LESPProject to disk = 'D:/Syenrgy/ASPNETWeb/2008.bak';
--还原
ALTER DATABASE LESPProject SET OFFLINE WITH ROlLBACK IMMEDIATE;
RESTORE DATABASE LESPProject FROM DISK = 'D:/Syenrgy/ASPNETWeb/2008.bak' with REPLACE
ALTER DATABASE LESPProject SET ONLINE  WITH ROlLBACK IMMEDIATE;

 

 protected void Page_Load(object sender, EventArgs e)
        {

            string path = Server.MapPath("./") + "2008.bak";//完整路径

            //new Com().backdatabase(path);

            new Com().Upbackdatabase(path);

        }

public bool backdatabase(string path)
        {

            string dbname = "LESPProject";//数据库名
            string backupSql = "use master;";//避免错误
            backupSql += "backup database " + dbname + " to disk = '" + path + "'; ";

            try
            {
                DataExecutor.ExeSqlcomm(backupSql);//执行sql语句
                return true;
            }
            catch(Exception ex)
            {
                throw new Exception(ex.Message.ToString());
            }
            return false;

        }

        public bool Upbackdatabase(string path)
        {
            string dbname = "LESPProject";//数据库名
            string restoreSql = " ";//避免错误
            restoreSql += "use master;";//避免错误
            restoreSql += "ALTER DATABASE LESPProject SET OFFLINE WITH ROlLBACK IMMEDIATE;";//将数据库置于离线状态
            restoreSql += "restore database " + dbname + " from disk = '"+path+"' with replace ;";//恢复DZManage数据库
            restoreSql += "ALTER DATABASE LESPProject SET ONLINE WITH ROlLBACK IMMEDIATE;";//将数据库置于在线状态

            try
            {
                DataExecutor.ExeSqlcomm(restoreSql);//执行sql语句
                return true;
            }
            catch(Exception ex)
            {
                throw new Exception(ex.Message.ToString());
            }
            return false;

        }