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,775
questions
0
votes
1
answer
1k
views
Backup and restore of large SQL Server database with least downtime
I am trying to migrate a SQL Server 2016 database to a SQL Server 2019 server. The database is huge at about 500 GB. It takes about 3 hours to create a Full compressed Backup of about 300 GB and 2.5 ...
2
votes
2
answers
399
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 ...
1
vote
2
answers
1k
views
barman & Dockerized PostgreSQL: check timeout: FAILED (barman check command timed out)
I am trying to configure barman to backup a PostgreSQL 11 database running inside a Docker container. barman v2.10 is installed directly in the Ubuntu 18.04.3 host machine.
barman check pgsql gives ...
0
votes
1
answer
2k
views
Archive log backup error and backup completed with errors
My prod DB backup completed with errors stating the below error.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =======...
1
vote
2
answers
79
views
last backup - how many backup files and where they are?
I am restoring a database, this database is very big and it has 6 backup files (meaning the backup is split into 6 smaller files)
I can see an indication of that using the restore labelonly
...
1
vote
3
answers
5k
views
A database differential backup without a full backup
At 10 pm, I scheduled a SQL Agent job to do a daily backups with the schedule:
Daily Full: 22:00
Differential: Every 4 hours
Log: Every 30 minutes
Now when I check my backup set(let's say at 22:30), ...
0
votes
1
answer
306
views
MySQL - Backup new and modified entries only
I am developing a very huge system in Java using Hibernate and MySQL. Now, I want to automate the daily, weekly, and/or monthly replication (backing up) of the data that are stored from the database ...
0
votes
1
answer
66
views
Log .ldf file not truncate after several times of log backup on secondary database
i have always on setup in production environment. Scheduled backup (transaction log backup) already in place every 2 hours using netbackup on secondary database.
The issue i am facing is sometimes the ...
2
votes
3
answers
2k
views
Backup Performance best practices
I'm in the process of re-writing our maintenance plans and at the moment the focus is backups. Whilst preparing this plan, I'd like to try and ensure that procedures are in place to ensure that backup ...
11
votes
1
answer
15k
views
How can I fix "Cannot perform a differential backup ... a current database backup doesn't exist"?
We recently switched to the FULL recovery model, with full backups being done every weekend, and differentials being taken every day.
The problem is, the differential backups don't always seem to ...
1
vote
4
answers
1k
views
Difference between Backup and Snapshot
I've been reading article after article about the difference between a Database Backup and a Snapshot and they just don't make any sense, so please help me undersand
"A snapshot is an image of ...
0
votes
1
answer
48
views
Reading data from PostgreSQL backup directory
Let's say I have a backup directory containing PostgreSQL data from some other system. By default, the data is stored at /var/lib/postgresql. After changing the default data directory to the path of ...
0
votes
2
answers
9k
views
Postgresql - Large object exists in pg_largeobject table but cannot open with lo_open?
I have a problem with opening Large Object in postgresql version 9.2,
select * from pg_largeobject where loid = '19423';
will return data like this:
loid oid;page no integer;data bytea
19423;0;"<...
0
votes
1
answer
520
views
MongoDB restoring to existing replica set (avoid creating a new one)
I have a MongoDB cluster runnning on 3 AWS EC2 instances, 1 for primary and 2 secondary nodes. I'm trying to perform a backup and restore without having to recreate the replica set. mongodump seems a ...
0
votes
1
answer
55
views
Merging old backup in current database mysql
I have a backup database that contains data up to the specific date 27-11-2023. Currently, I have the latest version of the database with updated records. However, the issue arises when I consider ...
22
votes
2
answers
11k
views
Get postgres snapshot from Amazon RDS
I can not find a simple way to get a copy of the nightly backup I take of my Amazon RDS postgres instance so I can restore it on my local machine to play with.
Right now I'm doing a pg_dump when I ...
2
votes
1
answer
62
views
how percona hot backup works / innodb crash recovery works?
I am trying to understand the process of how percona does hot backup.
from what in understand is, they use innodb crash recovery mechanism and execute the following steps.
store/remember start LSN ...
1
vote
1
answer
192
views
RMAN backup restoration
I am trying to restore a RMAN backup to a different server. I needed some clarifications/guidance.
This is the location for datafiles in database 1:
/u01/app/oracle/oradata/db1/datafile
This is the ...
0
votes
0
answers
50
views
Problem restoring partial mariabackup
I follow this method to perform a partial and incremental backup of my database on two servers, bskpserver and devserver. Everything works fine except for some tables. When I try to restore them on ...
0
votes
2
answers
30
views
maintaing backup log sequence after executing BACKUP DATABASE databasename command manually [duplicate]
I am new to database admin role and I have to configure backups for a new client.
I want an advice on how to handle below scenario.
I want to configure a weekly full backup along with incremental ...
0
votes
2
answers
43
views
What sql statements is mysqldump executing and how does it affect database performance?
I noticed a SELECT * FROM query running on a big table from time to time and i wonder if this could be, because of mysqldump. We have mysqldump backups running for some tables. Does somebody know what ...
1
vote
3
answers
152
views
Does a SQL Server Log Backup Include Log Records Backed Up in a Previous Full or Differential Backup?
I've been reading the Microsoft documentation on log backups in SQL Server and came across the following statement:
(Log Backup) Specifies a backup of the transaction log only. The log is backed up ...
0
votes
1
answer
104
views
Error message when running a SQL maintenance plan backup
I'm receiving the following error message when my daily maintenance backup plans execute:
Error Message 1:
[298] SQLServer Error: 407, Internal error. The string routine in file e:\sql11_main_t\sql\...
0
votes
0
answers
117
views
mysqldump on replica for backup and GTID
I use replica instead source database for backups. After enabling GTID mode I am not sure how I should use mysqldump to make correct dump. This backup is for source recovery of course.
mysqldump --...
0
votes
2
answers
82
views
Database tenancy model
I'm redoing a legacy system, and currently, I have a database with the same structure for each client. I'm really unsure whether I should maintain it this way for the new system or if I should create ...
1
vote
1
answer
43
views
Modeling a data processing system for consigned employees
I'm currently in the process of developing a payroll system using SQL Server and PHP. However, the system involves a multitude of processing rules.
During this processing, I may receive files ranging ...
0
votes
1
answer
186
views
batch script to get all the tables in postgres database as csv
I have a remote postgresql database with a lot of schemas. I want to dump the tables that is specific schema as .CSV file for each table. I'm aware of the COPY command but I'm not sure how to write a ...
1
vote
0
answers
52
views
Restore Job in MSSQL failing [duplicate]
The backup job of being completed, however, the restoring job is failing.
//EDIT
I am trying to perform logshipping
Getting the following errors:
Date 10/25/2023 4:45:00 PM
Log Job History (...
0
votes
0
answers
139
views
ERROR 4078 (HY000) at line 167956: Illegal parameter data types uuid and int for operation '='
I'm using this command to backup all of my MariaDB databases and gzip them all:
mariadb-dump -pPassword --all-databases --routines --events --single-transaction | gzip -c > dump.sql.gz
Then I copy ...
0
votes
0
answers
32
views
Restore SQLServer Encrypted Backup on a server with higher version
I want to implement Backup Encryption. I have tested in Test server this process with success.
Before implementing on production I want to make sure that I am considering all risk.
The only thing that ...
0
votes
0
answers
72
views
Sql server database restoring from backup, sql users without login
After restoring a database from another SQL server, set database comes with database users without login. Do these users have any actual functionality or they are practically dead users? I've looked ...
0
votes
2
answers
52
views
Create backup of Postgres DB schemas
I have two servers and 5 schemes in Postgres, one server is in production and the other is in the background.
Windows server 2019
Postgres 12.7
I have these schemas in the postgres database which is ...
0
votes
1
answer
138
views
TablePlus: backup and restore DB with circular FK contraints/references
After a backup on TablePlus (documentation) with only the --format=custom option, I got the following:
Backup database 'postgres'
Dumping...
warning: there are circular foreign-key constraints on this ...
0
votes
1
answer
1k
views
ORA-19914: unable to encrypt backup and ORA-28365: wallet is not open
I have been taking backup of my database daily, and for some reason, I suddenly got this error
ORA-19914: unable to encrypt backup ORA-28365: wallet is not open
this is my databases's current ...
0
votes
0
answers
17
views
Restoring PDBs on a new server
I am trying to restore a 19c database on a new server using RMAN. What are the prerequisites? Do I have to first create PDBs which are supposed to be restored? Or should I just restore from ...
0
votes
1
answer
36
views
Can we do restoration using full backup on secondary and , differential and log backup on primary?
i have strange requirement in my environment but i need to ask this question to meet the business objective.
Can we do restoration using full backup on secondary and differential and log backup on ...
0
votes
0
answers
66
views
Restore issue with Pgbackrest
I am using Pgbackrest to backup and restore postgresql databases.
Backup is okay, but when I want to restore database to point in time or last backup, although database files are located in data ...
0
votes
1
answer
103
views
mysql hot backup with upgrade support
I perform a hot backup of a production mysql database using an LVM snapshot, and then I attempt to restore said backup on a development machine. However, the dev mysql database will not start, and ...
0
votes
1
answer
83
views
pg_archivecleanup
I need to use the pg_archivecleanup command to delete log generated in a primary node from a cluster postgresql but I see that running the next line does not delete anything.
pg_archievecleanup -d /...
1
vote
0
answers
35
views
Is there any tool that can be used to backup and restore individual schemas and not the entire database?
Can someone help me with any tool that can be used to incrementally back up the individual schemas and restore them instead of backing up the entire DB? We need this for the Aurora MySQL DB RDS ...
0
votes
0
answers
29
views
Is it possible to backup AWS RDS Aurora MySQL per database by any AWS services?
I have several AWS RDS Aurora clusters, and user data is stored in different database.
Currently I have my own script to backup per database, but I am considering to backup through AWS provided ...
1
vote
1
answer
68
views
Failed MSSQL Backup Restoration Due to Defunct State in a File: How to Resolve?
I'm having trouble restoring an MSSQL backup because one of the files is in a defunct state. I need help fixing this to complete the restoration. Thank you!
Additionally, my MSSQL backup restoration ...
0
votes
1
answer
80
views
Whether to run integrity check before or after backups (Ola H FAQ)?
Going through Ola H FAQ's, https://ola.hallengren.com/frequently-asked-questions.html, I see that
I also recommend that you perform the full backup after the integrity
check.
Isn't the opposite true?...
4
votes
2
answers
5k
views
Database backup - Use case of FORMAT and INIT
I understand that FORMAT looks at mediaset level and if set then creates a new media set so if there are any existing backupsets then they will no longer be available.
Also, INIT looks at backupset ...
0
votes
1
answer
45
views
Understanding Full Backup Process in SQL Server: Do All Allocated Extents Get Backed Up?
I've been reading a blog post by Paul Randal on the SQL Server backup process, where he outlines the main phases of a full backup. One point he mentions is that during a full backup, the process reads ...
5
votes
1
answer
3k
views
mysqlpump --set-gtid-purged=OFF still adds @SESSION.SQL_LOG_BIN=0;
Whenever I add --set-gtid-purged=OFF, it still adds @@SESSION.SQL_LOG_BIN=0; to the output.
According to the documentation, shouldn't it get removed?
--set-gtid-purged=OFF: SET @@SESSION.SQL_LOG_BIN=...
1
vote
1
answer
417
views
VSSSQLwriter error
I've a SQl server 2019 on a Windows Server 2019 standard core, I manage two typer of backup, one with mantainance plans and one with Veeam Backup. The mantainance plans it's ok, the backup with Veeam ...
0
votes
1
answer
44
views
Mariabackup flush and delete bin log
I'm using Mariabackup and I'd like to know if there is an option to allow me to rotate the binary log when running mariabackup. I can't seem to find anything in the documentation.
0
votes
0
answers
143
views
Use PowerShell script to backup SQL Server 2019 Express database to a network destination
I've got a SQL database server (SQL Server 2019 Express) and a application server connected by a simple switch. Now I'd like to back up a SQL database to the application server.
Since its an SQL ...
-1
votes
1
answer
37
views
How do database snapshots work?
How do database engines take consistent snapshots when writes could be happening at any time?
(A) Does the database engine block writes one table at a time while taking snapshots?
(B) Does the ...