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,054
questions
-1
votes
1answer
18 views
RMAN log file with date and name in Oracle 11gR2 in Linux
I have a script and I want to create my log file with datetime and with unique name. It's my script:
.......
.......
rman target/ LOG='/u01/backup/logs/rman.log' <<EOF
.......
.......
.......
...
1
vote
1answer
23 views
Cannot take backup into NAS storage at specific time
I have a job which runs every 30 minute and takes t-log backup of the database suing Ola's script. Every Thursday and Friday at 22:45 I get an error:
11/07/2019 22:45:00,Backup,Unknown,Error: 3041<...
3
votes
1answer
30 views
Log error restoring old database to SQL Server 2017
I am trying to migrate a database from an old SQL Server 2008 R2 to SQL Server 2017. The database was originally 2000 and thus has a compatibility level of 80. Initially I took a full database backup ...
1
vote
0answers
20 views
What All Is Factored Into A MySQL Checksum? (Why Could They Be Different?)
I'm currently going through the excruciating task of moving MySQL databases from one shared web hosting environment to another.
This has been a multi-month battle (and I'm learning a lot). After ...
0
votes
0answers
9 views
Barman backup fails: reconnection not allowed
Several barman backups failed due lost connection. Is is possible to configure barman to retry backup in such case?
barman show-backup psql01a 20191109T040008
Backup 20191109T040008:
Server Name ...
1
vote
1answer
38 views
can I do a restore controlfile from autobackup out FAST RECOVERY AREA?
I know that I can issue the command restore controlfile from "location_here". But there is some config that can I do for issue the command restore controlfile from autobackup even whether the ...
0
votes
3answers
47 views
how to automate DB restore to another server?
The plan is to have 1 backup set that will contain full and transactional log backup. (Server1)
There is already a scheduled job that will append any transactional log to the file after 30 minutes. (...
1
vote
4answers
121 views
How to prevent a full database backup
We are in the middle of migration, a full backup has been taken and copied to the destination. On Friday, we plan to do a differential backup, but someone has by mistake taken another full backup (did ...
1
vote
0answers
22 views
Are LOBs also backed up if I take dump of all partitions of table individually?
I am taking export of a large table in oracle through datapump. I am taking export of all partitions one by one. The table has a LOB column as well. Are LOBs also backed up with partitions? Because ...
1
vote
0answers
32 views
Does the target database need to have the same structure of the source database before to use IMPDP?
When I do a import from another database have I need the same estruture of the source database in the target database?
For example, if my source database use ASM and my target database no, what have ...
1
vote
2answers
26 views
Restoring Postgres from only base backup taken with wal-e
I have a postgres base backup taken via wal-e. Is it possible to restore and start the DB with just the base backup? I cannot use the restore_command in recovery.conf since the wal files are archived ...
0
votes
0answers
13 views
Postgres Database Level Incremental Backups
I need to take database level incremental backup in postgres. I have searched on internet, however all available methods and tools provide whole database cluster level incremental backup. But, not any ...
1
vote
0answers
44 views
How to recover dropped tables in Postgres without a backup? [closed]
When starting the application, hibernate deleted the tables in postgresql.
Is it possible to recover the data without a backup?
0
votes
1answer
30 views
Are physical backups sufficient in PostgreSQL? [closed]
Should I make logical backupds too from time to time or are physical backups sufficient for recovery in case of emergency in PostgreSQL? What are the advantages of logical backups?
I have heard ...
3
votes
1answer
81 views
Decrypt T-SQL log backup header and read LSN
For some reason I need to read the LSN from the T-SQL logs backups without restoring them or even their headers (I assume even restoring only their headers will change the LSN on the database side too,...
12
votes
2answers
616 views
During a log backup is the data backed up to the start or end of the operation?
Say I am running a log backup, and that log backup takes 10 minutes to complete. During that 10 minute window, further transactions are run. Given the below example, which transactions does the log ...
1
vote
1answer
31 views
Can I use a mariadb/mysql dump from older version in newer version?
I'm a mariadb/mysql newbie. I want to take a complete backup.
Apparently this is the way (please correct me if I'm wrong):
mysqldump \
-h... -u... -p... \
--hex-blob --routines --triggers \
--...
0
votes
1answer
41 views
It's a good practice always restore controlfile before restore the database?
I'm beginner in Oracle, but I'd like know if it's a good practice always restore the control-file of a backup-set before restore the database. I ask this because always when I restore the control-file ...
2
votes
2answers
67 views
How can I backup my large SQL Server table?
Environment: SQL Server 2008 R2 Standard Edition on Windows Server 2008 R2 (yeah - I know). VMWare, Commvault.
We have a 1.4 TB DB with one table. Here is the schema:
CREATE TABLE [dbo].[...
0
votes
1answer
40 views
Backup SQL Server 2017 to remote directory
There is SQL Server instance with 4 DBs.
There is remote directory '\u12160.your-backup.com\backup\SQL' which can be accessed ONLY with User/Password (no user auth or anything other).
I want to ...
0
votes
0answers
7 views
How to correctly have binary logs stored…Mysql/Maria
So I'm taking a full backup at 12AM each day.
At 2,4,6,8,10etc etc I'm taking incrementals.
Using Mariadb and maraibackup...
At each point I want to flush and purge the logs so I don't have to ...
8
votes
1answer
150 views
Internals of backup compression with TDE (SQL Server)
Does anyone have any (inside?) knowledge of how backup compression works with TDE on SQL Server (version 2016+).
In general I would expect compression of encrypted data to have minimal benefit, ...
0
votes
0answers
56 views
RESTORE VERIFYONLY FROM DISK is failing
We are having WSFC(Windows Server Failover Cluster) configuration for one of database server and from last few days, backup of one of the database is failing. Sometime backup itself fails whereas on ...
1
vote
1answer
51 views
postgresql pg_dump out of memory
is it possible to limit somehow usage of resources for pg_dump?
The problem is, whole DBase is 775GB and i have two very large tables:
pg_largeobject table is – 390GB
pg_largeobject statistics:
...
2
votes
0answers
12 views
How do I use mariabackup to do point in time restores?
So I've read about the basic way that I can backup my mariadb using mariadb backup...
What I don't understand is how to make it point in time......
So I want to restore using mariadbackup full and ...
1
vote
1answer
56 views
Backup too big to restore
I have a backup which in file explorer is roughly 160GB.
If I run
select sum((size*8)/1024) From sys.database_files where type=0
I get a result of 169493, fine.
When I try to restore this ...
0
votes
2answers
33 views
How to restore a .backup file from a single table on postgres?
I have a .backup dump from a single table, but it didn't work restore like a normal backup from an entire db. I'm creating this backup file with the following batch script bin\pg_dump -h localhost -p ...
0
votes
2answers
33 views
How to simulate bad backup file with 'ultraedit'
I want to simulate bad backup file with ultreadit, but I don't know how as I know nothing about ultreadit. Please help me with that.
I simply want to make the SSMS fail to read the pages of a bad ...
0
votes
2answers
54 views
pg_switch_wal In Point In Time Recovery PostgreSQL
I was following this tutorial about point in time recovery in postgres and come up with the following questions. Can anybody help me.
Is it necessary to use pg_basebackup every time I want to back up ...
2
votes
0answers
24 views
MongoDB best backup Practices [closed]
I have the following questions to ask:
What are the best practices for MongoDB backup
Is mongodump a good option for data greater than 50GB?
Does mongodump have any adverse effect on mongodb while it ...
0
votes
1answer
39 views
Azure Backup SQL VM - Not shrinking log file after transaction log backup
I am using Azure Backup to take a transaction log backup from my SQL 2016 Enterprise VM every 15 mins. It also takes one full backup daily. The db is using Full recovery model.
Problem is that the ...
1
vote
1answer
22 views
Can you Identify the sql server name from sql backup file(.bak)?
I have a backup file from an SQL 2016 server and I need to identify which SQL server the file was created on. Is there a way to identify the original SQL server where the file originated at? Thank ...
0
votes
1answer
45 views
SQL Server can't see already mapped network drives
I'm trying to backup databases through SSMS and cannot see any already-mapped network drives.
The SQL Server service account is what I'm using to log in, and it has permissions to the network share, ...
0
votes
0answers
11 views
how to restore wal file that is in tar format in postgresql
I am trying to use incremental backup provided by postgres. It is working if I copy the WAL files as it is in another folder and then recover. But if I make .tar.gz of WAL file then try to recover db ...
5
votes
2answers
337 views
SQL server backup message
Could you please give little clarification about SQL server backup message
For example :
BACKUP DATABASE successfully processed 19696388 pages in 1945.648
seconds (79.088 MB/sec).
For example ...
0
votes
0answers
40 views
How do I stop Amazon Web Service's RDS from locking out connections during backups?
I've been using RDS for years, and this only became an issue a few months ago. I was pulling my hair out trying to find the source of the issue... only to figure out it's suddenly RDS.
I've made no ...
5
votes
4answers
157 views
What is the best SQL server backup strategy for large DB with few tables and lots of immutable data?
We have a large DB (500GB and expanding). 95%+ of the data is stored in 3 tables (one table has 2bn+ rows). The data is largely immutable - i.e. once it's added it's only then read afterwards. We can'...
6
votes
3answers
1k views
Is it possible to take a database offline when doing a backup using an SQL job?
I have the scenario where I have to generate a backup of the database (SQL Server 2008) and restore into the new server (SQL Server 2016). While taking backup data should not be changed in any case. ...
0
votes
1answer
78 views
SQL Server with small database size and huge log file size
I have several databases, for some log file size is growing more than normal even though very little data is added to few table around 50-100 rows a month. i.e. Database 12 data file size is 79MB and ...
1
vote
1answer
29 views
Postgres backup PITR strategies [closed]
Note:-Might be the question sounds too broad. But, I believe ,it's very good platform(stackexchange) and I can get advice from worldwide expert DBA here. Since, I'm not able to make decision or choose ...
1
vote
1answer
34 views
Ignore a database in an Availability group when using @AvailabilityGroups = instead of @Databases with ola-hallengren backup solution
I’m using the @AvailabilityGroups= parameter to backup availability groups, is it possible to NOT backup (exclude) a database in the Availability group?
If using the @Databases parameter I could use -...
0
votes
2answers
85 views
pg_basebackup failing from another server
I want to take backup of my PostgreSQL database cluster from another server. I'm using below command ,from another server:
[root@shiwangini2 pgsql]# sudo -u postgres pg_basebackup -h 192.168.XX.XX -...
0
votes
0answers
60 views
mariabackup slave info and multi-master replication
I have several master databases using mariadb 10.3 and replicate then all to one replica using multi-master replication. All is working fine.
I want to backup that replica server, so i can restore it ...
13
votes
1answer
2k views
Temporarily moving a SQL Server 2016 database to SQL Server 2017 and then moving back. Is it possible?
If I take a backup of a database from a SQL Server 2016 instance and then restore it to a 2017 instance to do some work on it.
Can I then turn around and back up that database from the 2017 instance ...
0
votes
1answer
38 views
Incremental backup split across files
I have to move a database from one cloud provider to another. It has to be done in an hour window. The DB is 16Gb, and the line speed between the current host, and Azure (The final destination) ...
0
votes
0answers
37 views
Can stopping a backup job while its in progress affect future backup jobs?
Can stopping a backup job while its in progress affect future backup jobs? i stopped a backup because it was taking too long and affecting production, and since then all my backup jobs have failed. ...
0
votes
1answer
57 views
How to solve a mail issue Failed to initialize sqlcmd library with error number -2147467259?
I got an error while trying to send an email:
Msg 22050, Level 16, State 1, Line 0
Failed to initialize sqlcmd library with error number -2147467259.
Here is my query:
DECLARE @Table TABLE (
...
1
vote
2answers
79 views
Sql Server Restoring Process Time Takes Too Long Time
I have 7 databases on my reporting server. I restore those databases every night with differetial backups. Normally, the differential restore time was taking about 1 or 1.5 hour for each databases. ...
0
votes
1answer
13 views
Azure PostgreSQL pg_dump impact on backup “chain”
I'm a SQL Serve DBA new to PostgreSQL. Does pg_dump have an impact on the backup chain, i.e., in SQL Server if I needed a copy of a database I would peform a COPYONLY backup so as not to break the ...
0
votes
1answer
72 views
Error 23 on transaction log backup, full backup works fine
I have a database with the database files on the E: drive, and logs files on the D: drive.
I'm getting the following error when trying to run a transaction log backup:
Read on "D:\LOG\AOA_Log.ldf" ...
