Database Administrators

Questions tagged [backup]

Ask Question

Making copies of data which may be restored after a data loss event or to recover data from some earlier point in time.

2,258 questions
Newest
Active
Bountied
Unanswered
Filter by
Sorted by
Tagged with
1
vote
2answers
47 views

How does the actual restoration works in SQL Server internally?

Suppose my Database DB1 lost some data, but I have a Full, Differential and then followed by Transaction log backups. Till full\Differential backup I can understand it is like the snapshot of the ...
0
votes
0answers
19 views

barman & Dockerized PostgreSQL: check timeout: FAILED (barman check command timed out)

I am trying to configure barman to backup a PostgreSQL 11 database running inside a Docker container. barman v2.10 is installed directly in the Ubuntu 18.04.3 host machine. barman check pgsql gives ...
0
votes
1answer
48 views

why are my Database backups occasionally failing?

Part of our back up routine, on our main production server, I nightly take a full backup of all of the databases. These databases get restored on several dev severs and data is obfuscated. These ...
0
votes
0answers
13 views

lock-ddl-per-table option not working as expected in Xtrabackup

I've recently been getting the following errors on some of my Percona XtraBackup backups: InnoDB: An optimized (without redo logging) DDL operation has been performed. All modified pages may not have ...
0
votes
1answer
23 views

How to Install postgresql-client-11 on Ubuntu 18.04

I need to use the pg_basebackup/pg_dump program on an Ubuntu 18.04 system to connect to a remote PostgreSQL 11.6 server. However, the current system only contains pg_basebackup 10.10 and the remote ...
1
vote
1answer
30 views

Why do I have to change Media Sets to create a Full Backup to a new file and what does that mean?

I'm trying to create an ad-hoc Full Backup as a snapshot of the database in time and when I added a new file to backup to I get the following error: I see I can surpass this error by going to Media ...
0
votes
0answers
39 views

Database Backup & Framework [closed]

I am working on a server which has 50+ databases. Current database backup strategy is using maintenance plans which is obsolete and difficult to debug and maintain. I am proposing a framework to ...
0
votes
1answer
13 views

Maintenance plan: Confirmed server as primary but switched to secondary during backups?

While investigating a failed job that occurred over night I stumbled on to a novel situation that I thought was pretty interesting. A server that was part of an AOA group was performing nightly ...
0
votes
2answers
55 views

Restore database stuck at 100% progress

We are seeing restore taking more than 25 minutes for a simple 4 mb file .Restore progresses to 100%,but it wont update any status from there When checked in error log ,we could see below error... ...
0
votes
2answers
22 views

pg_restore: error: could not read from input file: end of file

I do try to create a dump of a table, that is stored inside of my database. The table is called webapp_product In order to create the dump, I do use following commands: docker-compose exec db1 ...
0
votes
2answers
40 views

Very large Transaction Log File - When is it normal?

I have a server that is running extremely low on disk space and I dug into to determine if something is not functioning properly or if it simply is a healthy database that just happens to be growing. ...
0
votes
0answers
21 views

Is It Possible Backing Up Postgres Backups To Windows Backup Server With PgBackRest

I want to take my postgres backups to our backup backup server which works on windows server, with pgbackrest. My postgres databases are on CentOS/7 OS. I can take those backups to my local but i want ...
1
vote
1answer
37 views

Are there differences between which AlwaysOn AG server (Primary or Secondary Replica) I store my backups and retention maintenance plans on?

I have an AlwaysOn AG system in place between two servers. Server A hosts the primary replica, Server B hosts the secondary replica. Are there any differences if my Full & Transaction Log ...
1
vote
0answers
25 views

Backing up Time Series Database (PostgreSQL/TimescaleDB) where old data will never be updated

If a PostgreSQL (using TimescaleDB extension) database that holds time series data is continuously growing in size, what is the recommended backup strategy if we do not want to continuously create ...
1
vote
1answer
24 views

Is it possible to backup users from MongoDB admin database?

The title sums it up nicely. Essentially what I am asking is, if its possible to backup (use mongodump perhaps?) only users (accounts created for human users)?
0
votes
0answers
22 views

Firebird begin backup and forced writes off, timestamp update delayed

We have a Firebird database that's almost 200 Gbyte in sice, and for performance we have forced writes off. Please don't debate the risks of forced writes, we are aware of them. This is Firebird 3.0.4 ...
-1
votes
1answer
27 views

MySQL how to make a backup while the server is not running

I made a update on my mac to catalina few days ago. After this my MySQL-Server was broken and I would like to reinstall it. Before doing this I would like to make a backup of my database. Because the ...
0
votes
1answer
45 views

Piecemeal restore only one filegroup without primary filegroup restore

I have a db in SIMPLE recovery model, and regularly take FULL,DIFF backups. This db also have filegroups for each month. Each filegroup has exactly one NDF file. Like this: FileGroup: PRIMARY File: ...
1
vote
0answers
18 views

How to select specific databases in a backup retention policy maintenance plan cleanup task?

I have full backups of three different databases. Right now all of their backups follow the same retention policy, but I need to setup the retention to a different amount of time for each database. ...
0
votes
2answers
44 views

Is it Possible To Take Full And Differential Backup in Postgresql Like Sql Server?

I have a postgresql server. I want to take its backup full and differential mode as it is like in sql server. Is it possible to do this in postgresql? How can i do it, if it is?
0
votes
2answers
24 views

Large database backup files integrity check after or before copy

I was trying to copy large database backup files(appx. 2TB each) to different region using robocopy. But I have noticed the speeds are drastically slow when using the switch /Z. So I have removed this ...
0
votes
2answers
43 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 ...
1
vote
0answers
92 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(connection context is master) query ran : SELECT session_id as SPID,wait_type,wait_resource,...
0
votes
1answer
41 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
24 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
50 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
35 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
23 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
71 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
22 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
35 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
1answer
24 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
536 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
46 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
68 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
1answer
67 views

mysqldump vs mysqlbackup

I am using MySQL v5.6.x. and using mysqldump takes a long time to dump and restore the db and does not seem practical for DB size larger than 50GB. It looks like the mysqlbackup utility that comes ...
0
votes
0answers
11 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
27 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
33 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
142 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
503 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
17 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
36 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
54 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
41 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
28 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
74 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
41 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); ...

1 2 3 4 5 … 46