public void Restore() { string s = "ALTER DATABASE M_A_DB SET OFFLINE WITH ROLLBACK IMMEDIATE"; da.ConnectforRestore(); da.docommand(s); da.disconnect(); s = "RESTORE DATABASE M_A_DB FROM DISK = N'{0}' WITH FILE = {1}, NOUNLOAD, REPLACE, STATS = 10"; s = string.Format(s, this.Backup_name, this.fn); da.ConnectforRestore(); da.docommand(s); da.disconnect(); s = "ALTER DATABASE M_A_DB SET ONLINE WITH ROLLBACK IMMEDIATE"; da.ConnectforRestore(); da.docommand(s); da.disconnect(); System.Data.SqlClient.SqlConnection.ClearAllPools(); }
private void button1_Click(object sender, EventArgs e) { try { my.ConnectforRestore(); my.docommand(textBox1.Text); my.disconnect(); } catch (Exception ex) { MessageBox.Show(ex.Message); try { my.disconnect(); } catch (Exception) { } } }