public bool Backing(string database, SqlConnection connection)
{
try
{
var ServerConnection = new ServerConnection(connection);
//var Server = new Microsoft.SqlServer.Management.Smo.Server();
var Server = new Microsoft.SqlServer.Management.Smo.Server(ServerConnection);
var bkpDBFullWithCompression = new Microsoft.SqlServer.Management.Smo.Backup();
/* Specify whether you want to back up database or files or log */
bkpDBFullWithCompression.Action = Microsoft.SqlServer.Management.Smo.BackupActionType.Database;
/* Specify the name of the database to back up */
bkpDBFullWithCompression.Database = database;
/* You can use back up compression technique of SQL Server 2008,
* specify CompressionOption property to On for compressed backup */
if (Server.Name != "(localdb)\\MSSQLLocalDB")
{
bkpDBFullWithCompression.CompressionOption = Microsoft.SqlServer.Management.Smo.BackupCompressionOptions.On;
}
bkpDBFullWithCompression.Devices.AddDevice($"{_path}{database}_{DateTime.Now.ToString("yyyyMMdd")}_{Guid.NewGuid()}.bak", Microsoft.SqlServer.Management.Smo.DeviceType.File);
bkpDBFullWithCompression.BackupSetName = database + " database Backup - Compressed";
bkpDBFullWithCompression.BackupSetDescription = database + " database - Full Backup with Compressin - only in SQL Server 2008";
bkpDBFullWithCompression.SqlBackup(Server);
return(true);
}
catch (Exception) { throw; }
}
private void mtlBackup_Click(object sender, EventArgs e)
{
try
{
var servidor = new Microsoft.SqlServer.Management.Smo.Server(txtServidor.Text);
if (_config.UsarDestinoPersonalizado && !string.IsNullOrEmpty(_config.DestinoPersonalizado))
{
servidor.BackupDirectory = _config.DestinoPersonalizado;
}
var backup = new Microsoft.SqlServer.Management.Smo.Backup
{
Database = txtDatabase.Text,
Incremental = false
};
var filename = $"{txtDatabase.Text}_{DateTime.Now:g}.bak";
backup.Devices.AddDevice(filename, Microsoft.SqlServer.Management.Smo.DeviceType.File);
backup.SqlBackup(servidor);
MetroMessageBox.Show(this, $"Backup '{filename}' Concluido com Sucesso!");
}
catch (Exception ex)
{
MetroMessageBox.Show(this, ex.Message);
}
}
private void mtlBackup_Click(object sender, EventArgs e)
{
try
{
var servidor = new Microsoft.SqlServer.Management.Smo.Server(txtServidor.Text);
if (_config.UsarDestinoPersonalizado && !string.IsNullOrEmpty(_config.DestinoPersonalizado))
{
servidor.BackupDirectory = _config.DestinoPersonalizado;
}
var backup = new Microsoft.SqlServer.Management.Smo.Backup
{
Database = txtDatabase.Text,
Incremental = false
};
var filename = $"{txtDatabase.Text}_{DateTime.Now:g}.bak";
backup.Devices.AddDevice(filename, Microsoft.SqlServer.Management.Smo.DeviceType.File);
backup.SqlBackup(servidor);
MetroMessageBox.Show(this, $"Backup '{filename}' Concluido com Sucesso!");
}
catch (Exception ex)
{
MetroMessageBox.Show(this, ex.Message);
}
}
