Questions tagged [backup]
Making copies of data which may be restored after a data loss event or to recover data from some earlier point in time.
2,841 questions
0
votes
1
answer
43
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
75
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
50
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
18
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
38
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
votes
0
answers
21
views
ow to Merge PostgreSQL Databases from Two Servers with Duplicate Data and ID Conflicts
I have two servers, each running PostgreSQL with 9 databases (e.g., main_db, autopayment, and 7 others). Each database has the same structure (same tables and columns). I have SQL dump files for both ...
1
vote
1
answer
24
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
411
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
18
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
63
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
170
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 ...
- 10k
0
votes
0
answers
30
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 ...
3
votes
0
answers
54
views
Is it best to prepare a MariaDB backup right away, or wait until restore is needed?
Using MariaDB 11, consider a backup strategy as follows:
Monday - Full
Tuesday - Incremental
Wednesday - Incremental
Are there and advantages or disadvantages of "preparing" the backup ...
- 31
0
votes
1
answer
48
views
pg_basebackup duration of 500G
How long should the duration of a pg_basebackup of around 500G usually should be?
Currently it takes about 7hrs.
What could be done to speed up this process?
We create the backup locally and move it ...
- 1
0
votes
1
answer
60
views
Proper method to reset DB/2 database
I am setting up a lab environment in DB/2 11.1 on Linux where I have a DB with a few tables, views and authorities. Once it is all configured, I take a backup with
db2 backup db MYDB online to /opt/...
- 103