private static void BackupDb(string dbName, string fileName)
{
Backup dbBackup = new Backup();
try
{
dbBackup.Action = BackupActionType.Database;
dbBackup.Database = dbName;
dbBackup.BackupSetName = string.Format("{0} backup set.", dbName);
dbBackup.BackupSetDescription = string.Format("Database: {0}. Date: {1}.",
dbName, DateTime.Now.ToString("dd.MM.yyyy hh:m"));
dbBackup.MediaDescription = "Disk";
BackupDeviceItem device = new BackupDeviceItem(fileName, DeviceType.File);
dbBackup.Devices.Add(device);
dbBackup.SqlBackup(sqlServer);
}
catch (Exception exc)
{
dbBackup.Abort();
MessageBox.Show(string.Format("Exception occurred.\nMessage: {0}", exc.Message));
}
finally
{
sqlConn.Close();
}
}
private void BackupDb()
{
_dbName = ((Database)cmbBackupDb.SelectedItem).Name;
Backup dbBackup = new Backup();
try
{
dbBackup.Action = BackupActionType.Database;
dbBackup.Database = _dbName;
dbBackup.BackupSetName = $"{_dbName} backup set.";
dbBackup.BackupSetDescription = $"Database: {_dbName}:Date: {DateTime.Now:dd.MM.yyyy hh:mm}.";
dbBackup.MediaDescription = "Disk";
BackupDeviceItem device = new BackupDeviceItem(txtFileToBackUp.Text, DeviceType.File);
dbBackup.Devices.Add(device);
txtBackupScript.Text = dbBackup.Script(_sqlServer);
Logger.LogMessage("SQL Backup Script: " + txtBackupScript.Text);
progBar.Visible = true;
progBar.Value = 0;
dbBackup.Complete += dbBackup_Complete;
dbBackup.PercentCompleteNotification = 10;
dbBackup.PercentComplete += PercentComplete;
dbBackup.SqlBackup(_sqlServer);
}
catch (Exception exc)
{
dbBackup.Abort();
Logger.LogMessage($@"Exception occured. Message: {exc.Message}");
}
progBar.Visible = false;
}
public void BackupDb(string dbName, string backupSavePath)
{
Backup dbBackup = new Backup();
this.Cursor = Cursors.WaitCursor;
try
{
dbBackup.Action = BackupActionType.Database;
dbBackup.Database = dbName;
dbBackup.BackupSetName = string.Format("{0} backup set.", dbName);
dbBackup.BackupSetDescription = string.Format("Database: {0}. Date: {1}.", dbName, DateTime.Now.ToString("dd.MM.yyyy hh:m"));
dbBackup.MediaDescription = "Disk";
BackupDeviceItem device = new BackupDeviceItem(backupSavePath, DeviceType.File);
dbBackup.Devices.Add(device);
//dbBackup.Incremental = true;
dbBackup.Script(sqlServer);
progBar.Visible = true;
progBar.Value = 0;
dbBackup.Complete += new ServerMessageEventHandler(dbBackup_Complete);
dbBackup.PercentCompleteNotification = 10;
dbBackup.PercentComplete += new PercentCompleteEventHandler(PercentComplete);
dbBackup.SqlBackup(sqlServer);
}
catch /*(Exception ex)*/
{
dbBackup.Abort();
//Log.AddLog(ex.ToString());
}
finally
{
sqlConn.Close();
this.Cursor = Cursors.Default;
}
progBar.Visible = false;
}
