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,259
questions
1
vote
1answer
38 views
minimum space is required on disk to restore a backup in SQl Server?
Suppose I am going to restore a backup (2 GB) in my sql server, I have sufficient space (20 GB) in my disk, but is there any algorithm that SQL server follows to calculate the minimum disk space ...
2
votes
2answers
71 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
1answer
41 views
In SQL server during Log Shippping which portion (active\Inactive) of the Log file (.ldf) backup is taken and further restored in SQL Server [closed]
I am confused, like if we take the backup of the whole log file, wont it clear the transaction log though we have copy only backup.
In log file we have 2 parts, like active and inactive logs, in ...
0
votes
0answers
20 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
53 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
15 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
24 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
31 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
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
56 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
25 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
38 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
25 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
46 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
19 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
45 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
93 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
42 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
51 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
24 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
73 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
70 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
70 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
143 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
504 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
57 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 ...
asked Dec 12 '19 at 22:05
UnconditionallyReinstateMonica
5511 gold badge4 silver badges10 bronze badges
0
votes
0answers
42 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?
