Stack Overflow
Stack Overflow

Questions tagged [point-in-time-recovery]

10 questions
4
votes
3 answers

Azure Sql DB Restore not showing up in Azure portal but stuck restoring in SSMS

I have had an Azure SQL DB point in time restore running for two days. I want to cancel it as I think there is an issue. I can see the DB restoring in SSMS but can't find the deployment in my Azure Portal. Does anyone know how to cancel it? I have…
Joshua Alexander Stewart
  • 65
  • 7
3
votes
1 answer

Cloud SQL point in time Data residency

I use point in time recovery on CloudSQL for PostgreSQL. The instance is highly available thus replicated to three availability zones. When enabling point in time on the GCP console it is clearly mentioned that the storage usage on the instance will…
gkatzioura
  • 2,655
  • 2
  • 26
  • 39
1
vote
1 answer

How to use Firebase Point-in-time recovery (PITR)?

I have just read the docs on the new Point-in-time recovery (PITR) release which I am absolutely pumped about. I’m trying to test out the sample code provided by Firebase here for reading a PITR version and can’t get it to work. I have enabled PITR…
Brandon Dooley
  • 21
  • 4
1
vote
3 answers

What are the differences among the different disaster recovery options for databases?

In the context of AWS databases, how do the following disaster recovery strategies differ from one another: point-in-time recovery backup snapshot Aurora backtrack When should we choose one over the others? Why do we need so many different options…
Chong Lip Phang
  • 8,755
  • 5
  • 65
  • 100
1
vote
2 answers

What is the Correct order to restart a cluster for point-in-time restore?

I have a mixed workload cluster across multiple datacenters. I have ran the sstableloader command for the tables I want to restore using snapshots which I had backed up. I have added commit log files which I had backed up from archive to a restore…
sitenkerz
  • 35
  • 3
0
votes
1 answer

PostgreSQL Point-In-Time Recovery Getting Error with No valid checkpoint record

I am trying to perform a Point-In-Time Recovery using the WAL_ARCHIVE process. The archive command is added to the postgresql.conf file and I can see the WAL being archived in the backup-archive directory. When I try to start the service I get…
Charis Soteriades
  • 5
  • 3
0
votes
1 answer

How to set Point-In-Time Recovery on a DynamoDB Replica

I am creating a Global Table on DynamoDB using CDK. I want to set Point-In-Time Recovery on all the Replicas. However, PITR only gets set on the original table, but not on the other replicas. Here is my code. import { Stack, StackProps, App } from…
Ebenezer Mathebula
  • 271
  • 1
  • 5
  • 19
0
votes
1 answer

How to 'rollback' my content to a specific date, reparing an update or delete or insert

I am maintaining a MySQL database (roughly 100 tables, lot of relations etc) here (version: 5.7). I am wondering if I can add a table etc (audit-table(s) and/or history-table(s) or add columns to the original tables) so that it will be easier for me…
InKi
  • 79
  • 2
  • 10
0
votes
0 answers

DynamoDB point-in-time-recovery files to parquet

DynamoDB point in time recovery export option under "Export and streams" seems to be dumping the file in json.gz file format when selected with "DynamoDB JSON" under advanced settings. When I am trying to convert that file (json.gz) to parquet using…
androboy
  • 817
  • 1
  • 12
  • 24
0
votes
1 answer

What is default for PointInTimeRecoveryEnabled in AWS DynamoDB?

I checked AWSCloudFormation dynamodb documentation and since PointInTimeRecoveryEnabled is optional, what would be the default value if it is not provided?
Ted
  • 22,696
  • 11
  • 95
  • 109