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,443
questions
1
vote
1answer
19 views
Need help merging multiple full SQL Server Backups into single database
Got a really strange issue with SQL Server database backup files I am getting backup files from the state of California for petroleum production. Each year a database with the same name is created ...
1
vote
1answer
23 views
How Restore backup as overwrite on a database in use in SQL Server?
I Want to restore a backup with overwriting on a database in use
for this problem I want to create a query base on these steps :
1- Remove All Connections [MyDB]
2- Create a backup from [MyDB]
3- ...
1
vote
1answer
32 views
Can I restore my SQL Server database to a point before the last full backup with my current backup strategy?
If I have this backup strategy(weekly full backup and 1 hour log backup), can I restore the database to the green highlighted period of time? Btw, does log backup 2 includes all log records that have ...
0
votes
0answers
20 views
Very slow loading of MySQL DB-backup
I'm working on a transition of a web-site, which uses MySQL database as a backend.
The transition involves copying the production database -- into another on the same server. We do this by taking a ...
0
votes
0answers
12 views
What's the easiest way to automate Mongodb backups, for offline storage?
So, I'm almost finished building my first major production web app, and am wondering how to manage backups.
Weekly cold snapshot backups via my vps online admin seem ideal - but weekly downtime sounds ...
0
votes
1answer
31 views
Postgresql 13 pg_dump utility - pass a password through the Lazarus app in Windows
I did a small app that trying to pass a password to pg_dump console utility. It's working, but with password provided. Please see full code here and the problem there: no way to pass a password to ...
2
votes
1answer
7 views
Impact on Recovery Time Using A Single Perpetual Base Backup and WAL Archives
What would be the impact on recovery time when restoring a Postgres database from a backup where one base backup was taken at the start of the backup strategy and then only applying WAL archives from ...
0
votes
1answer
38 views
Take a “slice” of a SQL Server database: for all tables, get only the rows that join (directly or indirectly) to a specific row
For audit purposes, I'm trying to obtain a copy/export of a DB but including only the rows from each table that have relevance to a small collection of rows in some table. So every row of every table ...
0
votes
1answer
6 views
Mongodb migration and appending data to existing database
I have two databases in two different machines containing data in same schema. Both have relational mappings in form of ObjectIDs as it is done in NoSQL database. The task at hand is to pick one ...
1
vote
1answer
153 views
Clone a database from SQL Server 2019 to 2017 [duplicate]
I try to clone a database from an Sql Server on my local machine v15 (2019) to a server machine v14(2017). I did a .bak file and when I tried to import on the server side it says:
System.Data....
0
votes
0answers
44 views
RMAN-08120: warning: archived log not deleted, not yet applied by standby
BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
In Data Guard environment this command tries to
1.backup archivelog before starting backup
2.delete archivelog before starting backup
3.backup database
4....
0
votes
0answers
29 views
Backup Optimization
The production database is configured to backup with parallelism 16. I noticed that first 16 channels is allocated and each channel backups 61 datafiles, after that, next 16 channels backup 20 ...
0
votes
1answer
17 views
Optimal way to store leaderboards by month
I have a leaderboard table of users for current month. I need to save all leaderboards by months and display current/old leaderboard on site. Should i create a new table when every month stars? Is ...
1
vote
0answers
9 views
Informix onunload/onload between different arch
I have some necro-project using Informix Dynamic Server Version 7.31.UD1.
I need to backup-restore database between servers. The thing is, the onload just silently exits and doesn't create a database, ...
1
vote
1answer
22 views
MySQL Like for Like - 100% accurate Backup/ Restore
I've struggled to find the answer to get a perfect backup and restore for MySQL.
I need to do performance test on a database so I need to make sure that the page files, indexes, fragmentation - the ...
1
vote
0answers
32 views
pg_basebackup from docker postgres container and restoring to physical postgres [closed]
I am using pg_basebackup to backup data that is running in docker based postgres (alpine) to a physical postgresql cluster. Both postgres versions are 12.
docker exec -t postgresql pg_basebackup -U ...
1
vote
1answer
47 views
SQL Server: Should the same log records be backed up multiple times?
I came to SQL Server database administration from an Oracle DBA background. So maybe naturally, I always try to understand the differences between the two DBMSs as well as the similarities. One ...
0
votes
0answers
16 views
Get real error from backup job failure instead of backup terminating abnormaly
I've had log backup jobs fail for a few different reasons lately. When I go to the job it tells me backup terminated abnormally. However, when I run the backup script in SSMS it will tell me the ...
1
vote
2answers
48 views
SQL Server - Restore only primary Filegroup but bring the database online
I'm trying to find out if it's possible to bring a SQL Server 2016 Enterprise database online by restoring only the primary Filegroup. My scenario is, we have a fairly large OLTP database, of around ...
0
votes
2answers
27 views
Simple Backup Plan Question
I'm using Microsoft SQL Server 2016 Standard (64-bit). I have the following backup plan (9 steps long) ...
What I want is just one full (simple) backup everyday. Do I need to do step 8 (Backup ...
0
votes
1answer
13 views
Reduce backup creation time
I will be performing a postgres upgrade from 11.5 to 12.5 that will affect production environment. The first step assumes, that the most recent backup of database was taken, before upgrading - we ...
0
votes
1answer
42 views
backup and restore app for databases [closed]
I'm looking for an open source app to backup sql server / mariadb / postgres.
Do you know which app can do that ?
I want to schedule backups with the app.
yes it's possible with only one app . I used ...
0
votes
1answer
25 views
Repair Database using .FRM .IBD .OPT Files ( Hard copy mysql folder )
I had a crash on my server.
The only thing I could do was hard copy the mysql folder
Now I am trying to access my database again through the PHPMyAdmin interface.
Some databases (mostly WordPress) run ...
1
vote
1answer
95 views
Restore of copy_only backup of encrypted database made without FORMAT but with INIT fails
I have a task of making periodical copy of the database, twice a day, and I should not break any backup chain niether accumulate these temporary backups. So I tried to take a copy_only backup with ...
0
votes
1answer
38 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 ...
2
votes
1answer
49 views
On docker volume restore: could not access file “$libdir/timescaledb-1.6.0”: No such file or directory
I am trying to restore TimescaleDB data from one ubuntu machine to another ubuntu machine. On the both machines we have deployed TimescaleDB through docker and using the same tag.
Docker image used: ...
0
votes
1answer
17 views
What is the name of the process for creating a new DB from an exported snapshot? [closed]
I need to set up an automated process that:
creates a snapshot of an AWS RDS (MySQL) DB
uses that snapshot to create a new RDS instance that will be used as an "analytics playground"
I'm ...
1
vote
2answers
85 views
Ola Hallengren scripts: after a job failure, how to skip the databases that worked and backup only the remaining ones?
In our organization we have more than 150 databases in one instance and full backup should run for every day.
Our backup script should be in such a way that if backup job fails while taking 100th ...
0
votes
3answers
89 views
Backup sqlserver 2019 and restore to Sqlserver 2017
I have only 1 table in SqlServer 2019 that I want to backup and restore into SqlServer 2017 in different server.
To SqlServer 2019 I have access to server and with SSMS but to SqlServer2017 I have ...
0
votes
0answers
13 views
CouchDB backup best practice for a 1Tb database
One of my users got 2 servers running couchdb under docker. A replication is in place between those 2 databases.
On my side I backup those servers using rsnapshot but I don't think this is the best ...
0
votes
0answers
15 views
Mysql backup- restore on multiple host in live replication
MySQL database has 1 primary host which is replicating to 2 Read replicas
RR1
RR2
RR1 is master of RR11 RR12 RR13
RR2 is master of RR21 RR22 RR23
I have to make a schema change so I started schema ...
4
votes
1answer
81 views
What is the correct way to make an exact copy of a database with pg_dump?
Basically, I'm trying to make a SQL dump that will make an exact copy of a database: user defined functions, relationships, constraints, tables, data, etc.
Is this doable with pg_dump or does psql ...
0
votes
0answers
10 views
PostgreSQL: How to backup only One Schema from a database and restore it to other schema having same name of database? [duplicate]
I have a database named "A" which has three schemas "B","C" and "D". I want to take backup of schema "C" and restore the data to Schema "B"?...
0
votes
1answer
26 views
Dumping mssql db from one server and restoring on another on Mac/Linux
Using either MacOS or Linux, my objective is to copy a database from one MSSQL database server to another. The source database server is remote, while the target database server (which will be ...
2
votes
2answers
410 views
is it safe to compress backups for databases with TDE enabled?
I've been reading about this for a long time, and it seems it's not safe to compress a backup when the database has TDE enabled.
is anyone experiencing errors during restore with compressed backups ...
0
votes
0answers
9 views
Locks during the physical backup process by Mariabackup
I read the manual, but I do not fathom what you can do and what you should not do during the backup process by Mariabackup. Particularly, as MariaDB Enterprise Backup has additional features including ...
0
votes
0answers
30 views
MySQL faster after restore
I have a table with ~300k records, and query with join other table. A query executed about 2 minutes. But! Yesterday I was backup and restore this database and saw, my query faster 10 times! From >...
1
vote
1answer
35 views
PostgreSQL backup + gzip
We have a need to send PostgreSQL DB backup to CRM developer.
We send them and get feedback that the backup can't be "uzipped", as archive is broken.
The backup script snippet looks like ...
1
vote
1answer
35 views
Incremental encrypted per database backup and Partial restore policy for MySQL 5.7 in replication setup
I will run a replication cluster using MySQL 5.7 and I would like to set up for each database a backup policy that has a full once per day + incremental every N hours with data encrypted (based on the ...
0
votes
2answers
42 views
Using SQL Server native backup and Veritas Backup Exec to backup the database and transaction log on the same database
I have a customer who use the Microsoft SQL Server native backup and Veritas Backup Exec to backup the database and transaction log on the same database.
The native backup runs at 5 AM while the ...
6
votes
1answer
175 views
Do Log Backups depend on Differential Backups?
I have the following backup strategy set up:
My understanding so far, was:
Differential backups do not truncate the transaction log, so, there's no relation between Diff and Log Backups and both ...
0
votes
0answers
77 views
Failed (exit code: 1) when trying to restore DB from a .tar file in pgAdmin4
I'm been trying to restore my database and I'm getting an Exit error code 1. The database I'm trying to restore is SuperMart_DB.tar, but every time I get the same error message.
I have seen previous ...
0
votes
1answer
36 views
SQL Server: Determine backup location from physical_device_name field
I am working on a SQL Server database and ran the following command to figure out where the database is backing up to:
SELECT TOP 1 M.physical_device_name
FROM msdb..backupset S
JOIN msdb.....
2
votes
2answers
58 views
How memory limit for backup process is calculated?
How "memory limit" for backup process is actually calculated?
0
votes
1answer
39 views
mysqlbackup failed with error when --use-tts option is used
I just found an interesting behavior when using the mysqlbackup feature to create a backup of a database and i'm wondering if i missed any steps or maybe a config that i missed or created a typo ...
0
votes
2answers
59 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
0answers
28 views
Does PostgreSQL have some ability to “compare” a backup with the live database automatically and neatly?
I make full backups of my PG databases each day. I store these pg_dumped archives/blobs in a dir on the same computer, as well as on offline disks, up to a year before they are culled.
I'm constantly ...
2
votes
1answer
84 views
To reduce recovery time (and save space): Is it possible to ignore some PostgreSQL 13 tables (or schemas) when backing up using Barman?
We have some large staging/scratch tables in one of our PostgreSQL databases. The data in them can be automatically regenerated from other databases after recovery of the database, and aren't business ...
0
votes
1answer
14 views
sql backup restore converts createdAt to local TZ
I have a remote MySQL DB in the cloud on JAWSDB.
I have createdAt and updatedAt timestamps for records that are in UTC TZ.
I'll backup these DBs using mysqldump -h HOST -u USER -p > backup.sql. I ...
0
votes
0answers
14 views
Error trying to backup MySQL instance with mysqlbackup 8
I am trying to backup a whole MySQL 5.7 instance, using the following command:
mysqlbackup -u root -p --port 3306 --host localhost --backup-image=/data/mysql/backup/hot_bckp/full_8.22/full_mbi --...
