public void DeleteBackup(string projectId, string instanceId, string backupId)
{
// Create the DatabaseAdminClient instance.
DatabaseAdminClient databaseAdminClient = DatabaseAdminClient.Create();
// Make the DeleteBackup request.
BackupName backupName = BackupName.FromProjectInstanceBackup(projectId, instanceId, backupId);
databaseAdminClient.DeleteBackup(backupName);
Console.WriteLine("Backup deleted successfully.");
}
public static object SpannerCancelBackupOperation(
string projectId, string instanceId, string databaseId, string backupId)
{
// Create the DatabaseAdminClient instance.
DatabaseAdminClient databaseAdminClient = DatabaseAdminClient.Create();
// Initialize request parameters.
Backup backup = new Backup
{
DatabaseAsDatabaseName =
DatabaseName.FromProjectInstanceDatabase(projectId, instanceId, databaseId),
ExpireTime = DateTime.UtcNow.AddDays(14).ToTimestamp()
};
InstanceName parentAsInstanceName = InstanceName.FromProjectInstance(projectId, instanceId);
// Make the CreateBackup request.
Operation <Backup, CreateBackupMetadata> operation =
databaseAdminClient.CreateBackup(parentAsInstanceName, backup, backupId);
// Cancel the operation.
operation.Cancel();
// Poll until the long-running operation is complete since the backup wasn't
// cancelled before it was created.
Console.WriteLine("Waiting for the operation to finish.");
Operation <Backup, CreateBackupMetadata> completedOperation =
operation.PollUntilCompleted();
if (!completedOperation.IsFaulted)
{
Console.WriteLine("Delete backup because it completed before it could be cancelled.");
BackupName backupAsBackupName =
BackupName.FromProjectInstanceBackup(projectId, instanceId, backupId);
databaseAdminClient.DeleteBackup(backupAsBackupName);
}
Console.WriteLine($"Create backup operation cancelled: {operation.Name}");
return(0);
}
public static void DelelteBackups()
{
DatabaseAdminClient databaseAdminClient = DatabaseAdminClient.Create();
//delete backup contains "a"
var dataTime = DateTime.UtcNow.AddDays(1).ToString("yyyy-MM-dd");
var listBackupRequest = new ListBackupsRequest
{
Parent = InstanceName.Format(projectId, instanceId),
Filter = $"create_time < {dataTime}"
};
var backups = databaseAdminClient.ListBackups(listBackupRequest);
foreach (var backup in backups)
{
var deleteBackupRequest = new DeleteBackupRequest()
{
Name = backup.Name
};
databaseAdminClient.DeleteBackup(deleteBackupRequest);
}
}
