先备份数据再下载
string con_str = "server=192.168.1.2\\A;database=Test;uid=sa;pwd=sa";
SqlConnection conn = new SqlConnection(con_str);
SqlCommand cmdBK = new SqlCommand();
cmdBK.CommandType = CommandType.Text;
cmdBK.Connection = conn;
cmdBK.CommandText = @"backup database Test to disk='..\Backup\" + filepath + ".bak'" + " with init";
try
{
conn.Open();
cmdBK.ExecuteNonQuery();
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "backup", "alert('数据库备份成功!')", true);
}
catch (Exception)
{
}
finally
{
conn.Close();
conn.Dispose();
}
exec master..xp_cmdshell 'net use z: \\a\D$ "密码" /user:a\administrator'
backup database 库名 to disk='E:\BACKUP.bak' with init exec master..xp_cmdshell 'copy E:\BACKUP.bak z:'
string con_str = "server=192.168.1.2\\A;database=Test;uid=sa;pwd=sa";
SqlConnection conn = new SqlConnection(con_str);
SqlCommand cmdBK = new SqlCommand();
cmdBK.CommandType = CommandType.Text;
cmdBK.Connection = conn;
cmdBK.CommandText = @"backup database Test to disk='..\Backup\" + filepath + ".bak'" + " with init";
try
{
conn.Open();
cmdBK.ExecuteNonQuery();
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "backup", "alert('数据库备份成功!')", true);
}
catch (Exception)
{
}
finally
{
conn.Close();
conn.Dispose();
}
exec master..xp_cmdshell 'net use z: \\a\D$ "密码" /user:a\administrator'
backup database 库名 to disk='E:\BACKUP.bak' with init exec master..xp_cmdshell 'copy E:\BACKUP.bak z:'
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货