SqlConnection conn = new SqlConnection("Server=dbnet.vicp.cc;uid=sa;pwd=lpu@5251;database=Help;");
SqlCommand cmdBK = new SqlCommand();
cmdBK.CommandType = CommandType.Text;
cmdBK.Connection = conn;
cmdBK.CommandText = @"backup database Help to disk='d:\" + TextBox1.Text + ".bak'";
try
{
conn.Open();
cmdBK.ExecuteNonQuery();
Label1.Text = "成功";
}
catch (Exception ex)
{
Label1.Text = "失败";
}
finally
{
conn.Close();
conn.Dispose();
}
实现在备份文件在服务器上, disk=‘’里的代码怎样写才能实现备份文件在本地机器上呢,
SqlCommand cmdBK = new SqlCommand();
cmdBK.CommandType = CommandType.Text;
cmdBK.Connection = conn;
cmdBK.CommandText = @"backup database Help to disk='d:\" + TextBox1.Text + ".bak'";
try
{
conn.Open();
cmdBK.ExecuteNonQuery();
Label1.Text = "成功";
}
catch (Exception ex)
{
Label1.Text = "失败";
}
finally
{
conn.Close();
conn.Dispose();
}
实现在备份文件在服务器上, disk=‘’里的代码怎样写才能实现备份文件在本地机器上呢,
d:\xxx 之类的路径本来就是本机路径,怎么可能备份到服务器上面去?
如果是 asp.net,那就先备份的服务器上面,然后下载。web不允许有本地文件的操作权限,不然就成木马了。下载除外,因为那要经过你允许的。