public void backup_init_primary(List <LSDB> list_lsdb, string primary_server)
{
string result = "";
string command_backup_init = "";
//var self = (BackgroundWorker)sender;
builder = new SqlConnectionStringBuilder
{
DataSource = primary_server.Trim(), // tb_primary.Text.Trim(); // update me
IntegratedSecurity = true,
//builder.UserID = "sa"; // update me
//builder.Password = "******"; // update me
InitialCatalog = "master"
};
if (list_lsdb.Count == 0)
{
result = "Empty list. Get list of databases and select items in list, please.";
//return result;
}
foreach (LSDB item in list_lsdb)
{
command_backup_init += "BACKUP DATABASE [" + item.database_name + "] TO DISK = '" + item.src_share_path + "\\FULL_INIT_" + item.database_name + ".bak' WITH CHECKSUM, FORMAT, INIT, STATS = 10; ";
//command_backup_init += " RaisError('Backup completed for database = " + item.database_name + "', 1, 1) With NoWait; ";
}
try
{
SqlCommandWithProgress run_cmd = new SqlCommandWithProgress();
////run_cmd.ExecuteNonQueryWithEvents(builder.ConnectionString, command_backup_init, s => Console.WriteLine(s));
run_cmd.ExecuteNonQueryWait(builder.ConnectionString, command_backup_init, s => Console.WriteLine(s));
}
catch (SqlException e)
{
//MessageBox.Show(e.Message);
result = e.ToString();
Console.WriteLine(e.ToString());
}
//return result;
}
public void restore_init_secondary(List <LSDB> list_lsdb, string pri_server, string sec_server, string backup_share, string mdf_path, string ldf_path)
{
string result = "";
//string command_restore_init = "";
string restore_command_secondary = get_restore_cmd_from_primary(list_lsdb, pri_server, backup_share, mdf_path, ldf_path);
if (restore_command_secondary != "")
{
builder = new SqlConnectionStringBuilder
{
DataSource = sec_server, // tb_primary.Text.Trim(); // update me
IntegratedSecurity = true,
//builder.UserID = "sa"; // update me
//builder.Password = "******"; // update me
InitialCatalog = "master"
};
try
{
//await
SqlCommandWithProgress run_cmd = new SqlCommandWithProgress();
////run_cmd.ExecuteNonQueryWithEvents(builder.ConnectionString, command_backup_init, s => Console.WriteLine(s));
run_cmd.ExecuteNonQueryWait(builder.ConnectionString, restore_command_secondary, s => Console.WriteLine(s));
}
catch (SqlException e)
{
//MessageBox.Show(e.Message);
result = e.ToString();
Console.WriteLine(e.ToString());
}
}
//return result;
}
