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
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
330
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
51
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
28
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
72
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
180
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 ...
