数据还原代码(C#)

using System;
using System.IO;
using System.Net;
using System.Data;
using System.Threading;
using System.Collections;
using System.Diagnostics;
using System.ComponentModel;
using System.ServiceProcess;
using System.Data.SqlClient;

namespace LengYue
{
 /// <summary>
 /// 提供附加、分离、备份、还原数据库的操作方法
 /// </summary>
 public class OperDB_Lengyue
 {

  //使用集成连接数据库
  private static string ConnectionString="workstation id=/""+Dns.GetHostName()+"/";integrated security=SSPI;data source=/"" +
   "./";persist security info=False;Initial Catalog=master";

  private static void StartSqlServer()
  {
   
   ProcessStartInfo info=new ProcessStartInfo("net.exe"," start mssqlserver");
   info.CreateNoWindow=true;
   info.WindowStyle=ProcessWindowStyle.Hidden;
   Process ps=Process.Start(info);

//   Process[] process = Process.GetProcessesByName("sqlservr");
//   foreach (Process inpor in process)
//   {
//    return;//如果sql服务已经启动则返回
//   }
//   Process MyProcess= new Process();
//   //设定程序名
//   MyProcess.StartInfo.FileName = "cmd.exe";
//   //关闭Shell的使用
//   MyProcess.StartInfo.UseShellExecute = false;
//   //重定向标准输入
//   MyProcess.StartInfo.RedirectStandardInput = true;
//   //重定向标准输出
//   MyProcess.StartInfo.RedirectStandardOutput = true;
//   //重定向错误输出
//   MyProcess.StartInfo.RedirectStandardError = true;
//   //设置不显示窗口
//   MyProcess.StartInfo.CreateNoWindow = true;
//   //启动进程
//   MyProcess.Start();
//   //执行命令启动服务
//   MyProcess.StandardInput.WriteLine("net start mssqlserver");
//   //退出进程
//   MyProcess.StandardInput.WriteLine("exit");
//   // 等待200000毫秒让sql服务成功启动
//   Thread.Sleep(20000);
//   bool bl=true;
//   Process[] process2 = Process.GetProcessesByName("sqlservr");
//   foreach (Process inpor in process2)
//   {
//    bl=false;// 再次检查sql服务是否已经成功启动
//   }
//   if(bl)//如果sql服务还没有启动则抛出异常
//   {
//    throw new ApplicationException("无法启动sql服务！");
//   }
  }

  /// <summary>
  /// 附加数据库
  /// </summary>
  /// <param name="DbName">将数据库附加为的名字</param>
  /// <param name="Mdf">MDF</param>
  /// <param name="Ldf">LDF</param>
  /// <param name="Path">该参数为（Application.StartupPath）即当前运行程序的路径</param>
  /// <returns>附加成功返回真</returns>
  public static bool AddDataBase(string DbName,string path_Mdf,string path_Ldf)
  {
   bool bl=false;
   StartSqlServer();//启动sql服务
   try
   { 
    SqlConnection Conn=new SqlConnection(ConnectionString);
    Conn.Open();
    //sp_detach_db分离数据，sp_attach_db附加数据
    string ComText="IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'"+DbName+"')"+
     "begin EXEC sp_detach_db "+DbName+" end  "+//如果数据库已经存在则先分离
     "EXEC sp_attach_db @dbname = N'"+DbName+"',"+
     "@filename1 = N'"+path_Mdf+"',"+
     "@filename2 = N'"+path_Ldf+"'";
    SqlCommand Comm = new SqlCommand(ComText,Conn);
    Comm.ExecuteNonQuery();
    Conn.Close();
    bl=true;
   }
   catch(Exception ex)
   {
    throw new ApplicationException("附加数据库失败",ex);
   }
   return bl;
  }
  
  /// <summary>
  /// 分离数据库
  /// </summary>
  /// <param name="DbName">要分离的数据库名</param>
  /// <returns>分离成功返回真</returns>
  public static bool SeverDataBase(string DbName)
  {
   
   bool bl=false;
   StartSqlServer();//启动sql服务
   try
   { 
    SqlConnection Conn=new SqlConnection(ConnectionString);
    Conn.Open();
    //sp_detach_db分离数据，sp_attach_db附加数据
    string ComText="EXEC sp_detach_db "+DbName;
    SqlCommand Comm = new SqlCommand(ComText,Conn);
    Comm.ExecuteNonQuery();
    Conn.Close();
    bl=true;
   }
   catch(Exception ex)
   {
    throw new ApplicationException("分离数据库失败",ex);
   }
   return bl;
  }
  /// <summary>
  /// 备份数据库
  /// </summary>
  /// <param name="DbName">要备份的数据库名</param>
  /// <param name="BackupPath_name">备份设备（路径+文件.bak）</param>
  /// <returns> 备份成功返回真</returns>
  public static bool BackupDataBase(string DbName,string BackupPath_name)
  {
   
   bool bl=false;
   //如果看不懂下面的代码请不要随便改动
   StartSqlServer();//启动sql服务
   try
   { 
    SqlConnection Conn=new SqlConnection(ConnectionString);
    Conn.Open();
    //sp_detach_db分离数据，sp_attach_db附加数据
    string ComText="use master;backup database "+DbName+" to disk = '"+BackupPath_name+"'";
    SqlCommand Comm = new SqlCommand(ComText,Conn);
    Comm.ExecuteNonQuery();
    Conn.Close();
    bl=true;
   }
   catch(Exception ex)
   {
    throw new ApplicationException("备份数据库失败",ex);
   }
   return bl;
  }
  /// <summary>
  /// 还原数据库
  /// </summary>
  /// <param name="BackupPath_name">数据源（路径+文件）</param>
  /// <returns>还原成功返回真</returns>
  public static bool ReplaceDataBase(string DBName, string BackupPath_name)
  {
   bool bl=false;
   StartSqlServer();//启动sql服务
   try
   {
    SqlConnection Conn=new SqlConnection(ConnectionString);
    Conn.Open();
    string ComText="use master;restore database "+DBName+" From disk = '"+BackupPath_name+"' with replace;";
    SqlCommand Comm = new SqlCommand(ComText,Conn);
    Comm.ExecuteNonQuery();
    Conn.Close();
    bl=true;
   }
   catch(Exception ex)
   {
    throw new ApplicationException("还原数据库失败",ex);
   }
   return bl;
  }
 }
}