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
2answers
21 views

Missing data for one schema in pg_dump

I have a Postgres 9.6 database with several schemas, and a regular backup of this database is done with a command like pg_dump -h localhost -d db -U postgres -Fc -f file.dump When I restored a ...
0
votes
0answers
33 views

Can not run Sys.dm_exec_requests during backup restore

We do database creation through an application,i am seeing below error when running below DMV query ran : SELECT session_id as SPID,wait_type,wait_resource,last_wait_type, command, a.text AS Query,...
0
votes
0answers
30 views

SQL Agent running Ola scripts: all fine and perfect but a differential backup on a specific database fails

I've two SQL servers with multiple DBs. On both, I've set up maintenance tasks using the Ola procedures. One DB server is Enterprise SQL with Agent and the other is Express using Win scheduler to run ...
0
votes
1answer
19 views

Using pg_dump to create 144 backups per day

Imagine the following scenario (this may not be a viable or sensible idea but please imagine that it is). Using Ubuntu, a cron job calls pg_dump and backs up a Postgres database every 10 minutes. In ...
0
votes
1answer
42 views

Why T-log is not truncated after T-log backup?

I have a database myDB in full recovery model. I took a full backup and restored it on the test server. Afterwards, I checked the size of T-log. The size of t-log was 15600 MB and used space out of ...
2
votes
1answer
32 views

Impacts of a change to the Page Verify option

There's no doubt about importance of doing regular integrity checks on production databases. I'm testing the impact of changing the maintenance plans and changing how databases are backed up. First of ...
1
vote
1answer
21 views

Is it safe to risk multiple Firebird nbackup -L?

I'm using Firebird 3.0 nbackup to lock + copy + unlock each night. If some steps fail or are skipped e.g. due to system restart (updates), it may happen that the master is not unlocked (-N). Next ...
0
votes
1answer
58 views

SQL Server take an unencrypted full backup

I have to take an unencrypted full backup of a database so that it can be sent over to other team after which they can restore it in their own environment. The other team has a different environment ...
0
votes
0answers
19 views

create backup on mysql master-slave

I have MySQL version 5.7 with a master-slave configuration. but I'm confused to make a backup cron. Is there a way to do a backup while remaining safe to master-slave? I heard that using mysqldump is ...
0
votes
3answers
34 views

Handling .bak and .dif files to optimize storage usage

I'm working with a number of different servers that are severely lacking in backups. I want to implement a back up plan using simple mode with full backups weekly followed by a series of ...
0
votes
0answers
18 views

How to better backup MySQL 5.6 database?

Today I had an issue where I accidentally deleted a whole table (which cascaded to a few other tables) due to a funky piece of MySQL syntax, see here. Luckily I had a backup from midnight, however ...
8
votes
1answer
526 views

Is it possible to determine the default Collation and server version of a database without a full restore?

I work for a company who regularly receives large SQL database backups from clients for support purposes. We support multiple SQL versions and collations, but currently have to manually confirm our ...
0
votes
1answer
31 views

SQL Server AG secondary replica database still in Restoring mode

I created an AlwaysOn in SQL Server 2019 and I selected the Full Database and Log Backup option. Now it created a database in secondary replica but it is still in Restoring mode. My DB size is 16MB ...
0
votes
1answer
62 views

Differential backup same size as of Full Backup

I have a SQL Server database of almost 2 TB size, it has tables with image datatypes. Now the size of differential backups are same as that of full backup. Does image datatype makes any difference to ...
0
votes
0answers
9 views

Backup ScyllaDB/Cassandra remotely with compression

How can I backup ScyllaDB/Cassandra remotely? With PostgreSQL I can do something like this (backup, zip, transfer): mkdir -p tmp/backup OUTFILE=tmp/backup/db_backup_`date +%Y-%m-%d_%H%M%S`.sql.xz ...
0
votes
1answer
26 views

Differential Backup of A Table In Sql Server

I will transfer the datas of a two different table to a database in reporting server Daily but i don't want to do it manually and also don't want to transfer all the datas to that databases everyday. ...
1
vote
2answers
32 views

Backing up SQL Server Express Edition on a VPS

I'm considering installing SQL Server Express Edition on a VPS. My understanding is that, among the limitations of Express Edition, some of them involve features that facilitate backups. Can someone ...
4
votes
3answers
138 views

Is Pseudo-Simple SQL Server Recovery a real thing?

"Pseudo-Simple SQL Server Recovery" is term and scenario, I was just made aware of in a (now deleted) comment for the new question SQL Server Truncates Transaction Logs with Copy Only Backups I went ...
5
votes
5answers
494 views

Is there a way to reduce the amount of time spent on a point in time recovery?

I'm pretty sure I know the answer to this, but the limitations of a point in time recovery blows my mind. Say I have a 2TB database set to FULL recovery mode. I diligently take weekly full backups, ...
0
votes
0answers
10 views

Policy of archivelog backup using redundancy politcy?

For example. If I create a policy using configure retention policy to recovery window of 5 days all backups before the 5 days will be obsoletes (datafiles, archivelogs backup etc..) But, if my policy ...
0
votes
0answers
23 views

MySQL oomkiller crashes after backup [duplicate]

I am using percona and the backups run successfully. However after the backup is done and sometimes during the backup MySQL is crashing and I am not certain where to start. Running show engine ...
0
votes
1answer
28 views

WAL Archiving and pg_basebackup

For backing up our postgres database, we're considering 2 separate options: 1- Logical backup with pg_dump 2- pg_basebackup with consistent WAL Archiving. So I have two questions: 1- How often ...
0
votes
2answers
40 views

pg_restore fails on foreign key contraints

I need to restore a PostgreSQL DB from a backup that was created using "custom format" so that a single table could be extracted from it later. (Per the documentation individual tables cannot be ...
0
votes
0answers
40 views

Error when deleting file using xp_delete_file on SQL Server 2005

I'm trying to delete old backups with a scheduled job in SQL Server 2005, running on Windows Vista. Here's my script: DECLARE @BackupPath NVARCHAR(1000) DECLARE @DeleteDate DATETIME SELECT @...
0
votes
0answers
26 views

Error importing MySQL/Percon server tablespace for individual tables

I am using Percona-Server 8.0.x and I am following percona xtraback documentation. https://www.percona.com/doc/percona-xtrabackup/8.0/xtrabackup_bin/restoring_individual_tables.html I am exporting ...
1
vote
1answer
39 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
22 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
156 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 ...
0
votes
1answer
82 views

problem with the restored database [closed]

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 ...
2
votes
2answers
80 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
16 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
48 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, ...
0
votes
2answers
106 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
46 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
45 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
16 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
33 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
29 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
48 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
12 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
30 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
64 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
46 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
34 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
39 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
27 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
16 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
45 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
54 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. (...