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
3
votes
1answer
223 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
1answer
68 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
24 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
37 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
11 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
55 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
31 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 ...
0
votes
1answer
14 views

Does mongo *really* need a dedicated volume, if I need to back it up?

TLDR; What's the easiest way to automate a mongodb backup of a 20-gig DB? We run mongo on the same KVM (VPS) as the web app; the server runs Debian. We/I don't need/want to backup the entire fs on a ...
2
votes
2answers
48 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
37 views

How Restore backup as overwrite on a database in use in SQL Server? [closed]

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
42 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
35 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
21 views

What's the easiest way to automate Mongodb backups, for offline storage? [duplicate]

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 ...
2
votes
1answer
15 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
40 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
7 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
375 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
85 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
30 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
11 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
53 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
17 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
49 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
16 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
45 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
30 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
96 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
41 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
59 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
96 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
107 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
15 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
95 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
416 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
10 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
39 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
37 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
43 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
189 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
99 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
37 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.....

1
2 3 4 5
49