public void DoBackup()
{
SQLiteClass sql = new SQLiteClass();
Backup bkpDBFull = new Backup();
bkpDBFull.Action = BackupActionType.Database;
bkpDBFull.Database = dtb.Name;
bkpDBFull.Devices.AddDevice(sql.GetBackupLocation() + "\\" + DateTime.Now.ToString("ddMMyyyy hhmmss") + ".bak", DeviceType.File);
bkpDBFull.BackupSetName = "Duckpond Suite Database Backup " + DateTime.Now;
bkpDBFull.BackupSetDescription = "Duckpond Suite Database - Full Backup";
bkpDBFull.ExpirationDate = DateTime.Today.AddDays(28);
bkpDBFull.Initialize = false;
try
{
bkpDBFull.SqlBackup(srv);
}
catch
{
throw new FailedOperationException();
}
}
public Backup()
{
sql = new SQLiteClass();
InitializeComponent();
LblLocation.Content = sql.GetBackupLocation();
}