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.

Filter by
Sorted by
Tagged with
0
votes
0answers
10 views

Oracle Rman recovery to another database on different location

We had production user facing data loss from production Oracle database and only wanted to recover just one schema in the test database from a week ago. Backup team was able to retrieve the physical ...
1
vote
2answers
40 views

InnoDB: Cannot close file ./tablefile.ibd because of 1 pending operations

MariaDB Version: '10.5.13-9 I am facing multiple unsuccessful data migration(Copy) attempts from my old legacy data environment to my DBaaS Container Environment. Performing this data migration using ...
0
votes
2answers
38 views

Restoring secondary backup files on primary server in sql server

I want to restore log backup file on copy-only full backup in restoring mode on primary replica server these backups were taken from secondary replica but it was error when they are restored on ...
0
votes
1answer
73 views

SQL Server Availability group and Backups

SQL Server availability group backup preferences. We have 3 nodes for our AG. I would like to take full and differential backups on primary, log backups on secondary. When I configured "any ...
0
votes
1answer
16 views

Backing up a DB on remote server

I need to backup a postgres DB which is located on a remote server. This server also hosts a lot of other stuff, and that's why I don't have a general access to the server itself. Therefore I believe ...
-2
votes
2answers
31 views

SQL Server Resource Usage

I am a very new DBA, I have been given a task to know in depth the following metrics : Waits How they occur The impact they have to the business How to resolve or eliminate them Memory What is the use ...
0
votes
2answers
41 views

Does only a full backup (and no tlog backup) of a db in full recovery model allow for point in time recovery?

I have a database in full recovery model. Full backups are configured to run every Sunday and log backups run every day. Log backup files are destroyed after 30 days. Full backups are destroyed after ...
0
votes
1answer
44 views

SQL Server Access Database in Filesystem

We have a Windows Server 2008 which is offline. We no longer have access to the server OS, or any GUI tools, but we do have a backup of the entire C:/ of this server. This server used to host an SQL ...
5
votes
3answers
819 views

Does GDPR require deleted backups to be rendered unrecoverable?

Although GDPR has been in place for some time, my organisation has had a dispensation to essentially ignore it up until now. The dispensation was because the contract from the government we were on ...
0
votes
2answers
51 views

upgrade to postgres 14 from postgres 13 using pg_basebackup

I want to upgrade/move a running timescale cluster manage by Patroni using PostgreSQL 13 to a new hardware with PostgreSQL 14, the dataset is ~ 40GB but is taking ages take a backup using: pg_dump -j ...
0
votes
1answer
23 views

How to backup from MySQL Ubuntu to Synology NAS MariaDB

I am facing difficulties when setting up MariaDB on Synology NAS as slave to replicate my server on Ubuntu. But there are missing commands and files (my.cnf) in the installation. Need help on any ...
0
votes
2answers
31 views

How to optimize a big table for backup

I have a table that is not too much big but still, it takes 30GB of storage. When I try to make a backup with mysqldump it takes a lot of time and resources and I want to optimize it but I don't know ...
1
vote
1answer
30 views

Why store /var/lib/mysql when you can just create SQL dumps for backup purposes?

Tools like mariabackup offer the possibility to create full and incremental file system backups of /var/lib/mysql but I don't quite understand what additional safety layer this would give me if I ...
0
votes
1answer
70 views

DatabaseBackup backs up the same database twice?

I use the Ola Hallengren DatabaseBackup procedure to run backups. I have two jobs configured so the backups can run parallel as I have one large database that takes 45 minutes to back up and many ...
0
votes
1answer
19 views

Make a copy of database with new collation

I have a small hobby project in Django backed by Cloud SQL Postgres instance. Recently I realised that data sorting is not correct and identified it as issue with collation setting. Indeed collation ...
0
votes
0answers
66 views

RMAN-08138: WARNING: archived log not deleted - must create more backups

I have a primary oracle database and a logical standby. Primary database information BANNER CON_ID ------------------------...
0
votes
0answers
47 views

mariabackup trouble between Windows and Linux

I am finally trying to migrate a database from Windows to Linux. I am running MariaDB 10.4 (I have also tried mariabackup from 10.4.22 too) I do this: mariabackup --backup --target-dir=e:\transport --...
0
votes
0answers
17 views

What's the difference between "--section=data" and "--data-only" of pg_dump/pg_restore?

In the man page of pg_dump/pg_restore, that is mentioned about --data-only option(but I didn't find --section=data) as following: --data-only Dump only the data, not the schema (data definitions). ...
0
votes
1answer
71 views

pg_basebackup is taking too long

I am trying to setup streaming replication on Linux. pg_basebackup is failing due to huge data size i.e 7TB. It's failing because it's taking too long to backup i.e. 20 hrs. and the required WAL file ...
0
votes
1answer
21 views

General Questions about using MySQL with Docker, logging options

I have a number of questions about logging / backup strategies when using MySQL with Docker specifically and also just general questions. The particular scenario is MySQL DB's for a small medical ...
1
vote
1answer
47 views

Why does mysqldump not backup procedures?

I am running MySQL 8.0.23 and try to backup/restore procedures. Therefore I created a user "dump@localhost" with the following rights: > Grants for dump@localhost > GRANT PROCESS ON *.*...
1
vote
2answers
55 views

This differential backup cannot be restored because the database has not been restored to the correct earlier state

This is what I did: Took full backup Took Differential backup (immediately after full) Moved above files to DR server Restore full (successfully) Restore differential (error) RESTORE DATABASE ...
0
votes
0answers
15 views

NO delete from old backup

Does anyone have any idea why my old backups are not deleted although I have correctly configured the backup retention for 1 day thank you for your help
0
votes
0answers
17 views

Joining server to new cluster broken pipe error

While joining the cluster it seems as the connection is broken between donor and joiner. At least that's what the broken pipe error represents. Any way to keep the two server talking to one another ...
0
votes
1answer
27 views

Is there any limit on file count while we're splitting backup to multiple files?

I'm trying to split the backup file into multiple files to copy them from one DC to another. Can't find any information about max file count. How many files I can create while I'm trying to split the ...
2
votes
1answer
36 views

How to list backups when not connected to target DB in Oracle RMAN

I'm trying to list backups in RMAN completed within a certain date range. This works fine when I can connect to the target database and recovery catalog. However, I'm assuming a situation where I am ...
0
votes
1answer
17 views

Cannot prepare backup with innobackupex

I taken full backup from a Master server with innobackupex. Now I am restoring backup with innobackupex on a Slave server. I prepare backup with the command: innobackupex --defaults-file=/var/lib/...
1
vote
1answer
28 views

Azure SQL Managed Backup

I have a SQL 2017 on-prem database server that the client wants to back up to Azure storage directly; instead of using local storage. The largest database backup is 4-5TB. I read the MS documentation ...
0
votes
0answers
27 views

db backup fail, cannot allocate memory

We've got 325GB large postgres database on windows (PostgreSQL 12.8, compiled by Visual C++ build 1914, 64-bit) with a failing database backup with the following message (names of the table and the ...
0
votes
1answer
26 views

WAL streaming backups with barman - WAL archive: FAILED

I am setting up a barman server to backup a remote PostgreSQL server and am digging my way through a bunch of FAILED messages I get on barman check [pg] Server pg: WAL archive: FAILED (please ...
0
votes
1answer
34 views

Azure VM backup best practice

I have a customer who has just lifted-n-shifted their 1TB SQL Server 2008 R2 production, and QA servers (2 servers) to Azure IaaS from a small cloud provider. What is the best practice for backups? I ...
0
votes
1answer
29 views

barman check - what do the Error Messages mean?

Trying to get wal-streaming backups for PostgreSQL running with a barman backup server I face quite some errors on barman check [postgres_server] here an example :~> barman check pg Server pg: ...
0
votes
0answers
45 views

MariaDB "freezes" during mariabackup operation

The Scenario: I have a MariaDB running in a server named dbmaster, in a dedicated ProxMox server. This dbmaster runs: Ubuntu 20.04 MariaDB 10.3.31 (installed from repository) maria-backup 1:10.3.31-...
0
votes
0answers
12 views

Which rights does a user need to backup procedures in MySQL 8.x?

I am performing a backup on MySQL 8.0.26 which needs to include all routines, triggers, events etc. in order to be fully recoverable. The command I am using: /usr/bin/mysqldump -u $MUSER -p$MPASS ...
0
votes
0answers
20 views

How to restore the backup of schema taken using pgdump from a different RDS to a different RDS in postgresql?

I have 2 RDS in AWS actually . I need to take the schema from one of the RDS and restore it into the second RDS without taking the table data. So i have taken the backup using this command in bastion ...
0
votes
2answers
38 views

barman installation without root priviledges - where to put barman.conf?

I am trying to figure out a Barman-2.13 installation via Ansible from the source code from github as barman user inside /opt/barman (which also is the home of the barman user). I use the barman manual ...
0
votes
1answer
58 views

Why backup db is of more size than restore db which was restored from backup?

I got a 42 MB .bak file, when restored, the database size is about 2048.00 MB. When I do backup for this DB .bak file size becomes 277 MB. Why .bak file size increases? I do it immediately after ...
0
votes
1answer
29 views

pg_basebackup and multiple tablespaces

I have the following case: the master database has an additional tablespace I'm trying to replicate the master with the pg_basebackup tool the directory / partition layout on the slave is the same as ...
2
votes
3answers
329 views

SQL Full DB Backup performance on different Hardware

I wrote a fairly simple script that creates in a periodic interval a backup of our DBs, switching automatically into differential in case a full backup already exists. This runs great on my system. A ...
1
vote
2answers
106 views

In SQL Server the backup file is around 190 gb, but when restore the log needs around 2 TB space

From the production the database is backed up automatically every day full backup and every 1 hour for transactional backup. A test server was prepared and I want to restore the latest full backup to ...
2
votes
1answer
91 views

PgBackrest perfom restore without wal files

Is it possible to restore a full backup from pgbackrest without the archive files? I tried to restore a full backup on another server but when I tried to start the instance via pg_ctl start I get an ...
0
votes
2answers
44 views

Does using the export option to backup a MySQL database (12GB size) cause any performance issues or locking on database?

I have a 12GB database. I want to take a compressed backup using the export option via phpmyadmin. Does this cause any performance impact or locking on the database?
1
vote
2answers
45 views

Make running MySQL with InnoDB flush everything to file to allow file-level live backup

A client has a file-level backup, where every relevant file of a critical webserver is synced to another webserver around 1am. This includes the /var/lib/mysql directory where the databases of that ...
0
votes
0answers
59 views

Use scoped credential when running database backup

I'm trying to use credentials in scoped manner, since I don't have access to create credentials in server, where I need to run database backup. When trying to backup database with scoped credentials, ...
0
votes
1answer
38 views

How to configure copy only full backup in veeam?

Application aware full backups and log backups are configured in the veeam settings as shown in screenshot below. I want to modify the settings such that full backups are using the copy only mode. ...
2
votes
1answer
78 views

Transaction log file size growing, what will be the consequences of setting recovery mode to simple

Recovery mode is set to FULL, and FULL backup is taken on alternate days. No log/differential backups. Log file size is growing too big. I've shrank log file (googled) a week back and was fine. Now ...
1
vote
1answer
29 views

How to take mysqldump of specific tables across all databases and restore them to a a single database?

I need to take a mysqldump of specific tables across all databases in a cluster. In this case the cluster has more than 300+ databases. And I need to take the dump of table1 and table2 from each of ...
0
votes
1answer
44 views

MariaDB: Periodic copy of data from local database to remote database

I need to periodically copy the outcome of a view on our local database to another remote database. I've tried using mysqldump which works fine when copying data from tables to tables, but i need to ...
0
votes
0answers
137 views

SQL RESTORE FILELISTONLY query brings error in event viewer - BackupIoRequest::ReportIoError: read failure on backup device

I use the following query: RESTORE FILELISTONLY FROM disk = N'E:\Tmp\metadata2012.metadata' with CONTINUE_AFTER_ERROR --or even like that --RESTORE FILELISTONLY FROM disk = N'E:\Tmp\metadata2012....
0
votes
0answers
43 views

ERROR: Error when fetching backup: pg_basebackup exited with code=1 when start patroni service for a replica

I created a cluster including 3 servers via Patroni. Everything was alright like failover, switchover... but when I try to add another replica server I am getting an error like this: Eki 25 13:19:22 ...

1
2 3 4 5
52