（远程）数据库备份与恢复

#region  数据库备份与恢复--系统设置
        /// <summary>
        /// 备份数据库
        /// </summary>
        /// <param name="bakUpName"></param>
        public void BackUp(string bakUpName)
        {
            data.RunProc("BACKUP DATABASE LICENSE TO DISK ='" + bakUpName + "'");
        }
        /// <summary>
        /// 远程备份数据库
        /// </summary>
        /// <param name="bakUpName"></param>
        public void BackUpRemote(string bakUpName, string BackUp)
        {
            //下两行存在2000好使，2005不好使，
            //data.RunProc("master.dbo.XP_cmdshell 'md " + BackUp + "'");
            //data.RunProc("master.dbo.XP_cmdshell 'net share bak=" + BackUp + "'");
            data.RunProc("BACKUP DATABASE LICENSE TO DISK ='" + BackUp + @"/"+bakUpName + "'");

        }
        /// <summary>
        /// 恢复数据库
        /// </summary>
        /// <param name="reStoreName"></param>
        public void ReStore(string reStoreName)
        {
            //下3行只2005好使，
            //string setOffline = "Alter database LICENSE Set Offline With rollback immediate;";
            //string setOnline = " Alter database LICENSE Set Online With Rollback immediate;";
            //data.RunProc(setOffline + "use master RESTORE DATABASE LICENSE from disk='" + reStoreName + "' WITH REPLACE;" + setOnline);
            data.RunProc("use master RESTORE DATABASE LICENSE from disk='" + reStoreName + "' WITH REPLACE");
        }
        /// <summary>
        /// 远程恢复数据库
        /// </summary>
        /// <param name="reStoreName"></param>
        public void ReStoreRemote(string reStoreName, string BackUp)
        {
            //下两行存在2000好使，2005不好使，
            //data.RunProc("master.dbo.XP_cmdshell 'md " + BackUp + "'");
            //data.RunProc("master.dbo.XP_cmdshell 'net share bak=" + BackUp + "'");
            //下3行只2005好使，
            //string setOffline = "Alter database LICENSE Set Offline With rollback immediate;";
            //string setOnline = " Alter database LICENSE Set Online With Rollback immediate;";
            //data.RunProc(setOffline + "use master RESTORE DATABASE LICENSE from disk ='" + BackUp + @"/" + reStoreName + "' WITH REPLACE;" + setOnline);
            data.RunProc("use master RESTORE DATABASE LICENSE from disk ='" + BackUp + @"/" + reStoreName + "' WITH REPLACE");
        }
        #endregion