我在 Windows 窗体中开发了一个 MIS,其中我备份了 SQL Server 2012 数据库,但我无法恢复备份(.bak
) file.
这是我的代码:
private void buttonRestore_Click(object sender, EventArgs e)
{
try
{
openFileDialog1.Filter = "Backup File |*.bak";
if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
string sql = "Alter Database BOQ SET SINGLE_USER WITH ROLLBACK IMMEDIATE;";
sql += "Restore Database BOQ FROM DISK ='" + openFileDialog1.FileName + "' WITH REPLACE;";
SqlConnection con = new SqlConnection("Data Source=.; Initial Catalog=BOQ;Integrated Security=True");
SqlCommand command = new SqlCommand(sql,con);
con.Open();
command.ExecuteNonQuery();
MessageBox.Show("Database Recovered Successfully!");
con.Close();
con.Dispose();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
但我收到这个错误:
You cannot连接到您的数据库BOQ
然后恢复一个.bak
超过它了!
"Data Source=.; Initial Catalog=BOQ;Integrated Security=True"
****
您需要连接到master
数据库,以及then你可以恢复你的BOQ
数据库:
"Data Source=.; Initial Catalog=master;Integrated Security=True"
*******
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)