#region 类说明
//-----------------------------------------------------------------------------
//
// 项目名称：***
// 文件名称：DBBakManager.cs
// 文件说明：对数据库备份文件进行管理。提供备份、还原、备份文件管理操作。
//
// 开始日期：20014年05月04日
// 开发人员：***
//
//-----------------------------------------------------------------------------
#endregion using System;
using System.Collections.Generic;
using System.IO;
using System.Text;
using SQLDMO; //添加引用C:Program FilesMicrosoft SQL Server80ToolsBinnSQLDMO.dll namespace GSIM.StuManager
{
/// <summary>
/// 对SQL Server数据库备份文件进行管理。提供备份、还原、备份文件管理操作。
/// </summary>
public class DBBakManager
{ 字段#region 字段 private string _serverName;
private string _userName;
private string _password;
private string _dbName; #endregion 构造#region 构造 /// <summary>
/// 构造函数
/// </summary>
/// <param name="serverName">数据库服务器名
/// <param name="userName">数据库用户名
/// <param name="password">用户密码
/// <param name="dbName">数据库名
public DBBakManager(string serverName, string userName, string password,string dbName)
{
_serverName = serverName;
_userName = userName;
_password = password;
_dbName = dbName;
} #endregion 方法#region 方法 /// <summary>
/// 备份数据库
/// </summary>
/// <param name="saveFileName">保存的备份文件路径(包括文件名,文件名格式为:"DBName(yyyyMMddHHmm).bak")
/// <returns>操作成功返回true,否则返回false</returns>
public bool BackUpDB(string saveFileName)
{
SQLDMO.SQLServer svr = new SQLDMO.SQLServerClass();
try
{
svr.Connect(_serverName, _userName, _password);
SQLDMO.Backup bak = new SQLDMO.BackupClass();
bak.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
bak.Initialize = true;
bak.Database = _dbName;
bak.Files = saveFileName;
bak.SQLBackup(svr);
return true;
}
catch (Exception err)
{
return false;
}
finally
{
svr.Close();
}
} /// <summary>
/// 还原数据库备份
/// </summary>
/// <param name="fileName">还原的备份文件路径(包括文件名,文件名格式为:"DBName(yyyyMMddHHmm).bak")
/// <returns>操作成功返回true,否则返回false</returns>
public bool RestoreDB(string fileName)
{
SQLDMO.SQLServer svr = new SQLDMO.SQLServerClass();
try
{
svr.Connect(_serverName, _userName, _password);
//取得所有的进程列表
SQLDMO.QueryResults qr = svr.EnumProcesses(-);
int iColPIDNum = -;
int iColDbName = -;
//找到和要恢复数据库相关的进程
for (int i = ; i <= qr.Columns; i++)
{
string strName = qr.get_ColumnName(i);
if (strName.ToUpper().Trim() == "SPID")
{
iColPIDNum = i;
}
else if (strName.ToUpper().Trim() == "DBNAME")
{
iColDbName = i;
}
if (iColPIDNum != - && iColDbName != -)
break;
}
//将相关进程关闭
for (int i = ; i <= qr.Rows; i++)
{
int lPID = qr.GetColumnLong(i, iColPIDNum);
string strDBName = qr.GetColumnString(i, iColDbName);
if (strDBName.ToUpper() == _dbName)
svr.KillProcess(lPID);
} SQLDMO.Restore res = new SQLDMO.RestoreClass(); res.Action = SQLDMO.SQLDMO_RESTORE_TYPE.SQLDMORestore_Database;
res.Files = fileName; res.Database = _dbName;
res.FileNumber = ; res.ReplaceDatabase = true;
res.SQLRestore(svr); return true;
}
catch (Exception err)
{
return false;
}
finally
{
svr.Close();
}
} /// <summary>
/// 获得所有数据库备份文件信息,如:200704041120.
/// </summary>
/// <param name="filePath">保存备份文件的文件夹路径(不包括文件名)
/// <returns>包含文件信息的字符串组</returns>
public string[] GetAllDBBak(string filePath)
{
string[] DBBakInfo = Directory.GetFiles(filePath, "BMIS*");
int start = DBBakInfo[].IndexOf("(");
int end = DBBakInfo[].IndexOf(")");
//除去多余部分,返回名字中的时间信息,如:200704041120.
for (int i = ; i < DBBakInfo.Length; i++)
{
DBBakInfo[i] = DBBakInfo[i].Substring(start + , end - start - );
}
return DBBakInfo;
} /// <summary>
/// 删除一个数据库备份文件
/// </summary>
/// <param name="fileName">删除的备份文件路径(包括文件名,文件名格式为:"DBName(yyyyMMddHHmm).bak")
/// <returns>操作成功返回true,否则返回false</returns>
public bool DeleteDBBak(string fileName)
{
if (File.Exists(fileName) == true)
{
File.Delete(fileName);
return true;
}
else
{
return false;
} } #endregion
}
}