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) { }
}
}
