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.

Filter by
Sorted by
Tagged with
0
votes
0answers
16 views

Cost efficient SSD/ HDD plan for learning about RAID? (SQL Server) [closed]

I'm trying to learn more currently about backup/ recovery processes when it comes to running SQL Server databases. I have a stack of books and courses I'll be going through shortly. Although I have ...
1
vote
1answer
19 views

Does local.oplog.rs hold all data in mongodb replication?

I'm trying to do backup full and incremental backup, I wonder does local.oplog.rs collecitons contain all info that I need to do backup and incremental backup?
0
votes
1answer
14 views

How to use variables in a mongodump query

I want to backup data of last day (Current Day-1) every day using cron tasks. In the mongo shell, I can query the data using variables as below: var start = new Date(); start.setHours(0,0,0,0); ...
3
votes
5answers
132 views

Restore a database with a different name on the same server

I need a copy of a live database called Carers on the same server for testing purposes. The test database name will be Carers_Test. I took a backup of Carers using SSMS. And tried to restore it using ...
1
vote
1answer
64 views

problem with the restored database

I have a database storing user login credentials of my application in a Table. When I backed up and restored my database to another server, the restore is successful but the login is timing out (SQL ...
1
vote
2answers
69 views

Backup files - Are they safe to delete?

I've got a back up process which initially writes to a local disk, then the disk gets backed up remotely. After each back up (log, diff and full) I'd like to delete all the files on the local disk. ...
1
vote
1answer
13 views

Can I do a backup without extension functions?

I use the PostGIS extension on my database. The thing is when I do a backup and then a restore, all the PostGIS functions give a warning during the restore process, because the functions already exist,...
1
vote
1answer
27 views

How to take backup of multiple DB in a specific point of time

My test setup is having 3 databases in postgresql-9.6 instance, 2 DBs consumed by 2 live Web apps. I am using pg_dump to take hot backup of all databases. In order to keep CPU load under threshold, ...
1
vote
2answers
103 views

To Backup or Not To Backup Test Databases [closed]

Introduction This question is explicitly asking for answers based on experience to allow me to make a decision based on the experience of fellow database administrators in similar situations. This ...
0
votes
2answers
43 views

Initial Full Backup required for Filegroup Backups?

I'm assuming that an initial FULL BACKUP is required if I am taking FILEGROUP backups and would like this confirmed. Many examples show one at the start, but don't make note that it is explicitly ...
-1
votes
1answer
23 views

Copying a Filemaker Database running with an ODBC Connection

Work has a custom Filemaker Pro application, and it has an ODBC connection for the company website to access. I want to migrate the FMP database into a MySql/MariaDB database to tinker on Schema ...
0
votes
0answers
7 views

Postgresql strange backup message with docker

I'm trying to backing up my remote PostgreSql database into the local one. The backup command is the following: docker run --rm -e PGUSER=user -e PGPASSWORD=password -e PGDATABASE=db -it postgres:11....
0
votes
1answer
27 views

mysqldump waiting for table fush for long time

MySQL version: MySQL Commercial 8.0.16 OS: RHEL 7.6 Following is my mysqldump command mysqldump --defaults-extra-file=/mysql_data/config/extra_options.cnf --single-transaction --flush-logs --master-...
1
vote
1answer
28 views

RMAN Restore Validate time equals to actual restore time?

I'd like to know if the time to restore the database is equal the time using restore validate database. If not, How can I know how much time the restore will spend?
0
votes
1answer
46 views

MySQL database backup plan

I have a MySQL database that is about 17GB in size. Right now we don't have a backup for this and I have been tasked to look into backing it up automatically. I am a software developer myself, not an ...
0
votes
1answer
11 views

Assigned filetype for backups not applying

I am working to migrate backups over to a new storage point. I figured the easiest thing to do was to duplicate the configuration over from the existing Maintenance Plan to a new one, just in case ...
0
votes
1answer
21 views

Daily SQL Server Alert: BackupVirtualDeviceFile::SendFileInfoBegin: failure on backup device

I'm running a ~100Gb database on Microsoft SQL Server 2016 (SP2-GDR) Standard Edition (64-bit) on Windows Server 2016 Standard 10.0 (Build 14393: ) (Hypervisor) Every weekday night just after 7pm I ...
3
votes
1answer
63 views

Skipping VM backups for high workload SQL Server?

For those who have virtualized SQL Servers with very high volume transaction workload (very high rate of data change), I am curious how you handle VM backups, or if you even do them. Of course, I ...
0
votes
1answer
31 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
27 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
31 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
25 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
11 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
41 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
52 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
138 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
23 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
33 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
31 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 ...
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
88 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
621 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
36 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
41 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
158 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
63 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
73 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
58 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
42 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
83 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
54 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
24 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
57 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, ...