连接字符串如下:
<connectionStrings>
<add name="CourtDBConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\CourtDB.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
.......使用 "backup database CourtDB to disk='...'"命令时,发生异常说:数据库 'CourtDB' 不存在。请确保正确地输入了该名称。
BACKUP DATABASE 正在异常终止。求解决方案
<connectionStrings>
<add name="CourtDBConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\CourtDB.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
.......使用 "backup database CourtDB to disk='...'"命令时,发生异常说:数据库 'CourtDB' 不存在。请确保正确地输入了该名称。
BACKUP DATABASE 正在异常终止。求解决方案
protected void ImgBtnOK_Click(object sender, ImageClickEventArgs e)
{ string cmdtxt1 = "Server=(local);database='" + this.DDLDataBase.SelectedValue + "';Uid=sa;Pwd=";
string cmdtxt2 = "backup database " + this.DDLDataBase.SelectedValue + " to disk='" + this.TextBox1.Text.Trim() + ".bak'";
SqlConnection Con = new SqlConnection(cmdtxt1);
Con.Open();//打开数据库的链接
try
{
SqlCommand Com = new SqlCommand(cmdtxt2, Con);
Com.ExecuteNonQuery();
Response.Write("<script language=javascript>alert('备份数据成功!');location='javascript:history.go(-1)'</script>");
}
catch (Exception ms)
{
Response.Write(ms.Message);
Response.Write("<script language=javascript>alert('备份数据失败!');location='javascript:history.go(-1)'</script>");
}
finally
{
Con.Close();
}
}