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
1answer
324 views

Restore oracle database 12C incremental backup on daily basis

i need to restore my backup at different database server with following sequence on daily basis level 0 incremental only once level 1 incremental everyday i did the level 0 restore successfully ...
3
votes
3answers
7k views

PostgreSQL Write Ahead Logs Archive Mode

I'm trying to figure out various things surrounding PostgreSQL and how backups should work together with WAL and Commvault Simpana. Simpana is telling me that everything is ok, but leaves files lying ...
2
votes
1answer
2k views

How to configure AutoMySQLBackup?

How I can configure AutoMySQLBackup to backup some selected tables ones per week while the other tables will be backed up every day? Thanks. P.S. My google search ninja skills is not working. :)
0
votes
2answers
1k views

MySQL duplicate entry error opon import to new server

I do have a DB on MySQL Galera 5.6.34 with a table that contains an index on ID,date. The table is fully functional and I have used repair and check to verify the table. However, upon backup/restore ...
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
43 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 ...
4
votes
3answers
799 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
1answer
96 views

Built-in Postgres' Automatic Backup

Is there any automatic built-in mechanism in postgres to backup data if the data have exceeded the maximum permissible storage amount?
0
votes
2answers
45 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
3answers
193 views

The media family on device incorrectly formed for read only file group restore

Yes the databases (source and destination) are the same version. I have checked 3 times. Both are "Microsoft SQL Server 2019 (RTM-CU8-GDR) (KB4583459) - 15.0.4083.2 (X64)" The database ...
0
votes
1answer
18 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
30 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
23 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
63 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
18 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
1answer
138 views

PostgreSQL Continuous Archiving & Point-in-Time Recovery in combination with netbackup

I have the following setup: OS: CentOS PostgreSQL 12 Netbackup 8 What I want to achieve: Configure continuous archiving with the possibility of Point-in-Time Recovery My current idea: Generate a ...
0
votes
1answer
95 views

Disaster Recovery for Postgres DB 13

We are planning to implement disaster recovery (DR) for a Postgres DB. What I understood from my basic research: pg_basebackup shall be used instead of pg_dumpall (Performance perpective) or like to ...
0
votes
0answers
53 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
1answer
351 views

How to mount a pg_basebackup on a stand alone server to retrieve accidently deleted data

Had a bit of a brain fade the other day and deleted all the rows in one of the tables in our database and didn't realise until a couple of hours later. I have a pg_basebackup file system copy created ...
0
votes
0answers
42 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
14 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
53 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
256 views

MySQL backup of incremental changesets

With a MySQL database, is there a way of logging and/or backing up incremental changesets? We have a number of large databases (100-200 GB), for which we take daily backups using mysqldump. These ...
2
votes
1answer
2k views

Galera - single database backup & restore

I have a MariaDB Galera cluster. One of its nodes is dedicated for the backups (pc.weight=0 and the MaxScale SQL proxy doesn't know it exists). I'm using mariabackup --backup --galera-info --target-...
0
votes
1answer
20 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
33 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 *.*...
0
votes
1answer
120 views

What is the theory and workflow for taking a snapshot of a PostgreSQL database and restoring it in a running application?

The only thing I could find to get started is: Is it possible to quickly create/restore database snapshots with PostgreSQL? I also see things like this, but I'm not sure if that's all you need. I am ...
1
vote
1answer
278 views

Ola Hallengren's backups scripts, cleanup only mode

Is it possible to run Ola Hallengren's backup scripts in cleanup only mode? I have a couple of servers where the cleanup time was set too long, and I now have to clean up hundreds of databases worth ...
1
vote
1answer
319 views

mariabackup crashing, help

Hi I'm using mariabackup on one of my MariaDB 10.5.4 nodes from my Galera Cluster and whenever I run it i get this from my output logs: [00] 2020-08-05 11:26:40 Connecting to MySQL server host: ...
1
vote
1answer
562 views

IMPORT TABLESPACE is hanging in the 'System lock' state

We have a development database server with Percona-server 5.7.15-9 on it. It replicates two schemas from two different production servers using multi-source GTID replication. Lets call these schemas ...
1
vote
2answers
104 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 ...
4
votes
1answer
1k views

pg_dump does not honor -n

I'm using pg_dump (9.2 database), to extract one schema and load this into another database (9.4). well, here's the command: pg_dump -f file.sql -F plain --inserts -n schema database Ok. My ...
1
vote
2answers
49 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
1answer
14 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/...
2
votes
1answer
1k views

Progress of mongodump operation jams at a random point

We are executing remote mongodumps to backup collections. For some time now sporadically one of these dumps stops to progress any further and remains to log out the same amount of documents processed ...
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
2
votes
2answers
261 views

Corruption in mariadb binlog

I have an installation with mariadb version 10.0.21. I need to backup the binlog file every 5 minutes to TSM, but as the binlog is being written every second, i am afraid of the file getting ...
0
votes
0answers
15 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
26 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 ...
0
votes
1answer
138 views

SQL Server Backup Failure

This one has me stumped and I'm sure there is a simple explanation that I cannot fathom at present. A few informational pieces: vCentre Database - SIMPLE Recovery Model SQL Server 2008 R2 Standard ...
2
votes
1answer
31 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
135 views

Proper way of restoring base backups

We have daily backups of a postgres db and it is in the form of a tarred (gz) base backup. I need to restore this into another db of the same version. However, I am confused with the article that I am ...
0
votes
1answer
148 views

Having two data folder in my postgresql setup- Postgresql

I am using centos 6 and installed Postgresql_9.4 using the following commands yum install postgresql postgresql-contrib postgresql-client pgadmin3 yum install postgresql-server After that i ...
0
votes
1answer
300 views

Percona Xtrabackup fails to backup InnoDB table with fulltext index

I'm trying to make a backup of a large InnoDB table with a fulltext index using Percona Xtrabackup (2.4.12). I have innodb_file_per_table set. To create the backup, I'm running: innobackupex --...
12
votes
2answers
53k views

SQL Server backup failing. Error: 3041, Severity: 16, State: 1

First of all, I'm very new at stackexchange, so please bear with me. I'm running a SQL Server 9.0.4060. My problem is: my SQL Server backup keeps failing on a lot of the databases. The Maintenance ...
0
votes
1answer
224 views

Oracle 12cR2 RMAN - ORA-01547, ORA-01194, RMAN-06054

Oracle 12cR2. Error: channel default: deleting archived log(s) archived log file name=+RECO/.../thread_1_seq_166200.26582.1054942673 RECID=62 STAMP=1054943183 archived log file name=+RECO/.../...

1
2 3 4 5
52