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,538
questions
-1
votes
0answers
30 views
SQL Indexes are Missing post database restore into new server
We have 2 sql servers.
Database full backup has been taken from server 1 (Read only Database) -This Database is only set to Read Only.
And restored the same full backup file into Server 2.
Post ...
0
votes
1answer
10 views
barman check - what do the Error Messages mean?
Trying to get wal-streaming backups for PostgreSQL running with a barman backup server I face quite some errors on barman check [postgres_server]
here an example
:~> barman check pg
Server pg:
...
0
votes
0answers
15 views
MariaDB "freezes" during mariabackup operation
The Scenario:
I have a MariaDB running in a server named dbmaster, in a dedicated ProxMox server. This dbmaster runs:
Ubuntu 20.04
MariaDB 10.3.31 (installed from repository)
maria-backup 1:10.3.31-...
-2
votes
1answer
20 views
How to backup a live database especifically Postgres
I have production Postgres database that is running remotely and I want to backup the live database without stopping it. I don't want to use pg_dump as it takes too long and not really reliable. Tried ...
0
votes
0answers
5 views
Which rights does a user need to backup procedures in MySQL 8.x?
I am performing a backup on MySQL 8.0.26 which needs to include all routines, triggers, events etc. in order to be fully recoverable.
The command I am using:
/usr/bin/mysqldump -u $MUSER -p$MPASS ...
0
votes
0answers
13 views
How to restore the backup of schema taken using pgdump from a different RDS to a different RDS in postgresql?
I have 2 RDS in AWS actually . I need to take the schema from one of the RDS and restore it into the second RDS without taking the table data. So i have taken the backup using this command in bastion ...
0
votes
2answers
29 views
barman installation without root priviledges - where to put barman.conf?
I am trying to figure out a Barman-2.13 installation via Ansible from the source code from github as barman user inside /opt/barman (which also is the home of the barman user).
I use the barman manual ...
0
votes
1answer
49 views
Why backup db is of more size than restore db which was restored from backup?
I got a 42 MB .bak file, when restored, the database size is about 2048.00 MB.
When I do backup for this DB .bak file size becomes 277 MB.
Why .bak file size increases? I do it immediately after ...
0
votes
1answer
18 views
pg_basebackup and multiple tablespaces
I have the following case:
the master database has an additional tablespace
I'm trying to replicate the master with the pg_basebackup tool
the directory / partition layout on the slave is the same as ...
2
votes
3answers
328 views
SQL Full DB Backup performance on different Hardware
I wrote a fairly simple script that creates in a periodic interval a backup of our DBs, switching automatically into differential in case a full backup already exists.
This runs great on my system. A ...
1
vote
2answers
100 views
In SQL Server the backup file is around 190 gb, but when restore the log needs around 2 TB space
From the production the database is backed up automatically every day full backup and every 1 hour for transactional backup.
A test server was prepared and I want to restore the latest full backup to ...
2
votes
1answer
62 views
PgBackrest perfom restore without wal files
Is it possible to restore a full backup from pgbackrest without the archive files?
I tried to restore a full backup on another server but when I tried to start the instance via pg_ctl start I get an ...
0
votes
2answers
38 views
Does using the export option to backup a MySQL database (12GB size) cause any performance issues or locking on database?
I have a 12GB database. I want to take a compressed backup using the export option via phpmyadmin.
Does this cause any performance impact or locking on the database?
1
vote
2answers
43 views
Make running MySQL with InnoDB flush everything to file to allow file-level live backup
A client has a file-level backup, where every relevant file of a critical webserver is synced to another webserver around 1am.
This includes the /var/lib/mysql directory where the databases of that ...
0
votes
0answers
36 views
Use scoped credential when running database backup
I'm trying to use credentials in scoped manner, since I don't have access to create credentials in server, where I need to run database backup.
When trying to backup database with scoped credentials, ...
0
votes
1answer
33 views
How to configure copy only full backup in veeam?
Application aware full backups and log backups are configured in the veeam settings as shown in screenshot below.
I want to modify the settings such that full backups are using the copy only mode. ...
2
votes
1answer
74 views
Transaction log file size growing, what will be the consequences of setting recovery mode to simple
Recovery mode is set to FULL, and FULL backup is taken on alternate days. No log/differential backups.
Log file size is growing too big. I've shrank log file (googled) a week back and was fine. Now ...
1
vote
1answer
25 views
How to take mysqldump of specific tables across all databases and restore them to a a single database?
I need to take a mysqldump of specific tables across all databases in a cluster.
In this case the cluster has more than 300+ databases. And I need to take the dump of table1 and table2 from each of ...
0
votes
1answer
41 views
MariaDB: Periodic copy of data from local database to remote database
I need to periodically copy the outcome of a view on our local database to another remote database.
I've tried using mysqldump which works fine when copying data from tables to tables, but i need to ...
0
votes
0answers
116 views
SQL RESTORE FILELISTONLY query brings error in event viewer - BackupIoRequest::ReportIoError: read failure on backup device
I use the following query:
RESTORE FILELISTONLY FROM disk = N'E:\Tmp\metadata2012.metadata' with CONTINUE_AFTER_ERROR
--or even like that
--RESTORE FILELISTONLY FROM disk = N'E:\Tmp\metadata2012....
0
votes
0answers
20 views
ERROR: Error when fetching backup: pg_basebackup exited with code=1 when start patroni service for a replica
I created a cluster including 3 servers via Patroni. Everything was alright like failover, switchover... but when I try to add another replica server I am getting an error like this:
Eki 25 13:19:22 ...
1
vote
2answers
46 views
generate alert if someone trigger ad-hoc backup and it's not copy_only backup
We are using 3rd party tool to backup SQL server databases. I am looking to setup an alert which gets generated whenever Ad-hoc backup is taken and it's not copy_only. We are using 3rd party ...
0
votes
0answers
31 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 ...
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
14 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
33 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
43 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 ...
-3
votes
1answer
42 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
62 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
151 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 ...
0
votes
1answer
52 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
144 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
178 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
365 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
48 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
116 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
64 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
159 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
20 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
155 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
22 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
50 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
62 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
23 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
168 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
60 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
29 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/...
