Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-backup]

251 questions
4
votes
3 answers

SQL Server Backup retention policy

I need to backup database in full recovery mode with a condition as: 1. Backup database, only when space is available for backup operation and Backup retention policy must be like expect last two days backup folder, delete all other backup…
Dhiva
3
votes
1 answer

downloading a big database (postgres) to a local copy

I have a pretty big postgres DB on Amazon RDS (about 9GB when zipped), and sometimes we need to copy it and do some tests on it on our local machines. Doing a DB dump (pg_dump) and downloading it is simply too slow and honestly been just getting…
Ronen Ness
  • 169
  • 9
3
votes
1 answer

Sharing keys and certificates between SQL Server 2014 server for encrypted backup and restoration

I have six SQL Server 2014 servers. I am not using TDE, Transparent Data Encryption, on any server. I would like to be able to take an encrypted backup of a database on ANY server and restore that backup to ANY OTHER server. What actions do I…
John Lofgren
  • 31
  • 1
3
votes
1 answer

Best practices to backup mysql databases

This question concerns best practices for mysql backup with replication and large number of databases. I'm looking for your point of view and suggestions :) I - Current situation I have two databases master/slave (mysql replication) on each one of…
maxime_039
  • 243
  • 5
  • 14
3
votes
2 answers

Automate pg_dump in a bash script

I am re-learning bash after years of not using it very much and need to figure out a way to automate pg_dump of a single database to a directory. Currently I manually ssh into the box, su to postgres user, then run pg_dump database > outfile. This…
nulltek
  • 1,251
  • 3
  • 14
  • 22
3
votes
1 answer

postgresql - Approach for 'live'/hot file backup?

Forgive me for the ignorant question, but I see postgres has their WAL logs, and there are talks about using filesystem snapshots, and the WAL with the snapshots may or may not be sufficient backup/recover...I'm not traditionally a DBA/admin (I'm a…
dhartford
  • 313
  • 2
  • 12
3
votes
1 answer

Complex retention policy

I have daily database backups scp'd to a directory on a local linux machine for multiple databases. The naming format is [dbname].backup; there is no timestamp and currently the latest backup overwrites the previous. Management wants to keep old…
Jeremy Holovacs
  • 407
  • 1
  • 6
  • 22
3
votes
2 answers

Is there a debian-sys-maint equivalent in centos?

I am using debian-sys-maint as practical way to do database dumps in our debian systems, somenthing like this: mysqldump -u debian-sys-maint -p`cat /etc/mysql/debian.cnf | grep password | tail -n 1 | cut -d' ' -f3` I would like to know if there is…
aseques
  • 718
  • 4
  • 12
  • 28
3
votes
1 answer

Backup of write heavy Solr / MySQL server

I am attempting to set up an automatic backup for a server running Ubuntu. This server is used to host a couple applications which are rather write heavy and subject to a good amount of traffic. To be specific, a Solr and a MySQL database is being…
PetaPetaPeta
  • 33
  • 4
3
votes
1 answer

ssh connection operation timed out using rsync

I use rsync to backup my remote server on my local device but when I combine it with a cron job my ssh times out. Just to be clear, the data is stored on a remote server and I want it stored on my local server. The backup request must be sent from…
Mark Molina
  • 173
  • 1
  • 8
3
votes
2 answers

PGP decryption fails with error for one file

We store database backups encrypted with PGP Command Line 9.7.0. Files look like 2009.bak.pgp Here's command line used to backup these files: pgp --encrypt F:\2009.bak --recipient admin@company.mail --encrypt-to-self --input-cleanup off --temp-dir…
user135199
3
votes
2 answers

MDBDATA log folder is full, MDBDATA backup keeps failing

Our MDBDATA log folder has gotten full and it's causing users outlook to lose connection. To remedy the problem my co-worker suggested that we move old logs onto our D: drive since it's not being used. Now the D: drive is starting to get full. I've…
stick_tech
  • 31
  • 1
  • 2
3
votes
2 answers

Backing up Entire MySQL Directory

In regards to: Remounting MySQL under a new mount point What would be the best way to backup MySQL data before moving the mount point? Can this be done with MySQL running? Would a simple rsync off to another server work?
Tiffany Walker
  • 6,681
  • 14
  • 56
  • 82
3
votes
3 answers

How can I split phpmyadmin's server backup to database backups?

I have a big .sql file which i created with phpmyadmin to back up my development databases. is there any way to split this big backup into several files, each file for a separated database? the file is too big to manually deal with
yaser
  • 95
  • 2
  • 8
3
votes
1 answer

SQL Server backups - transferring between instances

I work in a development shop where we primary use SQL Server for our day-to-day development and testing. Sometimes issues occur on someone's machine, often a labtop, that I would like to reproduce on my machine. I therefore want to transfer their…
Mike Q
  • 197
  • 7
1 2
3
…
16 17