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