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.
5
votes
3answers
812 views
Do I need full recovery mode when I have multiple daily backup?
I have created 5 maintenance plans on my SQL server (say 50 !) which generate databse backup 5 times daily. As I read in this Q/A the full recovery is good when I need Point-in-time recovery.
My ...
1
vote
1answer
44 views
Sensible database backup retention policy?
Scenario:
DB is replicated in two availability zones (for high-availability)
DB is backed-up daily in geographically separate location (for disaster recovery)
App-level user events are stored in the ...
-2
votes
0answers
23 views
Oracle 12.2.0.1 Data Guard instructions Step by Step [on hold]
Can anybody point me to a document which they have followed to successfully implement new Data Guard on following environment :
- Oracle 12.2.0.1
- non-multitenant
I have tried a few resources on ...
0
votes
1answer
31 views
Online schedelud backup SQL Server DB [on hold]
I have an app in a Windows Shared Hosting using a SQL Server Database. The control panel is Plesk.
I want to make daily backups and send them to a Google Drive account, but from an online UI. I don't ...
0
votes
1answer
14 views
PSQL incomplete backup : how to debug
I've been doing backups of my database " screen ".
after connecting to PSQL and typing \l+
I'm getting (among other things):
Name | Owner | Encoding | Collate | Ctype | ...
1
vote
0answers
17 views
Which PgBackRest policy for differential backups in PostgreSQL
I set up pgBackRest and PostgreSQL configuration in two differents servers.
I set up with crontab one full backup a week and one differential backup a day.
0 1 * * 0 pgbackrest --type=...
0
votes
1answer
21 views
Barman: What's the best way to switch from backup_method postgres (streaming) to rsync (ssh)?
My production postgresql server is currently backed up with barman using the backup_method postgres (streaming server). I would like to switch to rsync method (ssh) to benefit from better compression. ...
1
vote
0answers
27 views
OCI KBHS-00719: Error 'unknown'; Archived object is not restored
I am encountering below error message from RMAN backup to OCI.
Either the bucket named 'DB_BACKUP' does not exist in the namespace
'UNIcredits' or you are not authorized to access it. KBHS-01404:...
0
votes
1answer
18 views
Monitoring PostgreSQL backup
I am new to PostgreSQL and have questions regarding the backup procedure.
How do I check whether a PostgreSQL database was backed up successfully?
And how do I monitor the backup?
I have tried the ...
0
votes
1answer
15 views
Will this RedGate backup plan interfere with a new differential backup plan I want to create?
First, I need to get an assumption verified: If I setup a differential backup plan and someone comes along and manually creates a backup without specifying COPY_ONLY then it's going to throw the plan ...
1
vote
1answer
46 views
What will be inside the last differential backup file?
I am new in DBA and while learning different types of backup, one question came into my mind. So the question is, what will be inside the last differential backup, just the sum of the previous ...
2
votes
2answers
22 views
Will I be notified that BACKUP encountered a CHECKSUM error if I use CONTINUE_AFTER_ERROR?
I am in the process of adding the WITH CHECKSUM flag on our daily SQL backups, as part of an effort to better ensure data integrity.
I definitely want to know if a checksum error is ever encountered, ...
7
votes
3answers
414 views
Can full drive backup be used instead of MSSQL database backup?
I have a MSSQL Express server running on a VM. Hosting provider I use has an option to create drive snapshots. The server is running all the time and is not stopped during the drive backup. Backup ...
0
votes
1answer
35 views
UTL_RAW “invalid identifier” error message
When I execute the following:
select utl_raw.cast_to_raw('8') from dual;
I receive the error message below:
invalid identifier
...while in other PC with the same Oracle version, i.e., 11g, the ...
0
votes
2answers
40 views
Backup MS SQL AG on a non-production environment
We've created a non-production environment for SQL Server.
This environment uses the SQL Server Always-On Availability Groups as a HA-solution.
To work with SQL Server AG's you have to set the ...
0
votes
0answers
22 views
mysqldump writes dumped data to output
I'm trying to bring incremental backups to one old setup. The script I create worked perfectly when run directly. However when I run it from crontab or when redirecting shell output all data is ...
0
votes
2answers
13 views
What is the behavior of SQL Server Maintenance Plan - Clean Up task for deleting old backups
This seems pretty obvious, but it's remarkably hard to find an actual document that addresses this.
The scenario:
Full Backup - Weekly (Set to expire after 7 days)
Differential Backup - Daily (Set ...
1
vote
1answer
67 views
SQL Server TDE Vs SQL Server Database Backups
Can anyone please help me understand below case:
Kindly advise on below case:
SQL Server is on 2014 SP2 GDR version
I read Compression and TDE does not go hand in hand .
I have 2 PRD Environments:...
2
votes
3answers
94 views
Is there a way to retrieve the logical filename from a backup file?
I would like to write an automation script that restores a SQL Server DB from its backup file. However, doing this is not a straightforward procedure in SQL because the main query needs additional ...
0
votes
0answers
55 views
I can not Ola Hallengren database backup script to Data Domain make works
Ola Hallengren has a nice SQL Maintenance scripts that I installed to our dev SQL server. The backup script works very well to a local drive, however it does not work to Data Domain. At all.
Here is ...
0
votes
0answers
43 views
mariabackup of database running in docker
I have MariaDB running in a Docker container with the container's data directory /var/lib/mysql/ mapped to the host directory /mnt/data/.
I want to run mariabackup from the host to create a physical ...
0
votes
0answers
6 views
Can pgBackRest be integrated with third-party backup suftware?
I am trying to figure out pgBackRest to backup PostgreSQL databases.
So far my understanding is that it can use a local file system or S3 for backup storage.
Is there any way to get it to use third-...
7
votes
2answers
2k views
Why is my log file so massive? 22gb. I am running log backups
I can't seem to figure out the answer. I've seen multiple answers like this:
Why Does the Transaction Log Keep Growing or Run Out of Space?
and everyone talks about running back ups on your log file ...
1
vote
0answers
10 views
How to : gcloud Snapshot MariaDB Galera Node?
How to do a gcloud snapshot of Mariadb Galera Node for backup and restore ? I heard of people talking about gcloud snapshots and nowhere explains the full process of doing it. Kindly delight with the ...
0
votes
0answers
43 views
How to speed up MySQLl loading from dump file?
I'm using mysqld Ver 5.7.25-0 in Ubuntu 16.04. I dumped from AWS Relational Database Service (RDS) with mysqldump --single-transaction --quick --max_allowed_packet 1G ... and now when I tried to load ...
0
votes
2answers
67 views
Attempting to backup to remote NAS but access is denied
I was attempting to use Ola Hallengren's scripts to backup to a remote NAS, but it was failing and not giving any direct errors, so I tried doing it manually using Server Management Studio and got the ...
1
vote
0answers
9 views
Oracle Secure Backup (OSB) issue - “failed to read configuration data - Network is unreachable”
I am using Oracle 12.2.0.1 on Linux 6.8. I am using OSB to take a backup to tape.
After an unknown host name error in the backup log, I edited the /etc/hosts file and restarted the server.
After ...
2
votes
2answers
139 views
How to minimize\plan ahead the effect of running sp_delete_backuphistory? Measure the gains too!
while running the following query:
-- DATEADD (datepart , number , date )
DECLARE @dt DATETIME
SELECT @dt = DATEADD(month,-6,getdate())
select @dt
EXEC msdb.dbo.sp_delete_backuphistory @...
1
vote
2answers
65 views
sp_databaserestore: “stopat” gives error “no database backup found”
Unfortunately I get:
“No backups for “database xxx” found in “\xxx\xxx$\…”
as soon as I add the @StopAt = ‘2019-03-27T04:05:20 Parameter.
When I comment this Parameter, everything works fine, ...
0
votes
0answers
64 views
Full backup job failed after changing backup location
In AG Environment, for the last 30 days, the daily Full backup job is failing for a few of the larger databases. The rest of the databases are getting through daily so far. We recently changed the ...
0
votes
1answer
31 views
Create publication is not working in PostgreSQL
I am trying to create a publication (for logical replication) in PostgreSQL database but it throws an error:
indsolv_dev=# CREATE PUBLICATION my_publication;
ERROR: syntax error at or near "...
1
vote
1answer
48 views
Having the backup file, how to work out the total disk space required to do the restore?
I have a nice query that gives me the date of last full backup, size and location, even when I backup to multiple backup files.
what I don't have is an estimate of the total backup size (for each of ...
3
votes
1answer
58 views
How are database backups conducted using SQL Server VSS Writer Service
We have few servers where backups are running from an unknown source. The physical_device_name in the backupmediafamily table is something like {922DDBA9-0686-46B8-94BC-XXXXXXXXXX}2.
I was checking ...
0
votes
1answer
24 views
How to clear all configurations on RMAN
How can I clear all configurations listed with the command show all on RMAN to default? I just found how to clear one unique configuration for exemple: CONFIGURE CHANNEL DEVICE TYPE DISK clear
0
votes
0answers
33 views
rman backup takes too long time on oracle 10g
i have a problem that my rman backup on sl45 tape drive takes 2 days to backup 450GB database, the problem that the log shows that the backup waits too long periods between finishing a certain task ...
1
vote
1answer
37 views
SQL Server Backups-Order of FULL & T-log backups
I have an elementary question. I just started as a DBA with no administration experience and upon reviewing the Backup schedule, I noticed on one instance that the maintenance plan that performs the ...
1
vote
1answer
71 views
File permissions for database backups and certificate backups
I have backed up a database and backed up the database master key to the very same folder. Everyone has full access to this folder, however, only the database backup inherits the permissions of the ...
1
vote
2answers
49 views
How much time should a backup of a 100Gb database take using streaming server setup?
I've installed barman on a dedicated server to backup all my postgresql servers. One of the server is now using 100Gb space and the instruction barman backup myserver takes 23 hours. I find it too ...
0
votes
0answers
6 views
Couchbase backup and restote through copy data files
I was exploring couchbase backup and restoring procedures then we found standard procedures. But, if I can take data directory backup in the form of .tar and untar data directory whenever restore ...
2
votes
2answers
58 views
Handling partial backups from many different databases
I've got an issue and I'm looking for best practice advice / whatever I can do to make this work.
I need to come up with a way to automate getting a backup from many offsite databases of unknown name,...
3
votes
2answers
384 views
Database Backup for data and log files
I have been told that for data files backup operate at extent level and for log file, backup operates at page level.
I know that the file type for data file is always "Rows Data" and is stored in the ...
0
votes
1answer
33 views
Split Backup of MSSQL VS Stripe Backup of Sybase ASE
I recently came to know about concept of split backup in MSSQL Server whereas I have been working on stripe backup in Sybase ASE.
Stripe backup in Sybase ASE is faster than normal backup and if we ...
0
votes
1answer
32 views
Restoring PostgreSQL tables faster
There's a PostgreSQL PITR system running on a fairly large system, with hundreds of databases with hundreds of tables in each, and we're running into time constraint-based problems when trying to ...
0
votes
0answers
24 views
MYSQL #1146 : does it mean the data was lost?
I delete WampServer with all databases and install a new version (AppServ) with php,mysql,apache
before I deleted it I copy the wamp64 folder to D:\wamp64 then I just move the folder D:\wamp64\bin\...
2
votes
1answer
44 views
Creating encrypted backups inhouse to be restored at client
I am trying to understand the mechanics of database backup encryptions, but there are some issues, which I can't seem to wrap my head around. I have 2 requirements:
I need to be able to create and ...
1
vote
0answers
22 views
Can I restore a Replication Subscriber backup without needing to re-configer/re-initialize
I've been trying to read up on this and there are quite a few of posts about restoring a subscribers' backup on a different machine but my question is about -- in my opinion -- a much more simple ...
1
vote
1answer
29 views
Differential Backups with Replication?
I am pretty sure that Differential Backups with Replication is ok, but I am not finding anything that clearly says it. Nor am I finding anything indicating issues with it. Just looking for validation ...
0
votes
1answer
132 views
Barman not able to connect: fe_sendauth: no password supplied
I'm trying to setup streaming replication to a Barman server.
Barman config is pretty much basic, I'm using backup_method = postgres.
[barman]
barman_home = /var/lib/barman
barman_user = barman
...
2
votes
1answer
39 views
How to find out the oldest full backup still existing on disk?
one of the things I like to find out is what is the oldest full backup file still living in my servers.
it is the custom to delete or move those files to a different place after a number of days. How ...
0
votes
1answer
18 views
How to do a configuration on RMAN with run block without save this configuration on rman
I want to do a run block with this configuration for test:
run {
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 50M;
BACKUP DATABASE;
}
But I don't want that the configuration CONFIGURE CHANNEL ...
