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

Would MySQL Replication (master-slave) have prevented this problem?

I'm new to the idea of MySQL Replication (mainly because I've never really had data important enough to have redundancy until recently). Today I had a random crash of my MySQL 8 database with the ...
0 votes
0 answers
54 views

Backup taking longer time than usual in SQL Server

I have rebuilt huge table. After it my database is extended 1.3 TB to 1.5 TB. I don't shrink free space in data file because of it's impact fragmentation of index. After rebuilding process my daily ...
0 votes
1 answer
53 views

Cannot open backup device 'D:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Backup\‪D:\DB_backup\uni.bak'

I have 2 database backup files casa.bak (25 GB) and uni.bak (176 GB) in the same folder. I'm using the same script to restore the database for both files previously both were working successfully. Now ...
0 votes
0 answers
17 views

Backup History in MySQL and PostgreSQL

What tables in MySQL and PostgreSQL keep a log of successful and failed backups? Similar to the backupset table in SQL server's msdb
3 votes
1 answer
131 views

Back up multiple databases to the same backup (BAK) file with encryption

I have a script that we run on an ad-hoc basis that grabs the names of 15 databases, then iterates through that list to backup each one into a single .BAK file. This is then downloaded for use ...
  • 810
0 votes
0 answers
20 views

pg_dump significant size difference between dumps

So we've been doing some temporary backups on windows machines and came across something interesting. Doing plain formatted dumps with no compression and blobs, we get significant size differences ...
2 votes
2 answers
357 views

Why do we keep insert statement in logical backup?

I am new to mysql. Studying about logical backup I found that it contains insert/into statement. I am not able to find a logical explanation why insert/into statements should be included in backups ...
2 votes
1 answer
264 views

MySQL database copy

I need to create a copy of the database in my MySQL Server using a Python program. After a little research, I found mysqldump as the better approach: import subprocess command_to_copy_db = f"...
0 votes
1 answer
86 views

Recommendations for extracting and archiving rows from a fast growing table to keep overall database size within 1tb limit

We have an Azure SQL DB that we want to keep less than 1TB in size because making a DB more than 1TB in Azure also requires doubling the vcores and therefore doubling the cost. There is one table in ...
0 votes
0 answers
22 views

use incremental backups for Oracle standby forward roll on a regular basis?

My boss asked me to create a copy of a production database that lags for one day. Well, it's not a complex task, just have a standby with a 24 hour delay. But it comes with a cost of storing a lot of ...
  • 151
1 vote
2 answers
67 views

How does SQL Server handle data during backup operations?

When taking a backup, does SQL Server first read the data into memory before writing it to the backup file, or does it read the data directly from the data files and write it directly to the backup ...
0 votes
1 answer
41 views

Mariabackup, Xrtrabackup, how those handling InnodDB page compression, meaning: sparse files?

InnoDB engine, when using page compression, heavily depend on file system sparse file support. InnoDB Page Compression. It raises the question, how will mariabackup/xtrabackup handle those InooDB ...
0 votes
0 answers
32 views

When restoring a mysql.daily.dump file in plesk, it only recreates the SQL server but without the table data or structure

The issue began when I removed a subscription from a plesk server that was a staging site for the main site that was also on the same server. However unaware to me the wp-config for the live site had ...
0 votes
0 answers
34 views

Making backups with mariabackup from slave MariaDB. Best Way possible

I am trying to determine the best way to create backups from a MariaDB 1.4 slave, and I have the following questions: Will creating backups affect the MariaDB slave replication and performance? Is it ...
0 votes
1 answer
45 views

Operation not allowed from within a pluggable database Pre-Built Developer VMs for Oracle VM VirtualBox

I downloaded Pre-Built Developer VMs for Oracle VM VirtualBox , which contains Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 I want to BACKUP the Database using Rman, but it is in ...
1 vote
1 answer
38 views

Database Backups Query for SQL Server High Availability Groups

I am use to working with SQL Server Database Mirroring but now we are upgrading to use High Availability Groups. Whenever I had to restore the mirroring on one of the SQL Server database I use to take ...
1 vote
1 answer
21 views

Backing-up Postgresql data when only root login is available (Ubuntu)

I have a Ubuntu-based workstation with several boot issues that prevent any user login - only logging in as "root" works. Before formatting the Ubuntu partition to perform a clean ...
  • 113
2 votes
1 answer
43 views

Why is there a need for backup read replica in AWS RDS even though backup on primary is enabled and read replica created using primary server?

In Working with read replicas - Amazon Relational Database Service, it states: When creating a read replica, there are a few things to consider. First, you must enable automatic backups on the source ...
0 votes
1 answer
43 views

PostgreSQL backup help

In PostgreSQL backup, the file large ( more than 500 GB ) And I need to do daily backup. Have any option, how I not need to backup all of the 50 GB plus the changes daily? Only download the big one ...
1 vote
1 answer
30 views

Backup to a point in time

To be clear from the outset this question is about backing up a database to a specific point in time, not restoring to a point in time. The scenario is this: we have a consultant working on ...
1 vote
1 answer
159 views

Function does not exist then dumping mariadb database to remote host

Im trying to do an initial transfer of my data to a replica server by running this command: sudo mysqldump -f -u root -pPassword --opt mydb | mysql --host=replica01 -C mydb -u restore -pPassword It ...
  • 113
1 vote
0 answers
37 views

TDE - Best Practices for Storing Master Database / TDE Database files and Backups

I have been doing some testing around TDE, in anticipation of enabling in my environments I have TDE enabled on a database which means I cannot restore or attach this database to another server ...
  • 1,769
0 votes
0 answers
32 views

How to include "CHECK" constraint to backup done via phpMyAdmin?

When I export my database from phpMyAdmin (quick method), it does not include CHECK constraints. However, when I run SHOW CREATE TABLE table, I see the constraints. Moreover, foreign constraints are ...
  • 1
0 votes
1 answer
31 views

Azure SQL Database - Restore options for Continuous Integration Builds

We have a Azure SQL Database (PAAS) that acts like a master database for testing new code. The goal is to set up a pipeline that creates a writeable copy of the master database to test new builds ...
  • 425
0 votes
1 answer
246 views

PostgreSQL pg_basebackup: error: could not receive data from WAL stream: SSL SYSCALL error: EOF detected

I am running a WAL log shipping standby/backup server configuration, and I have been using pg_basebackup and to create a full backup of a PostgreSQL database without issues for awhile. But as of this ...
1 vote
0 answers
221 views

pg_restore error could not execute query: ERROR: relation does not exist

I am trying to restore, on the same server but different database, a specific table from a dump file using pg_restore. This table is located on public schema and I want to restore it on public schema ...
  • 137
0 votes
0 answers
105 views

SQL Server - Exclusive access could not be obtained because the database is in use

Took backup of database from SQL Server 2008 R2 Enterprise and trying to restore it on a database on SQL Server 2019 Enterprise but getting error: Exclusive access could not be obtained because the ...
1 vote
1 answer
102 views

Mariabackup in production queries are very slow

I'm using mariabackup to create a new slave from our master server and after I ran the command my database is getting stuck or queries are processed very low. VM 64GB 32 core I'm using NFS storage for ...
0 votes
0 answers
52 views

How to determine the backup source

We are trying to identify what is taking a SQL backup. The physical device name is just a guid which I have seen before when using a VSS type backup but I don't see any backup agent software installed ...
  • 507
1 vote
1 answer
623 views

postgres pg_dump + .pgpass file : no password supplied

per PSQL docs I created a .pgpass file on macOS with 0600 mask. a.b.com:32109:mydb:user1:password1 when I list the file: $ ls -la .pgpass -rw------- 1 user staff 212 Dec 21 12:56 .pgpass export ...
  • 121
0 votes
1 answer
82 views

Disable tail-log backup default

Is there any way to globally set "take tail-log backup" to unchecked in MS Sql Server? I would like to not have to switch to options and disable this option every time I restore a copy from ...
1 vote
1 answer
46 views

Cannot restore log of MS SQL database that was previously TDE encrypted (but is not currently encrypted)

I've run into an odd problem with MS SQL Server. I'm working on automating deployment of TDE and want to be able to make sure that I can still do all the things I expect to be able to do with an ...
  • 151
0 votes
1 answer
87 views

BACKUP LOG cannot be performed because there is no current database backup. Define Current?

I know what the message is telling me; but I am not sure on the definition of "Current" is, I have a Database backup that was performed at 3am on the previous day, that backup resides on a ...
  • 167
0 votes
1 answer
116 views

Can not import ibd to MariaDB 10.4 in xampp

I got a wordpress website, today it give me an error on xampp, I managed to re-install xampp, before this, I create a backup from mysql/data db folders, it contains ibd and frm files, I installed ...
0 votes
0 answers
26 views

Extract data from BKP file or verify if the backup is encrypted

A specific system, previously using a non encrypted Oracle 19 database, has been updated in such a way that now the database is encrypted (same Oracle version). I have successfully verified that the ...
  • 101
0 votes
0 answers
79 views

Backup constantly failing on secondary server with 'Cannot recover a truncated undo tablespace'

We are constantly getting failed backups with xtrabackup when the backup is run from a secondary server. How do we permanently fix this undo tablespace issue on the primary mysql server, so that the ...
  • 185
0 votes
0 answers
147 views

Postgres stuck in wal recovery crashloop

My postgres is deployed on k8s using the timescale helm chart. It's managed by patroni and the backup is managed by pgbackrest. It's been stuck in this state for a day now (removed timestamps etc. ...
  • 105
3 votes
1 answer
78 views

Error in the documentation MariaDB -> mysqlbinlog: `--rewrite-db` and `--database`

In the mysqlbinlog utility documentation, the --rewrite-db=name option has the following explanation Filtering (e.g. with --database=name ) happens AFTER the database rewrites have been performed. ...
  • 483
2 votes
1 answer
87 views

How to copy data between postgres schemas if there are objects?

I removed shop from database, that should not be removed. Fortunately I had backup and reverted this backup to schema public_backup. Now I am trying to restore only this shop. I can't override my ...
  • 209
-2 votes
1 answer
50 views

TB database backup and move

For a SQL Server 2019 we want to backup a 3 TB database to another DB and we want very minimum downtime what is the best way? Thanks
0 votes
0 answers
56 views

Diffrent results recreating .frm files with mysqlfrm between MySQL 5.7 and Percona XtraDB cluster 5.7

Hello to everyone dedicating the time to read this thread. I have recently stumbled upon a problem while restoring a MySQL 5.7 database into a Percona XtraDB cluster 5.7. The restoration process was ...
0 votes
0 answers
34 views

Local to Azure backup errors and question

I am wanting to back up a local SQL Server 2016 database to Azure. When I first started looking into it, I found this quote from the Azure usage calculator. When I tried to set it up, all the ...
  • 193
0 votes
2 answers
158 views

Postgresql backup with ZFS snapshots: Is pg_start_backup()/pg_stop_backup() necessary?

The title says it all. I have found this from 10 years ago saying that if database data it's all in the same snapshot, then isn't needed. PG will start from snapshot like in a typical crash. But what ...
  • 247
0 votes
0 answers
100 views

MySQLPump ends with Segmentation Fault

I am trying to improve the performance of backups using mysqlpump. It works on the smaller databases but the larger ones - where I actually need it - it fails. The output from mysqlpump indicates a ...
0 votes
1 answer
193 views

mariabackup system file permissions

I have an instance of mariadb 10.6.7 on an Ubuntu 22.04 Server and I am trying to do backups of a specific database with mariabackup. mariabackup --backup --user="my_test_user" --target-dir=/...
2 votes
3 answers
59 views

What is a good way to get a time for the data freshness when the source is log shipped to another server?

I'm log shipping from SERVER_A with backups every 10 minutes. I restore the logs to SERVER_B every 20 minutes. I pause the restores while I do a DWH load from SERVER_B into SERVER_C I report out of ...
0 votes
0 answers
276 views

How can I restore Postgres DB with pg_basebackup in my case?

I have two DB servers and backup which is configured by pg_basebackup. You can see whole command below. pg_basebackup -h $PGHOST -p $PGPORT -U $PGUSER -w -D $backup_dir/psql_base_backup_$(date +"%...
  • 1
0 votes
1 answer
49 views

Very long timestamp for a backup file created via a Maintenance Plan

I have been using Maintenance Plans to back up my databases. It works well enough for me but I am curious to know why the .bak have a very long date/time suffix. Here is an example: ...
  • 3
0 votes
1 answer
107 views

Using Ola Hallengren's succeeds to take full backups but fails to take a differential

I take weekly Full backups (all my databases are in Full recovery model) on Sundays and then schedule the Diffs to run nightly (except on Sundays). Looking through my logs I see this: Cannot perform ...
0 votes
0 answers
37 views

Corruption in backup but valid checksum

We have corruption in one of our full backups but I can't find an explanation how it happened. The server is a SQL Server 2019 Enterprise edition (CU17) with 5 databases in an AG. The backups are ...

1
2 3 4 5
52