如何从VS创建的.mdf数据库中进行备份
如何从VS创建的.mdf数据库中进行备份
提问于 2012-02-29 19:06:29
我是用VS2010创建的一个.mdf数据库文件。我可以检索数据并将数据插入数据库b但当我想要备份时，错误已处理。该数据库未附加到Management Studio中。
我的代码：
SqlConnection connect;
connect = new SqlConnection(DAL.AccessLayerClass._connectionStr);
connect.Open();
SqlCommand command;
command = new SqlCommand(@"backup database AGMDB to disk ='d:\svBackUp1.bak' with init,stats=10",connect);
command.ExecuteNonQuery();
connect.Close();
MessageBox.Show("The support of the database was successfully performed", "Back", MessageBoxButtons.OK, MessageBoxIcon.Information);我的连接字符串：
string _connectionStr = "Data Source=.\\SQLEXPRESS; AttachDbFilename=" + System.Windows.Forms.Application.StartupPath + "\\Database\\AGMDB.mdf; Integrated Security=True; Connect Timeout=30; User Instance=True;";然后这个错误就发生了：
Could not locate entry in sysdatabases for database 'AGMDB'. No entry found with that name. Make sure that the name is entered correctly.
BACKUP DATABASE is terminating abnormally.如何解决此错误？谢谢
Stack Overflow用户
回答已采纳
发布于 2012-02-29 19:15:47
你需要在DBFileName周围使用[]，试试这个：
SqlConnection connect;
connect = new SqlConnection(DAL.AccessLayerClass._connectionStr);
connect.Open();
SqlCommand command;
command = new SqlCommand(@"backup database [" + System.Windows.Forms.Application.StartupPath + "\\Database\\AGMDB.mdf] to disk ='d:\svBackUp1.bak' with init,stats=10",connect);
command.ExecuteNonQuery();
connect.Close();
MessageBox.Show("The support of the database was successfully performed", "Back", MessageBoxButtons.OK, MessageBoxIcon.Information);参考：How to Backup and Restore SQL Express 2005 (AttachDbFilename mode)
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/9497911
复制相关文章
相似问题
腾讯云开发者
