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
0
votes
1answer
21 views

Proper way of restoring base backups

We have daily backups of a postgres db and it is in the form of a tarred (gz) base backup. I need to restore this into another db of the same version. However, I am confused with the article that I am ...
1
vote
1answer
34 views

MYSQL Huge Data migration (5TB) from old server to new server

We have an old MYSQL server contains huge data ~5TB and wanted to migrate to the new server in order to minimize the costs and get rid of very old hardware. My one and only idea in my mind is using ...
0
votes
0answers
32 views

how to migrate a mongodb over a couple of versions safely & efficient? [closed]

what is the best method to migrate a database (or at least 1 of 6 collections) from mongodb 2.4 to 4.4 with "reasonable effort"? i know there is mongodump/mongorestore, which is considered ...
0
votes
0answers
16 views

Oracle Filter Full Transportable Backup for Schema

I need to use DBMS_DATAPUMP to make a full and transportable backup from my oracle DB for all objects related to a specific schema. I was looking for something like INCLUDE=SCHEMA:"LIKE 'SCHEMA_1%...
0
votes
0answers
14 views

How to do incremental backup with limited privilege in mysql?

Env:MySql Community v5.7 @AWS RDS User Privs: Select_Priv, Create_View, Show_View, Show_Db, Execute, Create_tmp_table binary_log: ON Currently I can do full backup using mysqldump --single-...
3
votes
1answer
44 views

Incremental backups: MySQL Enterprise Backup vs Percona XtraBackup?

We're evaluating two tools incremental backup: MySQL Enterprise Backup and Percona XtraBackup. The only comparison I found is by Percona which has obvious cause for bias From this comparison, Percona ...
0
votes
1answer
17 views

Logical Backup strategy in large Oracle Databases

in Oracle databases, I would like to know if it is advisable to make logical backups with exp or expdp in large databases with large volumes of data, greater than terabyte, I have seen several systems ...
0
votes
0answers
46 views

SQL Server Differential Backup Size

The setup is SQL Server 2008 R2: Full Backup - Weekly ~1.1TB Differential - Every 4 hours ~66GB Transactional - Every hour What I want to know is why is the very first differential backup about 60GB,...
0
votes
0answers
27 views

EMC Legato NSR_DATA_VOLUME_POOL in Rman script

How to put the NSR_DATA_VOLUME_POOL parameter in rman in case this parameter has spaces, I mean that I need to put NSR_DATA_VOLUME_POOL = Pool Oracle but it throws an error however with PoolOra it ...
0
votes
2answers
50 views

SQL Server native log backup running every 5 minutes

What will happen if SQL Server native log backup is running ever 5 minutes and due to high active transaction the backup was not able to complete in 5 minutes ? Will the next log backup be initiated ...
0
votes
0answers
26 views

Ola Backup scripts, How do you specify a different filename for the mirrored set?

I'm using the backup script below as a test. I want to use a different file name for the mirror. The format should be @FileName = '{ServerName}-DEFAULT-{DatabaseName}-{BackupType}-MIRROR_{FileNumber}....
1
vote
1answer
31 views

SQL Server Application paths to include in server backup?

I have an instance of SQL Server 2017 Standard installed on a physical server running Windows Server 2019. I'm currently working with our server administrator to configure the server backup, which he ...
0
votes
0answers
12 views

Transaction backup plan and size

I am using SQL Server 2016. I have setup SQL Agent for Full backup (Weekly) and Transaction Log backup (Daily). Backup transaction log into a single file using: BACKUP LOG [XXX] TO DISK = N'E:\SQLDB\...
0
votes
1answer
40 views

T-SQL Query to retrieve the last full backup (Including split and copy only), Size and Location

I am using the following query answered by Marcello Miorelli. This query serves the purpose for normal backups but fails to determine the actual backup size of all the split backups and copy only ...
0
votes
1answer
24 views

Storage accounts not showing up when creating Azure Storage Credential

I'm trying to setup a Back Up Database Task in a Maintenance Plan on SQL Server 2017 (Web Edition) using SSMS 18.6 and when I get to the step to create an Azure credential I select my management ...
0
votes
1answer
12 views

PostgreSQL Backup Information

How do you get the Backup History for a PostgreSQL database from within the database? for example: in SQL Server you look into msdb.dbo.backupset in Oracle you check v$rman_output is there a similar ...
0
votes
1answer
31 views

Ola Hallengren's backups scripts, cleanup only mode

Is it possible to run Ola Hallengren's backup scripts in cleanup only mode? I have a couple of servers where the cleanup time was set too long, and I now have to clean up hundreds of databases worth ...
1
vote
0answers
62 views

SQL server backup fail “A system assertion check has failed”

I just installed SQL Server 2017 EVAL in a Windows Server 2012 R2 VM. Most default options. Default installation folder. SYSTEM databases in default folder. User databases in the D:\ drive. Created ...
0
votes
1answer
102 views

ERROR 1064 (42000) You have an error in your SQL syntax during import

New to MySql. I have an export file from server version 5.6.34. I am importing this on a server with the same version. I get an error like: ERROR 1064 (42000) at line 4343: You have an error in your ...
0
votes
0answers
12 views

Quick Backup/Restore of Aurora Database

We're getting slow performance (hours for a couple GB database) when trying to do a backup/restore of an aurora database. We essentially want to clone the database so we've got two side-by-side copies ...
0
votes
1answer
29 views

SQL Backup routine regarding DB Logs

I recently had an incident that got me rethinking my backup plan: One of our MSSQL driven aplications stalled because the log fle had grown too big on the filesystem (it was 50 GBs IIRC). It turned ...
0
votes
1answer
31 views

RMAN Backups - Can more than one media management software solution be used?

Does anyone know if it's possible for two different backup utilities to be used to backup the same Oracle database? Both utilities would use RMAN. So, for example, take an Oracle 11g standby DB with a ...
1
vote
1answer
35 views

mariabackup crashing, help

Hi I'm using mariabackup on one of my MariaDB 10.5.4 nodes from my Galera Cluster and whenever I run it i get this from my output logs: [00] 2020-08-05 11:26:40 Connecting to MySQL server host: ...
0
votes
0answers
16 views

Do Sql Server backups contain transacitons during backup? [duplicate]

I have a database that automatically takes full backup weekly, differential backup daily, and transaction log backup every 5 minutes. The full backup takes about half an hour so its runtime often ...
0
votes
2answers
24 views

Backup Restore, CPU usage and Extended Events

I'm working on measuring the performance impact of Backups on CPU. I would like to capture all the backup operations and CPU usage. I'm running a weekly full backup, daily diff, and 15 min log backup. ...
0
votes
1answer
26 views

PostgreSQL WAL Archival Best Practices?

The postgresql documentation gives an example archive_command of archive_command = 'test ! -f /mnt/server/archivedir/%f && cp %p /mnt/server/archivedir/%f' # Unix but adds the disclaimer ...
0
votes
1answer
27 views

MariaDB Galera + Remote Backup

I'm using CentOS 8 and I have a MariaDB 10.5.4 Galera set up with three nodes. Now, I want it to create a backup to my central server from time to time. I'm thinking of mysqldump but restoration would ...
0
votes
1answer
9 views

Encrypt backup in 2008 R2

Is it possible to encrypt 2008 R2 backups like TDE for instance? What I've read is encrypting the whole database and that way the backups will be encrypted. But can you have TDE encrypted backups ...
1
vote
1answer
25 views

Why did full backup file size grow after data movement for Availability Group replica was suspended?

Found an error log informing that data movement to a secondary availability replica was suspended. I'm not sure whether the cause of the suspension is relevant to answering my question, but the cause ...
1
vote
2answers
38 views

SQL Server 2017 Backup strategy

RTO is 8 hours RPO is 24 hours Retention Period: 5 days Based on above values I have plan to configure below backup stratgey for Production. Please suggest if there is any changes required in below ...
0
votes
2answers
38 views

Fast Backup and Restore of Growing Databases

I work in Tech Support and the some of the products I support are heavily database dependent (PostgreSQL and MySQL, but most of the big ones are MySQL). Before we do an upgrade, we always take a full ...
0
votes
0answers
35 views

Is safe to make backups of vm that contain Oracle databases using veeam backup or another similar tool?

I would like to know if it is advisable or safe to make backups of vm that contain Oracle databases using veeam backup or another similar tool, my doubt is caused because I have several vm with Oracle ...
0
votes
0answers
8 views

MongoDB : Log failing DB backups

is it possible with Java Script to capture the errors of MongoDB backup failer and send this message to Windows event logs Best regards
0
votes
1answer
16 views

Event and mysqldump

I am trying to create an event for automatic backup using this code DELIMITER $$ CREATE EVENT IF NOT EXISTS e_AutomaticBackUp1Day ON SCHEDULE AT 1 Day STARTS '2020-07-06 10:13:00' DO BEGIN mysqldump -...
1
vote
2answers
31 views

backup using gzip slow

We are currently backing up some schemas in Postgres using this command: pg_dump -h localhost -n test_schema mydb | gzip > /data1/backup/test_chema.dmp.gz And we are getting a rate of 50 Megabytes ...
0
votes
1answer
62 views

TRY/CATCH only reports the last (and most useless) error

(This is SQL Server 2016 SP2-CU12.) When running this command interactively, I see the quite useful Msg 3035, Level 16, State 1. BACKUP DATABASE @DB TO DISK = @targetfile WITH DIFFERENTIAL, RETAINDAYS ...
0
votes
1answer
31 views

SQL Server and ASP.NET - Backup Log database with Application Pool in Always Running

I have a database on SQL Server Express used for 3 Asp.net applications. The Recovery Model is Full. Every day I execute a backup database and log with this code BACKUP DATABASE @databaseName TO DISK =...
-1
votes
1answer
36 views

Ola Hallengren Database Backup keeps failing (for both SYSTEM and USER databases) [closed]

Both USER and SYSTEM backup database jobs have been running fine until some weeks back when I checked my alerts (bearing in mind that this is on DEV where I do my own testing etc). I am just confused ...
0
votes
1answer
42 views

Downgrade MySQL 8.0.20 to 8.0.19 on Ubuntu for using XtraBackup

With MySQL 8.0.20 currently installed on Ubuntu, I am unable to use Percona XtraBackup 2.3.7 due to breaking changes introduced in MySQL 8.0.20. How can we downgrade MySQL 8.0.20 to 8.0.19 on Ubuntu, ...
-1
votes
1answer
21 views

Migrate data from an older version of mongodb

How can I backup and restore a large mongodb database (500GB) from a server running an older version (v2.6) than the target one (v3.6)?. The downtime is critical. We've tried by making a straight copy ...
1
vote
1answer
43 views

SQL TRN logs back [closed]

i am hoping for some help or guidance , i currently have a database that is in excess close to 1 terabyte, we do a full DB backups once every evening and we run trn log backups every 15mins. this is ...
0
votes
0answers
14 views

Time taken for 3TB mysql database with Xtrabackup Command

I have 3TB mysql database 5.7 with InnoDB tables. I want to migrate it to another server. I have 64GB RAM and 6 CPU. How much time will take to migrate and restore with Xtrabackup tools. How much ...
0
votes
1answer
15 views

manage backups azure sql option

This may be a silly question but I recently created an azure sql database and I need to check the backup policy but I cannot find the option manage backups that the documentation shows as you can see ...
0
votes
1answer
48 views

Backup database on linked server

I am trying to backup a db on ServerA via ServerB. I have: DECLARE @SQL NVARCHAR(100) SET @SQL = 'BACKUP DATABASE DBname to disk=''\\ServerB\E$\folder\DBname.bak''' EXECUTE ServerA.master.dbo....
0
votes
0answers
28 views

Xtrabackup Incremental Backups Failing After Enabling Change Page Tracking on MySQL 5.7

A week back I'd enabled the parameter innodb_track_changed_pages=ON on one of our Percona MySQL 5.7.10 database instances that we use as a Data Warehouse. The OS is Ubuntu 16.04. So far the ...
1
vote
2answers
60 views

Why a backup created on SQL Server 2016 is significantly larger than one created on SQL Server 2012?

I've backed up a database on SQL Server 2012 that resulted in a file of 33MB in size. Then, I restored that backup on SQL Server 2016 and created another backup, but this time on SQL Server 2016. The ...
0
votes
1answer
26 views

Automated backups sql server IaaS

We have installed sql server on a virtual machine and we have registered the machine so that way SQL Server IaaS Agent Extension (SQLIaaSAgent) gets enable and runs on Azure virtual machines to ...
0
votes
1answer
28 views

MongoDB dump oplog based on timestamp

I'm trying to dump oplog.rs from local database, based on timestamp. Query directly from mongo shell works but not from mongodump Query from mongo shell RS1:PRIMARY> db.oplog.rs.find({"ts" : {$gt ...
1
vote
1answer
95 views

Oracle - MUST_RENAME_THIS_LOGFILE in logfile name

I'm creating a data guard using hot backup from the primary server. In my restore I've used the following commands to restore: run{ set newname for database to '+DADOS'; restore database; switch ...
0
votes
1answer
23 views

RMAN Creating automatic instance fails

I am trying to transport a tablespace in RMAN. The command I'm running is transport tablespace usr_table auxiliary destination '/oracle/rman/auxFiles' tablespace destination '/oracle/rman'; The ...

1
2 3 4 5
48