C#备份、还原MSSQL数据库问题！

答案：使用c#实现备份和还原数据库的方法如下：
 
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;
namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
        }
        /// <summary>        
        /// 备份数据库
        /// </summary>          
        /// <param name="backupFolder">备份文件路径</param>         
        /// <returns></returns>          
        public static bool DataBackupConfigDB(string backupFolder)
        {
            //获取配置文件中sql数据库名   
            string dbName = "SqlDB";
            string name = dbName + DateTime.Now.ToString("yyyyMMddHHmmss");
            string procname;
            string sql;
            //创建连接对象            
            SqlConnection conn = new SqlConnection(GetConnStr());
            conn.Open();//打开数据库连接
            //删除逻辑备份设备，但不会删掉备份的数据库文件          
            procname = "sp_dropdevice";
            SqlCommand sqlcmd1 = new SqlCommand(procname, conn);
            sqlcmd1.CommandType = CommandType.StoredProcedure;
            SqlParameter sqlpar = new SqlParameter();
            sqlpar = sqlcmd1.Parameters.Add("@logicalname", SqlDbType.VarChar, 20);
            sqlpar.Direction = ParameterDirection.Input;
            sqlpar.Value = dbName;
            try//如果逻辑设备不存在，略去错误            
            {
                sqlcmd1.ExecuteNonQuery();
            }
            catch
            {
                //MessageBox.Show("错误的备份文件目录");
            }
            //创建逻辑备份设备  
            procname = "sp_addumpdevice";
            SqlCommand sqlcmd2 = new SqlCommand(procname, conn);
            sqlcmd2.CommandType = CommandType.StoredProcedure;
            sqlpar = sqlcmd2.Parameters.Add("@devtype", SqlDbType.VarChar, 20);
            sqlpar.Direction = ParameterDirection.Input;
            sqlpar.Value = "disk";
            sqlpar = sqlcmd2.Parameters.Add("@logicalname", SqlDbType.VarChar, 20);//逻辑设备名  
            sqlpar.Direction = ParameterDirection.Input;
            sqlpar.Value = dbName;
            sqlpar = sqlcmd2.Parameters.Add("@physicalname", SqlDbType.NVarChar, 260);//物理设备名  
            sqlpar.Direction = ParameterDirection.Input;
            sqlpar.Value = backupFolder + name + ".bak";
            try
            {
                int i = sqlcmd2.ExecuteNonQuery();
            }
            catch (Exception err)
            {
                string str = err.Message;
            }
            //备份数据库到指定的数据库文件(完全备份)  
            sql = "BACKUP DATABASE " + dbName + " TO " + dbName + " WITH INIT";
            SqlCommand sqlcmd3 = new SqlCommand(sql, conn);
            sqlcmd3.CommandType = CommandType.Text;
            try
            {
                sqlcmd3.ExecuteNonQuery();
            }
            catch (Exception err)
            {
                string str = err.Message; conn.Close();
                return false;
            }
            conn.Close();//关闭数据库连接         
            return true;
        }
        /// <summary>     
        /// 还原数据库文件   
        /// </summary>   
     &n

上一个：Access 2010数据库附件字段插入文件 C#
下一个：求用C#修改XP壁纸方法