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,481
questions
0
votes
0answers
3 views
How do I stop WAL streaming in BARMAN cron?
I am having an issue "resetting" or fixing a backup server I have in BARMAN:
-bash-4.2$ barman check *server-name*
Server *server-name*:
PostgreSQL: OK
superuser or standard ...
-1
votes
0answers
5 views
How to backup clickhouse over SSH?
In postgreSQL, I usually run this command to backup and compress (since my country have really low bandwidth) from server to local:
mkdir -p tmp/backup
ssh sshuser@dbserver -p 22 "cd /tmp; ...
0
votes
1answer
17 views
Changed DB_RECOVERY_FILE_DEST path, but RMAN still backs up to the old path?
I just recently changed the DB_RECOVERY_FILE_DEST parameter to point to a new directory path. However, I noticed only some archivelogs and backup sets are going to this new directory path and some are ...
0
votes
2answers
24 views
MySQL Dump only views, triggers, events and procedures
how are you?
I need to generate a file with all triggers, events, procedures from a server's databases and tried the two commands below
mysqldump -u root -p --all-databases --host=127.0.0.1 --no-data
...
0
votes
1answer
51 views
Backing up database AND backing up whole server - does that cross-multiply storage space? X * Y?
I'm a database guy. I don't deal with infrastructure/ sysadmin stuff (although obviously it ties in together a lot).
If I'm backing up say SQL Server to enable a certain amount of recoveries -- say ...
0
votes
0answers
14 views
Is that ok if backup folder of Barman is much bigger than actual DB size?
My PostgreSQL DB folder size is 25GB
/dev/sdb1 1000G 25G 976G 3% /mnt/data
But backup folder is like 411GB
My retention policy is recovery window of 2 weeks. Is that ...
1
vote
1answer
52 views
Restore a postgres cluster from files
Not a postgres pro and the DBs in question are not that important (personal NAS), but being a technically minded person and knowing MS SQL / MySQL fairly well I thought that maybe I can give this a go....
0
votes
1answer
45 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 ...
6
votes
3answers
562 views
Restore database of 90GB to computer of only 100GB
How do I restore a huge Microsoft SQL Server database that is 6GB as a zip file and 90GB as a bak file to a computer that only has 100GB free space?
When I uncompress the zip file I get a bak file ...
0
votes
1answer
30 views
How to Ensure all Log backups are restored on secondary server in log shipping
I have some concerns regarding the restore job on secondary server in log shipping in Microsoft SQL Server 2016 for below scenario :
I have two servers, primary and secondary. The backup, copy and ...
0
votes
0answers
18 views
How to tarball just the latest pgbackrest backup?
I currently have pgbackrest working fine to backup to a local backup repo on the database server's own filesystem. We have an internal fileserver that is intended to store all backup files, but I ...
0
votes
0answers
18 views
MongoDB restore. Recover after failure
Is it possible to resume mongo backup restoration after failure? I'm getting an error
2021-07-01T23:35:01.944+0200 Failed: dbname.collectionname_backup: error restoring from archive 'mongodb-db-...
1
vote
2answers
78 views
Understanding the floor performance of a SQL Server snapshot restore
I'm currently working on understanding the performance of snapshot restores in my company's test suite. I've read a lot of material online about how the time it takes to perform a restore is directly ...
0
votes
1answer
9 views
Percona MySQL: Restore incremental backup to a new server
I know it is possible to set up a new database instance on a new server, using a full backup that has been prepared. This is useful for several things, not least if your server has failed completely; ...
0
votes
1answer
35 views
MySQL database point-in-time recovery with mysqlpump, possible?
We have some medium size MySQL databases (500 GB) on Oracle MySQL community edition, version 5.7.30.
How can we perform point-in-time recovery with mysqlpump?
It doesn't seem to have any option to ...
0
votes
1answer
56 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 ...
1
vote
0answers
19 views
Azure SQL custom backup role
We are currently running an Elastic Pool within azure to host all our databases.
We need to back up these to on-premise as well in case of an emergency, and for it we are trying to use sqlpackage.
Now ...
0
votes
0answers
36 views
Changed RMAN backup location, but still seeing the FULL DB backup going to the old location?
I just recently changed the db_recovery_file_dest value to our new directory location. I can see the archive logs going to the new location and the backupsets.
However, our FULL DB backup is still ...
0
votes
2answers
80 views
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding [closed]
I am developing an application to schedule periodic backups, that make full, differential and log backups.
Log backup is each 15 minutes, differential each 6 hours, and full backup each 24 hours.
At ...
1
vote
2answers
23 views
Error when backing up from SQL Server 2014 to Azure blob storage
I'm trying to back up a SQL Server 2014 database to Azure blob storage however I'm getting the following error when trying to do so:
A nonrecoverable I/O error occurred on file
"https://...
0
votes
0answers
46 views
RMAN archive logs are no longer automatically being generated?
To preface... I have mentioned this before in a previous question, but I'll add it again: Our Senior Oracle DBA has just recently passed away, and I've been taking over. My level of experience is just ...
0
votes
0answers
20 views
pg_dump fills up memory but does not write to disk
What could cause pg_dump to fill up memory and not write to disk? Strace just hangs at a certain point with no errors and database log does not show any errors. Once memory is filled up and swap is ...
0
votes
2answers
36 views
Precautions before relocating the RMAN backups?
To preface... I have mentioned this before in a previous question, but I'll add it again: Our Senior Oracle DBA has just recently passed away, and I've been taking over. My level of experience is just ...
2
votes
1answer
43 views
Backup TO URL S3
Can I do a SQL backup to AWS S3 URL from an EC2 machine
I know that Azure side is possible but I do not know if it is possible AWS side
thank you for your advice
10
votes
3answers
1k views
DB backups have suddenly gotten smaller
About 8 GB has been trimmed off of the size of our main database. This is reflected in backups and when we look at free vs available space.
Everything seems to be working and we can't find any sign ...
0
votes
0answers
31 views
How to restore a standalone server from a pg_basebackup using the fetch option
I am attempting to make a backup & restore of a production Postgres server (9.6 Windows) for development testing. This server is standalone and does not need to do streaming replication.
I have ...
0
votes
2answers
17 views
Join the SAME tables from DIFFERENT databases
I have an unusual situation where I have a bunch of backups of a mysql database and I am interested in selecting the distinct members of a given table from these backups (since some records might have ...
0
votes
3answers
48 views
RMAN configuration suggestions to help save our storage space?
To preface...
Our Senior Oracle DBA has just recently passed away, and I've been taking over. My level of experience is just a junior level. So there is a lot I still don't understand. So I appreciate ...
0
votes
1answer
22 views
What is difference between START WAL LOCATION, STOP WAL LOCATION, and CHECKPOINT indicated in the backup history file?
I am a bit confused about these locations. Could someone give a short definition for these locations.
1
vote
1answer
49 views
Set crontab backup job for Mariadb Databases from 1 remote server to another [closed]
I'm connecting to a Ubuntu Server remotely using SSH, where are x number of MariaDB databases.
Now I want to set a crontab job to automatically create backup for all of them to another server where ...
1
vote
1answer
44 views
mysqlbinlog - Binlog has bad magic number error when reading dumped file
I am learning MySQL and performing a test point in time restore using MySQL Server 8.0 on Windows 10. I am having an issue re-playing the binary log as follows.
First, set up the test database
mysql -...
0
votes
0answers
21 views
The user privileges I have assigned don't work when someone imports my .sql database file on mySQL
I'm new to SQLs and mySQL, I and my colleagues who are also new to SQLs are working on a database project and I have successfully queried its structures and inserted data into them.
I then created ...
0
votes
1answer
15 views
pg_dump dumps data from dblinks?
I'm working with a postgres database recovered from a dump, and there are some empty tables and foreign keys with null values. I'm suspecting the dump could be incomplete, because original database ...
1
vote
1answer
34 views
Oracle Linux 6.10 - Changing the Oracle user's ID & GID
OS: Oracle Linux 6.10
DB vers: 12cR1
I will backup and restore from NFS shared disk for a preprod server. However, the ID and GID of the oracle user on the production server (shared disk on ...
0
votes
1answer
37 views
RESOURCE_SEMAPHORE wait during Full and transaction log backup done by Ola Hallengren's solution
We have an MSSQL instance 2017 on version 14.0.3370 and there are issues with RESOURCE_SEMAPHORE waits when full or transaction backup job runs. DBs hosts over 9000 small dbs with used space up to ...
0
votes
0answers
27 views
Failover an Availability Group during a backup
This is a scenario I hope won't happen, but if I was to perform a manual failover on an availability group halfway through a database backup will this cause the backup to fail or would it continue?
I'...
0
votes
0answers
13 views
SQL Backup Operation has detected an unexpected file in a FILESTREAM container, what should I do?
BACKUP DATABASE [DB] TO DISK = N C:\Program File... failed with the following error:
The backup operation has detected an unexpected file in a FILESTREAM
container. The backup operation will ...
0
votes
1answer
20 views
Is it possible to exclude a database from WAL and basebackup?
I'm planning to add a GIS database to an existing PostgreSQL 12 cluster with multiple databases, streaming (hot standby) replication and WAL archiving.
Once created the new database will never be ...
1
vote
1answer
47 views
Why do VSS Snapshots cause Availability Groups to fail over?
Why do VSS snapshots cause Availability Groups to fail over?
Back in 2018, Ken Kellman and Erik Darling wrote that by freezing I/O on databases, VSS snapshots can cause Availability Groups to fail ...
0
votes
0answers
44 views
I can't start an incremental database backup
When I'm trying to parse the following instruction in RMAN:
backup incremental level 0 database plus archivelog delete input;
It creates the backup properly but when the backup starts, I'm getting ...
0
votes
1answer
28 views
pg_dump --exclude-table not working on one specific table
Wanting to exclude a few very large table in a pg_dump, I use the -T option multiple times, like this:
pg_dump --clean clientportal -T article_plain -T callstats -T cdrviewer_cdr -T calls -T ...
1
vote
2answers
38 views
How to check the last time a table has been modified?
I regularly backup tables individually via mysqldump. To avoid unnecessary backup, I would like to check if a table has been modified since the last backup. By "modified", I mean any change (...
3
votes
1answer
246 views
Hourly Transaction Log files size not consistent - is this Differential backup file?
I am new to DBA task here.
I am trying to restore database with transactional logs (in SQB file format) that our company get 24 times each hour daily thru FTP site, and then I have to convert them to ...
1
vote
3answers
32 views
Am I supposed to let PG know in advance before I back up its datadir?
I run PostgreSQL on Windows. Its data dir is located in "My documents". I often back up that entire dir tree (among others) with ROBOCOPY, which "robustly" copies the dir tree to ...
1
vote
1answer
71 views
Fixing a Mistake in SQL
While troubleshooting an issue in my company I updated all the files in the table instead of the specific file that needed to be tested using.
create table _file_*date*_BAK as select * from _file;
...
0
votes
0answers
44 views
MySQL Views breaking mysqldump command
While trying to backup all data from a mysql server with mysqldump I got this error
root@server$ mysqldump -uroot -p --master-data=1 --single-transaction --flush-privileges --routines --triggers --...
0
votes
1answer
42 views
Recovery_model for backupset table null sqlserver
Going through https://www.sqlshack.com/understanding-database-recovery-models/
I see that there are three types of recovery models:
SIMPLE
FULL
BULK_Logged
But for the table msdb.dbo.backupset I can ...
0
votes
0answers
13 views
Oracle 11gR2 => Oracle Data Pump (expdp, impdp) => can backup be safely taken during runtime
until now I create a daily Logical backup backup of my Oracle 11gR2 Database at midnight while the database is running but the client application is in an idle state so that no queries are executed on ...
1
vote
1answer
61 views
*.bak file on another server file share
On a physical Dell server, I am trying to setup a backup job to *.bak file on to failover server.
In the video, DBA Fundamentals - backup 3 - setting up maintenance plans @6:24 backing up to a local ...
0
votes
0answers
41 views
Ola Hallengren Maint Solution - USER_DATABASES vs @AvailabilityGroup = AG1
I have two SQL 2016 Instances that are configured to use Always On AGs (1 AG group with around 25dbs in it running between the two instances) There are also a number (5-10) of Read Only databases on ...
