我就不啰嗦了,直接上代码:
//数据库连接字符串
private static string connectStr = ConfigurationManager.ConnectionStrings["conStr"].ToString();
/// <summary>
/// 数据库备份
/// </summary>
public static void ExecuteDataBase()
{
string filePath = @"G:\123.bak";
string sql = string.Format("BACKUP DATABASE 数据库名称 TO DISK='{0}'", filePath);
using (SqlConnection conn = new SqlConnection(connectStr))
{
if (conn.State != ConnectionState.Open)
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();
}
}
别人能做到的事,自己也可以做到。