public static void MakeRestore(ServerMessageEventHandler onComplete, Guid id, string serverName, string dbName, string uncDir, string userName, string password) { var sc = new ServerConnection(serverName); sc.LoginSecure = false; sc.Login = userName; sc.Password = password; var srv = new Server(sc); var rest = new Restore(); rest.Action = RestoreActionType.Database; rest.Database = dbName; rest.Devices.AddDevice(Path.Combine(uncDir, rest.Database + ".bak"), DeviceType.File); rest.ReplaceDatabase = true; var headers = rest.ReadBackupHeader(srv); var query = from DataRow row in headers.Rows where (string)row["BackupName"] == id.ToString() select(Int16) row["Position"]; rest.FileNumber = query.First(); if (onComplete != null) { rest.Complete += onComplete; } rest.SqlRestore(srv); }
public static void MakeRestore(ServerMessageEventHandler onComplete, Guid id, string serverName, string dbName, string uncDir, string userName, string password) { var sc = new ServerConnection(serverName); sc.LoginSecure = false; sc.Login = userName; sc.Password = password; var srv = new Server(sc); var rest = new Restore(); rest.Action = RestoreActionType.Database; rest.Database = dbName; rest.Devices.AddDevice(Path.Combine(uncDir, rest.Database + ".bak"), DeviceType.File); rest.ReplaceDatabase = true; var headers = rest.ReadBackupHeader(srv); var query = from DataRow row in headers.Rows where (string)row["BackupName"] == id.ToString() select (Int16)row["Position"]; rest.FileNumber = query.First(); if (onComplete != null) rest.Complete += onComplete; rest.SqlRestore(srv); }
private void bkp_Complete(object sender, ServerMessageEventHandler e) { //Bar.EditValue = e.Percent; //Bar.Refresh(); //progressBar1.Value = e.Percent; //progressBar1.Refresh(); }
public Form1() { InitializeComponent(); xmlSerializeManager = new XmlSerializeManager(); smoManager = new SmoManager(); callBackDel = callBackResultMethod; backupPercentComplete = backup_PercentComplete; backupComplete = backup_Complete; backupInformation = backup_Information; // usupełnianie bazy danych testowymi rekordami //initializeDatabaseData(300); }
private ServerMessageEventHandler <TMessage> GetHandler <TMessage>() where TMessage : IrcMessage, IServerMessage { var messageType = typeof(TMessage); if (eventHandlers.ContainsKey(messageType)) { return(eventHandlers[messageType] as ServerMessageEventHandler <TMessage>); } var handler = new ServerMessageEventHandler <TMessage>(client); eventHandlers[messageType] = handler; return(handler); }
// @"\\tranquillity-pc\Temp\" public static void MakeBackup(ServerMessageEventHandler onComplete, Guid id, int experimentNumber, string serverName, string dbName, string uncDir, string userName, string password) { var sc = new ServerConnection(serverName); sc.LoginSecure = false; sc.Login = userName; sc.Password = password; var srv = new Server(sc); var bkp = new Backup(); bkp.Action = BackupActionType.Database; bkp.Database = dbName; bkp.BackupSetName = id.ToString(); bkp.BackupSetDescription = string.Format("VisLab auto-backup (experiment N{0}).", experimentNumber); bkp.Devices.AddDevice(Path.Combine(uncDir, bkp.Database + ".bak"), DeviceType.File); bkp.Incremental = false; if (onComplete != null) bkp.Complete += onComplete; bkp.SqlBackup(srv); }
public static bool MakeBackup(ServerMessageEventHandler onComplete, Guid id, int experimentNumber, string serverName, string dbName, string uncDir, string userName, string password) { bool result = false; try { var sc = new ServerConnection(serverName); try { sc.LoginSecure = false; sc.Login = userName; sc.Password = password; var srv = new Server(sc); var bkp = new Backup(); bkp.Action = BackupActionType.Database; bkp.Database = dbName; bkp.BackupSetName = id.ToString(); bkp.BackupSetDescription = string.Format("VisLab auto-backup (experiment N{0}).", experimentNumber); bkp.Devices.AddDevice(Path.Combine(uncDir, bkp.Database + ".bak"), DeviceType.File); bkp.Incremental = false; if (onComplete != null) { bkp.Complete += onComplete; } bkp.SqlBackup(srv); result = true; } finally { sc.Disconnect(); } } catch { } return(result); }
public void CreateBackup(BackupConfigurationData configurationData, PercentCompleteEventHandler backup_PercentComplete = null, ServerMessageEventHandler backup_Complete = null, ServerMessageEventHandler backup_Information = null) { Backup backup = new Backup(); backup.Action = BackupActionType.Database; backup.Database = configurationData.DatabaseName; string backupFileFullPath = getBackupFileFullPath(configurationData.FileName, configurationData.LocalDirectory); backup.Incremental = backupIncremental(configurationData.Id, backupFileFullPath); backup.Devices.AddDevice(backupFileFullPath, DeviceType.File); backup.Initialize = false; try { backup.PercentCompleteNotification = 5; if (backup_PercentComplete != null) { backup.PercentComplete += new PercentCompleteEventHandler(backup_PercentComplete); } if (backup_Complete != null) { backup.Complete += new ServerMessageEventHandler(backup_Complete); } if (backup_Information != null) { backup.Information += new ServerMessageEventHandler(backup_Information); } backup.SqlBackupAsync(server); } catch (Exception ex) { LogInfo.LogErrorWrite($"Nie można utworzyć backapu bazy danych {configurationData.DatabaseName}", ex); } }