C#实现数据库的备份和还原

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Collections;
using System.Data;
using System.IO;
namespace DBConection.service
{
    public class DbService
    {
        //数据库的备份
        public bool BackUPDB(string strFileName, DB db)//DB是一个维护数据库连接的连接池
        {

            using (System.Data.SqlClient.SqlConnection conn = db.GetConection())
            {

                System.Data.SqlClient.SqlCommand cmdBK = new SqlCommand();
                cmdBK.CommandType = System.Data.CommandType.Text;
                cmdBK.Connection = conn;
                cmdBK.CommandText = @"backup database " + db.GetDBName() + " to disk='" + strFileName + "' with init";
                try
                {
                    conn.Open();
                    cmdBK.ExecuteNonQuery();
                    LogServcie.Log.writeLog("数据库备份成功。/n备份地址：" + strFileName);
                    return true;
                }
                catch (Exception ex)
                {
                    LogServcie.Log.WirteErr("数据库备份失败", ex);
                }
                finally
                {
                    conn.Close();
                    conn.Dispose();
                }
                return false;
            }

        }

        public void RestoreDB(string strDbName, string strFileName, string strToFileName, DB db)
        {

            using (System.Data.SqlClient.SqlConnection conn = db.GetConection())
            {

                DirectoryInfo dir = new DirectoryInfo(strToFileName);
                if (!dir.Exists)
                {
                    dir.Create();
                }
                string logicName = this.GetLogicName(strFileName, db);
                if (strDbName.IndexOf(".bak") != -1)
                {
                    strDbName = strDbName.Substring(0, strDbName.IndexOf(".bak"));
                }
                if (logicName != string.Empty)
                {
                    conn.Open();
                    //还原数据库
                    SqlCommand cmdRT = new SqlCommand();
                    cmdRT.CommandType = CommandType.Text;
                    cmdRT.Connection = conn;
                    cmdRT.CommandText = @"RESTORE DATABASE [" + strDbName + "] FROM  DISK = N'" + strFileName + "' WITH  FILE = 1,  NOUNLOAD ,  STATS = 10,  RECOVERY ,  MOVE N'" + logicName + "_Data' TO N'" + strToFileName + "//" + strDbName + ".mdf',  MOVE N'" + logicName + "_Log' TO N'" + strToFileName + "//" + strDbName + "_log.ldf'";

                    try
                    {
                        cmdRT.ExecuteNonQuery();
                        LogServcie.Log.writeLog("数据库还原成功。/n备份地址：" + strFileName + "/n 还原成数据库:" + strDbName);
                    }
                    catch (Exception ex)
                    {
                        LogServcie.Log.WirteErr("数据库还原失败", ex);
                    }
                    finally
                    {
                        conn.Close();
                    }
                }

            }
        }

        /// <summary>
        /// 用一个备份文件夹来恢复所有数据
        /// </summary>
        /// <param name="dir"></param>
        /// <param name="strToFileName"></param>
        /// <param name="logicName"></param>
        /// <param name="db"></param>
        public void RestoreDB(string[] Files, string strToFileName, DB db)
        {

            foreach (string fileName in Files)
            {
                FileInfo file = new FileInfo(fileName);
                if (file.Exists)
                    RestoreDB(file.Name, file.FullName, strToFileName, db);

            }

        }

        /// <summary>
        /// 获取数据库的逻辑名
        /// </summary>
        /// <param name="bakPath"></param>
        /// <param name="db"></param>
        /// <returns></returns>
        public string GetLogicName(string bakPath, DB db)
        {
            using (System.Data.SqlClient.SqlConnection conn = db.GetConection())
            {

                FileInfo file = new FileInfo(bakPath);
                if (file.Exists)
                {
                    conn.Open();
                    //还原数据库
                    SqlCommand cmdRT = new SqlCommand();
                    cmdRT.CommandType = CommandType.Text;
                    cmdRT.Connection = conn;
                    cmdRT.CommandText = @"restore FILELISTONLY FROM DISK ='" + bakPath + "'";

                    try
                    {
                        object ob = cmdRT.ExecuteScalar();
                        string logicName = Convert.ToString(ob);
                        logicName = logicName.Substring(0, logicName.IndexOf("_"));
                        LogServcie.Log.writeLog("获得数据库逻辑名:" + logicName);
                        return logicName;

                    }
                    catch (Exception ex)
                    {
                        LogServcie.Log.WirteErr("数据库还原失败", ex);
                    }
                    finally
                    {
                        conn.Close();
                    }
                }

                return string.Empty;

            }

        }

 

    }
}