C# 数据库备份的问题

Question

直接          
            using System.IO;
            string path = "数据文件目录";
            File.Copy(path, "D:\\");

Answer 1

//我是用Sqlserver创建一个备份存储过程
ALTER  procedure backup_gz
@device_name varchar(80),
@file_name varchar(25)
as
if exists(select @file_name)
begin
exec Sp_Addumpdevice 'disk',@device_name,
@file_name
backup database gz to @device_name
end
GO
 
//C#调用
string str=连接字符串；
SqlConnection conn=new SqlConnection(str);
SqlCommand cmd=new SqlCommand("backup_gz",conn);
cmd.CommandType=CommandType.StoredProcedure;   SqlParameter paraming=new SqlParameter("@device_name",SqlDbType.VarChar,80);
  paraming.Value=data_back;
cmd.Parameters.Add(paraming);
 
  SqlParameter parajing=new SqlParameter("@file_name",SqlDbType.VarChar,125);
parajing.Value=@"D:\back;//备份文件路径
cmd.Parameters.Add(parajing);
try
{
conn.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("备份成功!","提示",MessageBoxButtons.OK,MessageBoxIcon.Asterisk);
conn.Close();
}
                        catch{}