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,581
questions
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 ...
- 105
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 ...
- 1
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 ...
- 21
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"...
- 121
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 ...
- 101
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 ...
- 897
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 ...
- 167
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 ...
- 1
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 ...
- 3
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 ...
- 67
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 ...
- 21
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 ...
- 37
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
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 ...
- 441
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 ...
- 101
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=/...
- 1
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 ...
- 23
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,994