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,522
questions
0
votes
0answers
5 views
Restore PDB with rman
I have a DB running in NOARCHIVELOG mode with some users and their schemas.
I'm creating a backup of my PDB using the following commands in rman (I'm connected to the PDB):
SHUTDOWN IMMEDIATE;
STARTUP ...
-3
votes
0answers
35 views
What do the mediaset options in backup settings mean? [duplicate]
When taking a backup, under media settings there are options to backup to the existing media set and backup to new mediaset. What does this mean?
-1
votes
0answers
13 views
MariaDB: could incremental backup be created on top of the prepared backup?
I use mariabackup tool to backup my MariaDB database.
Is it safe to do:
mariabackup --backup --target-dir=/backup/full/
mariabackup --prepare --target-dir=/backup/full/
then
mariabackup --backup --...
0
votes
0answers
42 views
Restoring from BAK file obfuscates some column names [closed]
We are converting data from a competitor for a new client, so I don't have access to the original server, just the .bak file. Here is a screenshot of some of the columns in SQL server
As you can see ...
1
vote
1answer
37 views
What happens when SQL query is executing prior to snapshot backup and query executed during snapshot backup?
During vss based snapshot backup, databases IO is frozen one by one. And subsequently resumed.
Questions:
When there is a query running, and vss based snapshot backup is executed, will the freeze get ...
0
votes
0answers
6 views
MySQL8: xtrabackup Invalid stream argument: tar
I am using xtrabackup to take full backup and send it to another host as .tar file using the following backup command:
xtrabackup --backup -u root -p --no-lock --compress --stream=tar --datadir=/...
0
votes
0answers
32 views
Is there any alternative to Sage Evolution's way to backup & restore databases
I am currently working on a handful of web apps that work in coherence with our Sage 200 (Evolution) database.
However, one problem that we have noticed at the moment is the ability to backup and ...
0
votes
1answer
26 views
RMAN Duplicate PITR without connection to Target database
I would like to understand which network requirements are needed following the least privilege needed policy in order to perform a DUPLICATE DATABASE UNTIL SCN in this scenario
My environment is Azure,...
0
votes
1answer
31 views
How does sql server handle scenario where transaction is running during tlog backup?
Suppose a long transaction is running, which also means as usual it is writing entries into the log.
Suppose tlog backup runs at this point, then how does sql server handle this scenario?
Does the ...
-1
votes
0answers
29 views
How does sql server maintenance plan based jobs perform the backup (sequential or parallel)?
I have sql server maintenance plan which is doing full, differential and log backups for 30 databases.
Sql jobs are auto created by the maintenance plan.
I want to ask whether sql server does the ...
-3
votes
1answer
41 views
What are possible backup command origination sources?
In the backupset table I can see couple of backups that I am unable to understand where they originated from. That is - who ran them.
I have checked:
Maintenance plans
Sql jobs
Virtualization tool ...
0
votes
1answer
36 views
How to restore a Cold Backup of Oracle Database to new environment
All of a sudden my laptop ran into a problem and the sfc command ruined the whole thing and couldn't boot my Windows 10. Due to this, I formatted the laptop and now I want to restore the Oracle 11g ...
2
votes
3answers
149 views
Large database partitioning and backups of only updated data (partial backups)
I'm setting up a large SQL Server database (2-4tb), but only a small percentage of it will be updated. I'd like to partition by year so that my backups can be small. HOWEVER, some of the old data may ...
-1
votes
0answers
27 views
Is there another way to make database mirroring in SQL Server? [duplicate]
I want a way to create another database in another remote server to save every change that occurs in the database on the main server, moment by moment, the data is saved so that it is always identical,...
0
votes
1answer
49 views
Why I can't take differential backup of primary replica?
I am trying to take a differential backup of my primary database by connecting to the primary replica, but I can't do that. We use SQL Server 2017 EE with latest CU. Database is in full recovery model ...
3
votes
1answer
141 views
Manual log backup makes restore strategy useless upto next full backup only?
Suppose I do full backup at 12am. Then log backups every hour.
Then suppose at 8.30pm I do a manual log backup (thus truncating the log) and delete this file. Thus the subsequent log backup at 9pm ...
3
votes
1answer
159 views
What is the difference between database snapshot and VSS database snapshot backup?
I have database backups configured via SAN disk tool. In the backupset table I can see the VSS writer service is taking full backups of type snapshot.
There are 85 databases on the server.
I know ...
4
votes
2answers
356 views
Will non copy only full backup impact transaction log backups chain?
We have full backups and log backups configured.
During restore we apply full backup and subsequent log backups.
I know that if I take a manual full backup (non copy only mode) then it will break the ...
1
vote
2answers
43 views
What is the advantage of full backup over snapshot backup when it comes to restore by applying tlog?
What is the difference between following restore options:
A. Full backup and applying to it subsequent log backups.
B. Snapshot backup and applying to it subsequent log backups.
Note: this is not ...
2
votes
2answers
110 views
Will snapshot backup (non copy only) break restore chain?
I have full backup running at 6am on Sunday. Differential backup running at 6am everyday. Log backup running every hour.
There is also a Snapshot backup running at 3pm everyday. This is not a copy ...
0
votes
1answer
36 views
RMAN - Archivelog deletion policy ignored
After a full backup on an Oracle 12.1 database with retention policy set to 1 and ARCHIVELOG DELETION POLICY BACKED UP 2 TIMES TO DISK, if a run delete obsolete device type disk, all archivelogs are ...
0
votes
0answers
56 views
SQL Server - BackupDiskFile - Referencing to deleted TR Backup file [duplicate]
We have a backup job which creates transaction log backups every 10 mins for databases. Backup files which older than 2 days are deleted.
In ERRORLOG file - I see the record which I cannot get/...
3
votes
2answers
145 views
Why does a Full Backup restore of my database give me the error "RESTORE can only create a database when restoring either a full backup..."?
I've setup a maintenance plan to take a daily Full backup of all databases on my server. I've also setup a second maintenance plan to take Transaction Log backups every 5 minutes. The Transaction Log ...
0
votes
0answers
18 views
pgbackrest: Is it possible to have repo and hot standby on the same node?
I am trying to use 2 nodes:
Node A as primary node.
Node B as standby + REPO node.
Is it possible to do this?
My configuration looks like this right now:
Primary node - pgbackrest.conf
[global]
...
2
votes
2answers
74 views
mysqldump all database including user/password and grants
I am running 10.5.12-MariaDB and trying to take full backup of all databases including user accounts/ passwords and Grants but somehow i am not able to take backup of grants so am i missing something.
...
0
votes
2answers
17 views
How to organize MongoDB replicaset backup and alerting
I have a running MongoDb replicaset consisting of 2 replicas and 1 master nodes. Recently I noticed that my master gone and automatic failover took action and changed master, however I wasn't aware of ...
0
votes
2answers
48 views
Where can the database backup be configured (other than maintance plan and sql jobs)?
There are no maintainance plans or jobs that run sql backups.
But the sql log shows i/o frozen for database, i/o was resumed on database, database backed up, backup database successfully processed x ...
4
votes
1answer
1k views
Always backup database with encryption
Is there a way to force all database and log backups run on the server to be encrypted?
If encryption is not specified, the query will be terminated.
2
votes
3answers
51 views
Postgresql - How to interpret backup_label contents?
Postgres version 11.
I've read this: https://www.postgresql.org/docs/11/app-pgbasebackup.html
But can't really find what I'm looking for.
Performing a basebackup creates 2 files for me: base.tar.gz ...
0
votes
1answer
22 views
Copy database backup files from Azure to on-premise network
Goal - Take a database backup in Azure and copy the backup file(s) to company network for archiving. Note that I'm not asking how to copy a database.
Research - I have knelt at the alter of Google, ...
4
votes
0answers
145 views
How to debug the cause of my suddenly extremely slow running backup maintenance plan? [closed]
Alexander and the Terrible, Horrible, No Good, Very Bad...backups.
The Setup:
I have an on-premise SQL Server 2016 Standard Edition instance running on a virtual machine from VMWare.
@@Version:
...
0
votes
0answers
54 views
(Error : RESTORE HEADERONLY is terminating abnormally) when restoring SQL Backup from Standard edition to Developer Edition (Both 2017 Versions!)
The instances have the following versions
Source -->
Microsoft SQL Server 2017 (RTM-CU25) (KB5003830) - 14.0.3401.7 (X64)
Jun 25 2021 14:02:48 Copyright (C) 2017 Microsoft Corporation
Standard ...
0
votes
1answer
21 views
Will mysql import overwrite my database
So if I take a mysqldump of my production database called production_database, but I've made changes to by test environment database already, called work_database, adding function/stored_procedures/...
1
vote
1answer
11 views
Restore Postgres backup from pgdump.dir
I have been seeing *.pgdump directory mostly to get the backup and restore. But for my new project the backups are stored under dbname<date>.pgdump.dir
Under this directory, the backups are ...
0
votes
0answers
34 views
How to backup tarantool remotely (over SSH) with compression?
In PostgreSQL usually I do this:
# Backup (remotely via ssh, to local disk)
ssh -p 22 user@dbserver "sudo -u postgres pg_dump -Fc -c dbname | xz - -c" \
| pv -r -b > tmp/db_backup_`date +...
0
votes
1answer
36 views
On premise to cloud restore - Automated?
What's the most automatic way to restore a on-premise SQL Server database to Azure SQL Database?
Has anybody done or seen such a solution?
Scenario:
Need to do a weekly refresh of a dev database from ...
2
votes
2answers
69 views
How do you handle "undo" in databases in general, and PostgreSQL specifically?
I have a complex PostgreSQL-based system which I made myself from the ground up. It contains tons of invaluable (to me) data which I don't want to lose or get corrupted.
I'm always paranoid about ...
0
votes
1answer
59 views
Backup and restore of large SQL Server database with least downtime
I am trying to migrate a SQL Server 2016 database to a SQL Server 2019 server. The database is huge at about 500 GB. It takes about 3 hours to create a Full compressed Backup of about 300 GB and 2.5 ...
0
votes
1answer
35 views
What is the theory and workflow for taking a snapshot of a PostgreSQL database and restoring it in a running application?
The only thing I could find to get started is: Is it possible to quickly create/restore database snapshots with PostgreSQL?
I also see things like this, but I'm not sure if that's all you need.
I am ...
1
vote
2answers
28 views
recovery stopping before commit of transaction- Postgres 11 PITR
I am trying for PITR on a duplicate node. Here are the steps I am following.
Start backup on source node.
select pg_start_backup('backup')
Copy all the files on destination node using these rsync ...
0
votes
0answers
36 views
pg_dump is NOT including extensions
I'm trying to do a backup / restore of a postgresql 11 database from an RDS instance using pd_dump. The documentation states:
When pg_dump is used, the CREATE EXTENSION command will be included in ...
0
votes
0answers
22 views
Availability Group Backups For Ola H.'s Software
Using the Ola Hallengren's DatabaseBackup software on a SQL Server 2016 AG. Trying to use copy-only and tran log backups on secondary node, with Backup Preference set to 'Prefer Secondary'.
Given ...
0
votes
0answers
26 views
What happens if you interrupt a POSTGRESQL database that's receiving data?
I have a Docker application and as a quick and dirty backup strategy, I'm thinking to tar the whole project incrementally and send it off remotely.
I'd rather keep the services running while doing the ...
0
votes
0answers
13 views
Replicating multiple unrelated servers
We have a bunch of live websites running simple LAMP stacks. We have nightly backups to the cloud, but this means that an event like the Strasbourg fire at OVH might happen just before your backup ...
0
votes
0answers
36 views
postgres pg_basebackup terminating connection
I am unable to successfully use pg_basebackup with my database.
system details:
virtual Ubuntu server 20.04
4 cores
32GB memory
storing postgres data to a virtual drive mount (3.5TB capacity)
postgres ...
0
votes
0answers
27 views
Issue with pg_basebackup
I am trying to create postgres replication to another server. But while create base backup., I am getting following error.
Pg_basebackup: could not send replication command "IDENTITY_SYSTEM":...
0
votes
0answers
15 views
Could Barman backup only one database from PostgreSQL?
In my system, I have postgresql 12 and barman v2.13. I have a few backup disk around 1 TB and i have currently added new DB which has 5 TB. Previously my PostgreSQL had no more than 400 GB.
i think ...
0
votes
1answer
150 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 ...
0
votes
1answer
56 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
31 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 ...
