I'm trying to get the backup of a database but I am getting the error "database does not exist".
Код: Выделить всё
string master_ConnectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;Database=Master;Integrated Security=True;Connect Timeout=30;"; string database = GetDataDirectory(); MessageBox.Show(database); using (SqlConnection masterdbConn = new SqlConnection()) { masterdbConn.ConnectionString = master_ConnectionString; masterdbConn.Open(); using (SqlCommand multiuser_rollback_dbcomm = new SqlCommand()) { multiuser_rollback_dbcomm.Connection = masterdbConn; multiuser_rollback_dbcomm.CommandText = @"ALTER DATABASE @DBNAME SET MULTI_USER WITH ROLLBACK IMMEDIATE"; multiuser_rollback_dbcomm.Parameters.AddWithValue("@DBNAME",database); multiuser_rollback_dbcomm.ExecuteNonQuery(); } masterdbConn.Close(); } //SqlConnection.ClearAllPools(); //using (SqlConnection backupConn = new SqlConnection()) //{ // backupConn.ConnectionString = "Data Source=(LocalDB)\\v11.0;AttachDbFilename=|DataDirectory|\\BbCon.mdf;Integrated Security=True;Connect Timeout=30;"; // backupConn.Open(); // using (SqlCommand backupcomm = new SqlCommand()) // { // backupcomm.Connection = backupConn; // backupcomm.CommandText = @"BACKUP DATABASE BbCon TO DISK='c:\yourdbname.bak'"; // backupcomm.Parameters.AddWithValue("@DBNAME", database); // backupcomm.ExecuteNonQuery(); // } // backupConn.Close(); //} 
Источник: https://stackoverflow.com/questions/423 ... rp-localdb