数据库备份和还原方法封装代码,CSharp代码库,德仔网

代码语言

代码分类

【CSharp】数据库备份和还原方法封装

作者:liangjw0504 / 发布于2014/7/17/ 504

上传部分自己总结的常用方法的封装，有不足和不完美之处，希望大家指出来，愿意一起


	using System;
	using SQLDMO;
	
	namespace EDTBackupTool
	{
	 /// <summary>
	 /// Backup 的摘要说明。
	 /// </summary>
	 public class SQLTools
	 {
	 public static bool Backup(string backfile){
	 try
	 {
	 SQLDMO.Backup backup = new BackupClass();
	 SQLDMO.SQLServer server = new SQLServerClass();
	 server.LoginSecure = true;
	 server.Connect(ClientCommon.CommonFunctions.DataSource,"sa","");
	 backup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
	 backup.Database = ClientCommon.CommonFunctions.Catalog;
	 backup.Files =backfile;
	 backup.BackupSetName =ClientCommon.CommonFunctions.Catalog;
	 backup.BackupSetDescription = "数据库备份";
	 backup.Initialize = true;
	 backup.SQLBackup(server);
	 return true;
	 }
	 catch(Exception ex){
	 ClientCommon.ExceptionRecorder.Record(ex);
	 return false;
	 }
	 }
	
	 public static bool RestoreDB(string strFileName)
	 {
	 SQLDMO.SQLServer svr = new SQLDMO.SQLServerClass() ;
	 try
	 {
	 svr.LoginSecure=true;
	 svr.Connect(ClientCommon.CommonFunctions.DataSource,"sa","") ;
	 SQLDMO.QueryResults qr = svr.EnumProcesses(-1) ;
	 int iColPIDNum = -1 ;
	 int iColDbName = 1 ;
	 for(int i=1;i<=qr.Columns;i++)
	 {
	 string strName = qr.get_ColumnName(i) ;
	 if (strName.ToUpper().Trim() == "SPID")
	 {
	 iColPIDNum = i ;
	 }
	 else if (strName.ToUpper().Trim() == ClientCommon.CommonFunctions.Catalog)
	 {
	 iColDbName = i ;
	 }
	 if (iColPIDNum != -1 && iColDbName != -1)
	 break ;
	 }
	 //杀死使用strDbName数据库的进程
	 for(int i=1;i<=qr.Rows;i++)
	 {
	 int lPID = qr.GetColumnLong(i,iColPIDNum) ;
	 string strDBName = qr.GetColumnString(i,iColDbName) ;
	 if (strDBName.ToUpper() == ClientCommon.CommonFunctions.Catalog)
	 {
	 svr.KillProcess(lPID) ;
	 }
	 }
	
	 SQLDMO.Restore res = new SQLDMO.RestoreClass() ;
	 res.Action = 0 ;
	 res.Files = strFileName ;
	
	 res.Database = ClientCommon.CommonFunctions.Catalog ;
	 res.ReplaceDatabase = true ;
	 res.SQLRestore(svr) ;
	 return true ;
	 }
	 catch
	 {
	 return false;
	 }
	 finally
	 {
	 svr.DisConnect() ;
	 }
	 }
	
	 }
	
	
	}

试试其它关键字

　数据库备份　　备份和还原　

同语言下

可能有用的

liangjw0504贡献的其它代码(36)