-
Notifications
You must be signed in to change notification settings - Fork 5
/
BackupDatabase.cs
23 lines (20 loc) · 940 Bytes
/
BackupDatabase.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
using Microsoft.SqlServer.Management.Smo;
namespace DatabaseMinder
{
public static class BackupDatabase
{
public static void Execute(Server server, string databaseName, string nameOfCredentials, string fullSavePath, bool CompressionEnabled = false)
{
var backup = new Backup
{
CredentialName = nameOfCredentials,
Database = databaseName,
CompressionOption = CompressionEnabled ? BackupCompressionOptions.On : BackupCompressionOptions.Off
//EncryptionOption = new BackupEncryptionOptions(BackupEncryptionAlgorithm.Aes128,BackupEncryptorType.ServerCertificate, "AutoBackup_Certificate")
};
backup.Devices.AddDevice(fullSavePath, DeviceType.File);
backup.SqlBackup(server);
Consoler.Information($"Database backed up and saved to {fullSavePath}");
}
}
}