All Questions
Tagged with pg-basebackup or backup
2,841 questions
0 votes
1 answer
39 views
SQL Server encrypting backup with a certificate failed with "Cannot find server certificate with thumbprint..."
Here is my demo code: USE master; GO IF NOT EXISTS (SELECT * FROM sys.symmetric_keys WHERE name = '##MS_DatabaseMasterKey##') BEGIN CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'StrongPassword123!';...
- 2,126
4 votes
1 answer
328 views
Is it possible to stripe backups going to Azure Blob Storage?
Using Ola Hallengren's toolset, I'm attempting do a backup of a database that is resulting in a backup that is larger than 1TB in size to Azure Blob Storage. This, obviously fails, so I attempt to ...
- 484
0 votes
0 answers
50 views
PostgreSQL pg_dump fails with "server closed the connection unexpectedly" during COPY operation
Problem Summary My automated PostgreSQL backup script using pg_dump was working fine until a few days ago. Now it consistently fails with a connection error during the COPY operation on the alternate ...
- 101
0 votes
1 answer
50 views
Database backup exclude list
I have 100s of SQL instances and there are cases where some databases are excluded from backup in the ola backup job. I am doing an backup audit and want to retrieve the excluded database list in the ...
- 1
0 votes
1 answer
57 views
Backup to NUL directory using Ola Hallengren Maintenance Solution
According Ola Hallegrens's support page for Maintenance Solution, NUL should be correct parameter to use as backup destination directory (@Directory = 'NUL'). Trying to use it, I still receive the ...
2 votes
1 answer
89 views
How to back up commitlogs in a Hyper Converged Database (HCD)?
I am working with a Hyper-Converged Database (HCD), which is based on Cassandra, and I need to implement a backup strategy that includes commitlogs along with SSTables. I understand that Medusa only ...
0 votes
0 answers
59 views
Best approach to sync preprod from prod without breaking transactional replication
I’m seeking recommendations on the best way to synchronize our preproduction environment from production without disrupting the existing transactional replication. Currently, both our production and ...
0 votes
0 answers
19 views
GridDB Cloud: how can I take a consistent online backup (snapshot) while writes continue?
I run GridDB on GridDB Cloud (Free plan) with a single cluster and a TimeSeries workload. Environment GridDB Cloud (Free), single DB TimeSeries containers (e.g., TSDB with ts TIMESTAMP PRIMARY KEY) ...
- 111
0 votes
1 answer
46 views
How to enable PITR in PostgreSQL with retention period to avoid disk space issues?
We want to enable Point-In-Time Recovery (PITR) for our PostgreSQL database. The goal is to be able to restore to any point in time, but we’re also concerned about disk space usage since archived WAL ...
- 1
1 vote
1 answer
39 views
POSTGRESQL : pg_verifybackup displays unable to match user created tablespaces in "backup_manifest" file
I am very new to PostgreSQL. I have built an evaluation/testing environment. Following series of steps describe my issue. Environment details: Non-Production Postgresql version : 16.9 OS : AlmaLinux ...
- 11
5 votes
3 answers
439 views
Problem with differential backups, after a problem with a full backup
I have a database in Microsoft SQL server 2008 R2, in which I have configured the maintenance plan for backups (a full back on Tuesdays, Thursdays and Saturdays at 00, three transactional logs at 4, 5 ...
- 51
0 votes
0 answers
26 views
wal-g/postgresql: How to turn continuous into punctual backups for sparsifying archival?
I would like to implement a backup scheme in which for the past week, I have daily full backups with complete WAL logs for point-in-time-recovery. Past a week, I would like to keep only daily ...
- 101
0 votes
0 answers
71 views
How do I restore my data from hacked database
My database was just hacked. I tried doing some work and could not log in with the created user credentials. When I checked the database, I saw an intruder was removing the users and had created a ...
- 1
5 votes
1 answer
179 views
Will unchanged database extents result in identical SQL backup bits on disk? What about with backup compression enabled?
(I'm trying to predict long-term SQL backup storage needs and if/where to enable compression, on a storage appliance with de-duplication. I know the best answer is "test both and see", which ...
- 10.1k
0 votes
0 answers
32 views
Periodic Oplog Backups to Minimize MongoDB MTTR During Accidental Data Loss
I'm working on improving MTTR (Mean Time To Recovery) in our MongoDB replica set by enabling faster recovery from accidental delete or update operations. Here's my proposed approach: Take periodic ...
