Место общения программистов C#
-
Гость
Ошибка при попытке получить резервную копию С# localdb
Сообщение
Гость »
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(); //}
Database name is BbCon.mdf it is located at C:\Users\asus\Desktop\New Folder (3)\bbcon_accout_software\bbcon_accout_software\bin\x86\Debug
Источник:
https://stackoverflow.com/questions/423 ... rp-localdb
1709973042
Гость
I'm trying to get the backup of a database but I am getting the error "database does not exist".
[code]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(); //} [/code] Database name is BbCon.mdf it is located at C:\Users\asus\Desktop\New Folder (3)\bbcon_accout_software\bbcon_accout_software\bin\x86\Debug
[img]https://i.stack.imgur.com/2k3wu.png[/img]
Источник: [url]https://stackoverflow.com/questions/42328838/error-while-trying-to-get-backup-c-sharp-localdb[/url]