示例#1
0
        /// <summary>
        /// 还原数据库
        /// </summary>
        /// <param name="filename">备份文件的完整文件名</param>
        /// <param name="file">所要还原的备份集</param>
        /// <returns></returns>
        public static bool RestoeData(string filename, int file)
        {
            string     sqlKill = "exec proc_Kill 'Equipment_Manage'";
            sqlHandler sh      = new sqlHandler();

            if (sh.ExecuteRestore(sqlKill) == -1)//杀死所有对数据库访问的进程
            {
                string sqlRestore = string.Format(" use master restore database Equipment_Manage from disk='{0}'  with replace,file={1} ", filename, file);
                return(sh.ExecuteRestore(sqlRestore) == -1);
            }
            else
            {
                return(false);
            }
        }