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,722
questions
1
vote
0
answers
8
views
mydumper packages availability for graviton aarch64
I am trying to implement mydumper for mysql community server (8.0), in absence of xtrabackup for graviton aarch64 architecture.
Unfortunately packages are not available for graviton aarch64 ...
- 179
0
votes
0
answers
6
views
Percona xtrabackup and percona toolkit for aarch64 Graviton Amazon Linux 2 machines
In my organisation, it was decided to move all the MySQL infrastructure (Amazon EC2 machines) to Graviton (aarch64) servers from AMD (x86_64).
All are MySQL Community Servers.
I need percona-...
- 179
1
vote
1
answer
30
views
Does enabling backup compression in a Back Up Database Task enable checksums, no matter what setting you pick for them?
Observations
The documentation says
To enable backup checksums in a BACKUP (Transact-SQL) statement, specify the WITH CHECKSUM option. To disable backup checksums, specify the WITH NO_CHECKSUM option....
- 545
0
votes
0
answers
15
views
Postgres Barman archive command failed
For production environment, I am using this archive command in my postgresql server.
barman-wal-archive backup pg /var/lib/edb-pge/15/data/pg_wal/%f
Now when I manually run this command on my ...
- 1
-1
votes
0
answers
48
views
Best Practices for Migrating 2TB MSSQL Databases with High Availability to PostgreSQL
I'm planning to migrate a large-scale MSSQL environment to PostgreSQL and would appreciate some advice and best practices. Here are the details of our current setup:
Current Environment:
Two servers ...
4
votes
1
answer
109
views
Backups/CHECKDB errors - "Cannot find server certificate"
I have been exchanging TDE certificates on various servers to make restores easier - some had the wrong name, the wrong thumbprint, or even both. This involves transferring databases to a temporary ...
0
votes
0
answers
20
views
SQL server is already part of a cluster error; cannot re-add after removing offline SQL node
I'm new here but I've run out of options for my search on this issue my team is having. To give a relatively short backstory; I know almost nothing about SQL beside what I've learned from a short time ...
1
vote
2
answers
97
views
Understanding Recovery Forks in SQL Server: Meaning and Significance
I'm trying to understand the concept of recovery forks in SQL Server, particularly in relation to the sys.database_recovery_status view. The documentation mentions several columns related to recovery ...
- 2,030
0
votes
0
answers
13
views
Crunchydata - PGO - Postgres(v 14.x) restore not working as expected
We have set up PostgreSQL, including its backup and recovery processes based on crunchy data Postgres Operator, as per the documentation.
The backups are occurring as expected. However, when we ...
0
votes
0
answers
29
views
Error Delete Distributor on sql Server 2019
I can't delete Distributor. The system shoew message error "Could not drop the Distributor 'Dis_name'. This Distributor has associated distribution database"
- 1
0
votes
0
answers
15
views
DB2 backup from Data Studio throws sqlcode=-22212
When I try to back up a database, the process fails with the error:
Attempt to connect to DAS failed with the following error: sqlcode=SQL22212N
db2dasrrm.exe runs under the PID from the netstat ...
- 13
0
votes
2
answers
63
views
How to Restore RMAN Backup at Specific Date
I have daily backups of my test system which is taken daily full backups and also hourly arch backups. I need to restore one of these backups to another linux server. I've completed all steps until ...
- 125
0
votes
1
answer
48
views
Oracle database backup recovery
Just startet to study Oracle, i need to restore database backup. Log file said it was made in Oracle Database 10g Enterprise. I have Oracle XE 18, is it even possible to make it for XE version usind ...
-1
votes
3
answers
146
views
Does it make sense to Full Back up weekly or Back up Transaction Log every 15 min?
I have to make a decision (at work) to choose which option is more feasible using SQL Server 2019:
Option 1: Full backups sent once per week and differential backups sent between weekly backups.
...
- 233
0
votes
1
answer
27
views
How do I restore a PostgreSQL/TimescaleDB pg_basebackup tar on Windows? postgresql-x64-15 immediately stops on start
I'm going thru the various online processes to expand the pg_basebackup tar file into the C:\Program Files\PostgreSQL\15\data, such as Restore data from tar file for unix, but when restoring on ...
- 101