Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-backup]

251 questions
2
votes
1 answer

SQL Server on EC2: What way do i set up the EBS

Good morning. We have a service with a SQL box on Amazon EC2 and, as suggested on this question, we are using EBS to store the data... the problem is, What is the best way to setup the storage? At the moment, during the Development phase, we have 4…
TiernanO
  • 744
  • 7
  • 17
2
votes
1 answer

Creating a small .bak file without indexes or excessive log

I recently was asked to ship a .bak file of our database to a client, and through reindexing all tables with a 100% fill factor (to make sure there were no empty slots), and resizing the transaction log, and 'shrinking' the file was still large…
GilesDMiddleton
  • 385
  • 3
  • 9
2
votes
3 answers

PostgreSQL automatic backup

I have been trying to set up a backup script on a windows server. I have used pgAgent (scheduling for pgAdmin), to run the backup script. No problems with the backup script. However, my jobs are not running like they should. I have set both the…
Ragnar123
  • 193
  • 1
  • 9
2
votes
1 answer

How to debug the cause of my suddenly extremely slow running database backups maintenance plan?

(Originally posted on DBA.StackExchange.com but closed, hopefully more relevant here.) Alexander and the Terrible, Horrible, No Good, Very Bad...backups. The Setup: I have an on-premise SQL Server 2016 Standard Edition instance running on a virtual…
J.D.
  • 121
  • 3
2
votes
0 answers

How can I use garbd+mariabackup to back up a MariaDB/Galera cluster?

I'm migrating a Galera cluster from MySQL to MariaDB 10.3.27, and as part of the process I'd like to change the backup method from the somewhat fiddly (and blocking) garbd+rsync to garbd+mariabackup. Changing the SST method to mariabackup worked…
mbethke
  • 33
  • 6
1
vote
2 answers

Correct way to have a mysql/mariadb incremental backup

I've read for a few hours on this topic but don't have a complete grasp. I'm going to be using borg backup to a network share. Looking to have pretty frequent backups of the binlog....every 5 minutes or so.. here are my takes so far: start mariadb…
BostonAreaHuman
  • 141
  • 1
  • 5
1
vote
1 answer

How to restore from .dump.gz file using dump tool?

I have taken a dump of my server using the following command /sbin/dump -0uan -f - / | gzip -2 | ssh -p ***** -c blowfish dev***@***.**.**.** dd of=/DATA/junkBEN/server-full-backup-date '+%d-%B-%Y'.dump.gz This was suggested in this answer However…
Red Bottle
  • 111
  • 4
1
vote
1 answer

rsync: change_dir "/home/Sources//account@sub.inmotionhosting.com/home/account" failed: No such file or directory (2)

When run this command to make backup database file from remote server, I face the below reasult but I do not know what is the issue. The command I run on my local ubuntu server to git file from inmotionhosting.com rsync -h --progress --stats -r -tgo…
Ahmed Reda
  • 21
  • 2
  • 5
1
vote
1 answer

Mysqldump to compressed file

Situation: 1. mysql is backuped to disk with mysqldump (~250 GB) 2. dump is compressed with bpzip2 3. dump is moved to another DC 4. disk usage again in good state Problem: Filesystem usage peaks, example: I need 1 TB space to fit the data while…
Damian
  • 21
  • 4
1
vote
0 answers

T-SQL Finding who attempted to backup the “master” database?

I'm running SQL Server 2016. For the last two nights at 7pm the SQL Server Alert System sent me this alert: 'Severity 016: Miscellaneous User Error' DATE/TIME: 8/8/2018 7:02:19 PM DESCRIPTION: BACKUP failed to complete the command BACKUP…
andyabel
  • 111
  • 1
1
vote
1 answer

Is it safe to restart a database as soon as VSS backup begins?

I know that VSS is designed to create a snapshot of the state of the entire system as soon as you call begin backup, and hold on to it until the backup is ended (or the disk runs out of space). Does that mean that as soon as begin backup returns…
SilverbackNet
  • 383
  • 2
  • 10
1
vote
2 answers

Backup strategy for dedicated LEMP stack server

We currently have an application running on a dedicated server which utilizes a LEMP (Linux, Nginx, MariaDB, PHP) stack. Right now we are only doing backups at a set interval (every x hours). I have been researching how we should go about having a…
nullReference
  • 263
  • 1
  • 3
  • 11
1
vote
3 answers

Where to store db backups in centos 7?

Where should I store my db backups in Centos 7? Are there any best practice for this? Should I put them in /var/lib//backups as suggested in this answer?
Zolbayar
  • 123
  • 1
  • 6
1
vote
1 answer

best raid level for backup server

I'm building a Centos 7 server to hold Postgres backups (using Barman). The Dell PowerEdge server has a Perc-8 controller (H710P), and there are 12each 3TB 7200rpm SAS drives available for a raid set to store the data. I'd use the Perc to do the…
user214691
  • 11
  • 5
1
vote
2 answers

SQL 2012 Transaction Log backup does not truncate the logs

I'm a beginner in DB administration so bear with me. I have a small DB 500MB with a very large transaction log (19GB). I'd like to keep this in "Full Recovery" mode, so please do not suggest "Simple" recovery mode. I have been researching about how…
user2629636
  • 774
  • 5
  • 19
  • 40
1 2 3
…
16 17