Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-backup]

251 questions
0
votes
4 answers

Inexpensive Hardware for Database Backups?

What hardware would you recommend for saving database backups with the following setup: 5 separate physical hosts, each with one Sql Server 2008 database. Each instance is larger than 200Gb. Each database does one full backup per day, and…
Eric Z Beard
  • 503
  • 1
  • 6
  • 12
0
votes
0 answers

How do I manage the backup process for a VPS?

I have a platform that I would like to offer for my client. It is a SaaS platform in which I need to host it. It sounds like VPS is one way to go but I never owned/managed a VPS so not sure how to manage it. I am looking at a Windows VPS from…
Junior
  • 171
  • 2
  • 11
0
votes
2 answers

schedule backup job runs up to 9 hrs without errors

I'm very new to administration job... I have SQL server 2012, on that my senior scheduled a job for schedule backup. But, recently I noticed, after 8-May-2018(up to 26-May-2018) the backup files are missing. Then I realize that, the schedule job …
Pugal
  • 103
  • 3
0
votes
1 answer

MongoDB - Efficient backup

I have an application running on a Parse Server and another server where MongoDB runs. Both VMs are under Azure (Ubuntu VMs). A few weeks back, I wrote a db backup bash script which is run by crontab once a day, every day. Here's the…
Sotiris Kaniras
  • 198
  • 2
  • 10
0
votes
0 answers

How to make daily database backups readily queryable

We have a production database that generates daily database backups that are uploaded to S3 in form of compressed .sql.bz2 files. We basically have a S3 bucket that has a large number of such backups, one per day. We use these DB backups for…
rtindru
  • 101
  • 3
0
votes
1 answer

What is a good way to backup SQL Server DB's from multiple AWS EC2 instances to a single AWS EBS Volume or S3 Bucket?

I have about 30 AWS instances, each running SQL Server. I want to back them up onto an AWS EBS Volume or S3 bucket - using a free solution. I was thinking of creating a large volume and mapping each of the instances to it, to backup directly onto…
Techboy
  • 1,550
  • 7
  • 31
  • 49
0
votes
1 answer

MySQL Table Checksum - Before or after MySQL dump?

The company I'm currently working for has a script that runs at night that takes a MySQL dump of the production environment and imports it into the staging environment. This is a very basic setup - No replication, no fancy backup or migration…
Justin
  • 137
  • 2
  • 9
0
votes
1 answer

Backing up RavenDB - is it safe to backup data directory without VSS?

The documentation for RavenDB basically indicates there are several ways of backing up your RavenDB database: Using the supplied Raven.Backup.exe tool Initiating an export from the "studio" web interface Using the client API Using VSS…
eddiewould
  • 131
  • 6
0
votes
0 answers

Migrating MariaDB cannot find files anymore

I had to reset my dedicated server, so i backuped the whole /var/lib/mysql directory (stored in OVH Backup Storage). Today on my clean dedicated, i reinstalled mariadb and so putted the whole /var/lib/mysql directory of the backup into…
user406214
0
votes
1 answer

Will running mysqldump on one Percona XtraDB cluster node affect performance on the others?

I have a Percona XtraDB cluster with 3 nodes. Only one of these nodes is connected to by the application that uses the database. I would like to perform 'hot backups' simply using mysqldump on one of the nodes that doesn't serve the application by…
rgvcorley
  • 133
  • 6
0
votes
3 answers

Adding mysqldump parameters in automysql

Please excuse any formatting or grammatical errors. I am currently using automysqlbackup to take local backups of my mySQL database. I recently started to having problems that is connected to that automysqlbackup (or in fact mysqldump) does lock the…
Orphans
  • 1,396
  • 2
  • 18
  • 30
0
votes
3 answers

Amanda/Zmanda backup-recovery Local server

I am trying to recover some files from a tape on Linux, that were placed on there through an amdump. The problem is in order to use amrecover you have to set up the server. Which I do not really know how to do. Is there a walk around? or perhaps an…
A.Martinez
  • 43
  • 3
0
votes
2 answers

taking database back up of SQL Server 2005

I have a requirement where I need to take the backup of database. Once the user clicks the button I need back up the entire database to the location c:/backup Database: SQL Server 2005. Thank you
prince23
0
votes
1 answer

AutoMySQLBackup: Create a single file for each database

I'm backupping my databases with automysqlbackup. This works fine - but unfortunately I do not get a single file for each database but a cumulative file called daily_all-databases_2016-04-15_12h01m_Friday.sql.gz . ├── daily │   └──…
MyFault
  • 913
  • 3
  • 15
  • 36
0
votes
0 answers

Backing Up Multiple SQL Databases to Network Share at the Same Time

Junior SysAdmin/accidental DBA here so apologies in advance for the noob question. The previous DBA here had a SQL Backup Maintenance Plan that he would copy across 20+ database servers and have all of the full backups kick off at 10pm. All of these…
davszur
  • 1
1 2 3
…
16 17