/// <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); } }