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,340
questions
0
votes
0answers
4 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
0answers
27 views
Can't import MySQL database from mysqldump
I am interested in backing up a Wordpress (multisite) website.
Because this Wordpress lives on a shared hosting environment, my options (for daily automated backups not managed by most host) are a ...
0
votes
1answer
15 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
24 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
56 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
30 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
33 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
24 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
13 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
42 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
13 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
10 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
47 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
19 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
57 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
15 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
15 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
54 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
20 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 ...
0
votes
0answers
12 views
Check end time (last transaction time) of PostgreSQL WAL archive (backed up with pgBackRest)
I have pgBackRest 2.27 receiving WAL archives from PostgreSQL 12.3. Is there a way to find out the timestamp of the latest transaction included in the WAL archives, i.e. what time I could restore my ...
0
votes
2answers
37 views
Ola Hallengren MaintenanceSolution - Differential - the value for @ModificationLevel is not supported
I just installed this great tool, mostly it's working fine, just that if I include for a differential backup the parameter @ModificationLevel = 50 (or anything else) the action fails:
Msg 50000, ...
1
vote
1answer
13 views
pg_basebackup not running even after trying all the methods
I configured pg_basebackup on another server, where it is running perfectly, but in one of the servers pg_basebackup is not running at all. Below are the error details. I tried multiple ways to ...
1
vote
1answer
15 views
mysqldump locks all tables even when specifically grabbing a few?
I'm using a mysqldump command pulling data from 3 tables of 7. Are the other 4 locked as well?
0
votes
1answer
15 views
RMAN Disk Backups
I have to run RMAN full backups of my 11g Oracle DB to disk. As part of that process the backups will all be changed to have a backup tag of 'UNAVAILABLE'. This is because the filesystem location of ...
4
votes
0answers
93 views
Can backups done through external clients cause memory pressure on SQL Server?
Developer in DBA role here, we recently migrated from 2008 to 2019 and are having memory related problems on the new server. Every 3 to 6 days the OS will start paging and CPU usage would spike to 99%,...
0
votes
1answer
46 views
How to backup a large (100gb+) microsoft sql database for occasional “offline” use?
I have a Microsoft SQL database that's over 100gb currently in service. It's due to be decommissioned but I want to keep the data for occasional use without paying for a Microsoft SQL licence (...
0
votes
0answers
11 views
Upgrade mariadb to 10.3
We need to upgrade mariadb to latest version on critical prod servers.
We are planning to take backup and restore on the new server.
What type of backup is recommended for it? physical or logical?
0
votes
0answers
15 views
Backup and upgrade MongoDB databases
I have a web application using MongoDB (Version 2.6.12), hosted in a (Ubuntu 16.04) server of DigitalOcean.
I like to use Robo 3T to connect to the remote database and do simple queries.
Sometimes I ...
0
votes
0answers
23 views
PostgreSQL Streaming Replication with Switchover
I'm trying to provide streaming replication between a master (T1) and slave (T2) and swapping their roles when necessary (i.e letting T1 be a slave to T2). So far I am able to get this working if I'm ...
0
votes
0answers
35 views
MSDB - Backup information is not updating
I'am having a problem in my database
My backup job is working correctly, but the tables of msdb is not updating the information.
Here is my case, if you see, My last transaction log backup was in ...
1
vote
1answer
42 views
SQL Server: calculating memory requirements for Full db backups
In 2018, we inherited a production SQL Server 2012 FCI running on Windows 2012 with 32 GB RAM. SQL Server max server memory was set at 23.6 GB, and things were running fine.
However, in 2019, we ...
1
vote
1answer
27 views
Why does SQL Server Backupset table goes back a few months, but Agent Logs go back further?
I ran this script looking at the history of my backups for the past month.
select * from msdb.dbo.backupset order by backup_start_date
No problem, but if I want to go back to Jan 2020, there are no ...
8
votes
1answer
328 views
Is it possible to restore a SQL Server Linux Backup on SQL Server Windows
I am running SQL Server in docker on a mac. I have taken a SQL Server backup from windows and restored it in the mac SQL Server docker instance. Now I want to take a backup from the SQL Server docker ...
1
vote
1answer
29 views
SQL Server: How to get total number of backups done in a month?
I need to gather monthly statistics for my boss, on how many FULL backups were done in a month and which number Succeeded and which failed if any.
Is there a simple query that could give me this, ...
0
votes
1answer
23 views
Innobackupex (Xtrabackup) 2.4.8 incremental backups take the same time as full backup
We have our operational as well as decision making databases both running on Percona MySQL 5.7.10. The OS is Ubuntu 16.04. On these various database instances we have been using Percona Innobackupex (...
0
votes
1answer
17 views
Postgres Server staying in read only mode after a barman recover command is executed
All,
I am trying to perform a PITR restore using barman using recover command. The problem is that the server remains in the read-only state once the barman recover is done. Is there a way by which ...
0
votes
0answers
28 views
How to take backup of PostgreSQL 9.4 database to remote server using pg_basebackup?
We want to take the logical and base backup on different server machine in the network. Currently both backups are running on same server machine causing space issues. We have the scripts in place ...
0
votes
0answers
13 views
How to take single database backup using mysqlbackup command in Mysql 8.0.18 version DB
I have a mysql instance(8.0.18-commercial MySQL enterprise server) with 8 databases in it and out of those I only need to take the backup of DB named 'Test1'.
Please note that its 300 GB sized DB ...
1
vote
2answers
127 views
Can I move SQL Server backup files on a running database?
Our backup drive is filling up with TRN and BAK files. I have administrative privileges on the server, but I don't have a login to the database.
Can I move the oldest files off to somewhere else ...
1
vote
0answers
23 views
Splitting file groups of large SQL Server database using FileStream
Background:
I have a SQL Server database which is storing documents in the file stream. These documents are usually accessed via Web API by Mobile Apps and Modern JS Apps.
The size of the database ...
2
votes
1answer
37 views
ola-hallengren backup solution with encryption is not encrypting
Installed OH's scripts and they run great. sqlserver 2017 standard edition in a testing/dev environment. testing before rolling out to production.
I did a test of a restoration of an encrypted, or so ...
1
vote
1answer
32 views
SQL Fast database restore with Azure Virtual Machine instant recovery snapshot and SQL in Azure VM?
I have a large database. If I want to restore to a point in time using a full back up, it takes around 4 hours + time taken for transaction log restores.
I also have VM image instant restore ...
1
vote
2answers
49 views
Is it possible to restore a database with database backups starting on top of a restored server point in time snapshot that is out of date?
If I regularly backup my whole server where a SQL instance and database lives, and restore it to a different machine, can I use the database backups that have occurred (on the original server) after ...
0
votes
0answers
20 views
SQL Server Backup on OCI Object Storage
Is there any way I can take SQL Server database backup directly on OCI object storage?
Couldnt find any method to map the object storage to windows.
0
votes
1answer
32 views
How to find the last data backup on secondary replica?
To determine when database has been backed up the last time usually is enough to look into backup tables in msdb database.
However, it doesn't work well with Availability Groups - after the failover ...
0
votes
1answer
21 views
Is it possible to restore single postgreSql database to PITR?
I have PostgreSQL instance with n databases on it.
Is it possible to restore just a single database using PITR ?
# restore
tar xvfz /var/lib/postgresql/db_file_backup.tar.gz -C /var/lib/postgresql/10/...
0
votes
1answer
18 views
RMAN-03009: failure of backup command due to ORA-27038 and OSD-04010:
I'm running below script in a windows server, this is same script I run across all servers
run {
configure retention policy to recovery window of 7 days;
backup current controlfile format 'F:\...
-2
votes
1answer
38 views
Using Ola Hallengren's backup solution - Can't exclude databases [closed]
I am using the newest version of Ola's scripts. When backing-up databases, I'm experiencing an issue with excluding certain databases.
The website states, if you want to backup all User database ...
1
vote
0answers
21 views
PgAdmin: backup and restore schemas using the GUI
I know how to backup and restore one or more schema(s) from a PostgreSQL database using psql:
Go to the folder that contains the executables of PostgreSQL:
cd C:\Program Files\PostgreSQL\11\bin
...
0
votes
2answers
34 views
Backup Files growing quickly on SQL Server 2016 Always On Cluster
I have a two-node SQL Server 2016 Always On Cluster. I also have a job that updates about 200 records in one table every 3 minutes. Even when there are no updates, it does change a TimestampDt field ...
