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,849 questions
0
votes
0
answers
26
views
Pgbackrest can't create stanza
This is my backup server, I am trying to create a stanza so as to implement backups.
I get this error:
postgres@backup-server:/home/backup-admin$ pgbackrest --stanza=main --log-level-console=info ...
- 1
2
votes
1
answer
241
views
Unable to restore database from differential backup
I have MS SQL Server 2022 Datacenter installed. It performs daily backups. At the beginning of the week, a file with a full backup is created. Then, differential backups are created daily.
The first ...
- 23
0
votes
2
answers
66
views
How do I manually back up a supabase database via CLI?
I installed PostgreSQL via Homebrew (pg_dump --version: 14.19). I'm unable to back up my data. After that, I'd like to restore the data.
I have users. The data is protected with Row Level Security (...
- 1
11
votes
4
answers
1k
views
How to backup a mission-critical database?
I am the database administrator on a payment processing app, using MySQL for data storage, we process a lot of requests per minute and a data corruption could be detrimental. So a full database backup ...
- 235
0
votes
1
answer
65
views
Transaction Log Filling During Partial Backup
I have a large, active database in simple recovery mode. The data in one main table is partitioned across filegroups, and the oldest filegroups are marked as read only. I am attempting to run a ...
- 1,152
1
vote
1
answer
102
views
Is running mariadb-backup --prepare safe or dangerous?
I'm using mariadb 15.1.
I'd like to know whether preparing a backup multiple times is safe or can be dangerous.
mariadb-backup --prepare [options]
After some searching I have to outcomes:
AI says it'...
- 11
2
votes
1
answer
264
views
What disaster recovery solutions are available if my storage already does the replication?
The Business continuity and database recovery documentation lists all of the methods of disaster recovery in SQL Server. At a skim, I see the following Windows options:
Availability groups
Database ...
- 1,488
0
votes
2
answers
44
views
Must copy config files to backup database? /var/lib/mysql not enough?
According to ChatGPT, "all" you need to do to secure a backup of a MySQL database is to make a consistent copy of /var/lib/mysql. Yet, it later tells me that you also need to copy my.conf ...
- 11
0
votes
1
answer
59
views
How to sync database with large network connectivty gaps
I have a postgres+postgis+timescaledb database running on a ship. It collects performance data (RPM, battery, fuel etc), location data (a bunch of different GPS, pitch/roll/yaw) and some sensor data (...
- 145
0
votes
1
answer
73
views
Azure SQL Managed Instance - Manual Backup and restore of database
We got a database hosted on Azure SQL Managed Instance.
Got an application change planned soon and as part of implementation plan, we need to manually take a backup of database on Azure SQL Managed ...
- 1
-1
votes
1
answer
67
views
Why does migrate fail with "Memory size of append data exceeds max limit" when restoring a TSDB table?
I have a DolphinDB table dfs://derived_financial_metrics_bk.financial_metrics which is partitioned by DAY and uses the TSDB engine.
I successfully backed up the entire table using the backup function ...
0
votes
1
answer
79
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
411
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
99
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
104
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