Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [backup]

Making copies of data so that the copies may be used to restore the original after a data loss event, or for historical retention.

3959 questions
27
votes
1 answer

pg_dump backup compression

When executing a pg_dump which should I use and why? pg_dump -U | gzip -c > backup.gz or pg_dump -F c -f backup.tar.gz -U
d4v3y0rk
  • 373
  • 1
  • 3
  • 8
25
votes
7 answers

Secure offsite backup, even in the case of hacker root access

I'm looking for a way to implement a more secure way of doing an offsite backup that will also protect my data against the situation where a malicious hacker has gained root access to my server. Even though the chance of that happening is smaller…
aardbol
  • 1,473
  • 4
  • 17
  • 26
25
votes
3 answers

How can I back up a table structure but NOT its data in MySQL

I am using MySQL Administrator for making my database backup. I can perfectly back up the whole database with all its tables. There are some tables whose size is very big so I wonder if I could only back up the tables' structure (only their…
user16629
25
votes
2 answers

ZFS Data Loss Scenarios

I'm looking toward building a largish ZFS Pool (150TB+), and I'd like to hear people experiences about data loss scenarios due to failed hardware, in particular, distinguishing between instances where just some data is lost vs. the whole filesystem…
Cyclone
  • 557
  • 5
  • 15
25
votes
10 answers

Can I rsync to multiple destinations using same filelist?

I'm wondering if it's possible for rsync to copy one directory to multiple remote destinations all in one go, or even in parallel. (not necessary, but would be useful.) Normally, something like the following would work just fine: $ rsync -Pav /junk…
Jessie
  • 353
  • 1
  • 3
  • 6
25
votes
5 answers

How to backup a full Centos Server?

I switched a few weeks ago from a dedicated server to a VPS. Now that everything is working well on the VPS I would like to shutdown the dedicated server and close my account with the hosting company. For peace of mind and in order to be more safe I…
benjisail
  • 1,331
  • 5
  • 19
  • 32
24
votes
2 answers

Docker volume backup and restore

I'm using Docker to deploy some services on a CentOS 6.4 server, and I'm trying to figure out how to properly backup data they generate. For example, one of the services is a web application where users can upload files. For this container, I have a…
fcoelho
  • 343
  • 1
  • 2
  • 6
24
votes
8 answers

How do I protect business critical data against fire?

We have 72 hard drives that contain our webcast inventory. The number is increasing. We're located in a frame building and we are afraid of not only fire, but catastrophic fire. I've priced fireproof safes that hold to the required 125F for hard…
Bill Knowles
  • 241
  • 1
  • 3
24
votes
11 answers

Sync LVM snapshots to backup server

I have a number of Xen virtual machines running on a number of Linux servers. These VMs store their disk images in Linux LVM volumes with device names along the lines of /dev/xenVG/SERVER001OS and so on. I'd like to take regular backups of those…
David Hicks
  • 2,288
  • 2
  • 15
  • 12
24
votes
12 answers

Using Rsync to backup to an external drive

I'm buying an external hard drive to back up the computers in my house (finally!!). I'm hoping to use rsync. I've seen an example that does (or seems to do) exactly what I want. Something like this: rsync -aE --delete…
stalepretzel
  • 834
  • 4
  • 15
  • 19
24
votes
6 answers

What happens during a live SQL Server backup?

Some of my coworkers were surprised when I told them that I can back up an SQL Server database while it's still running and wondered how that's possible. I know that SQL Server is capable of backing up a database while it is still online but I'm not…
Shane
  • 1,869
  • 4
  • 20
  • 34
23
votes
7 answers

Backup strategy for developer-focused Apple environments?

It's interesting to see the technological split between structured corporate environments and more developer-driven/startup environments. Some of the Microsoft technologies I take for granted (VSS, Folder Redirection, etc.) simply are not available…
ewwhite
  • 197,159
  • 92
  • 443
  • 809
23
votes
5 answers

How to keep: daily backups for a week, weekly for a month, monthly for a year, and yearly after that

I need to backup data and config files on this server, daily. I need to keep: daily backups for a week weekly backups for a month monthly backups for a year yearly backups after that All of this accomplished via a shell script run daily from…
Florin Andrei
  • 1,208
  • 1
  • 12
  • 18
23
votes
8 answers

How to backup virtual machines on a standalone ESXi host?

Standalone ESXi (4.1) host without any vCenter Server. How to backup virtual machines as quickly and storage-friendly as possible? I know I can access the ESXi console and use the standard Unix cp command, but this has the downfall of copying the…
Massimo
  • 70,200
  • 57
  • 200
  • 323
23
votes
4 answers

Are encrypted backups a good idea?

I'm in charge of a small set of laptops and wanted to get some sort of automated remote (over WAN) backups going; the backups would be going to a RAID drive. Because we don't really have a secure vault to hold all our drives (if someone wanted, they…
encryptbackup
  • 233
  • 1
  • 4
1 2
3
…
99 100