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