Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [database-backup]

The tag has no usage guidance.

0
votes
0answers
18 views

What is best for data recovery Software or Company if we lost our data Hard Drive Data? [closed]

I have lost my Hard drive data and I want to recover it. So what is the best for me data recovery Software or Company? I selected two choice Data Retainers -Data Recovery Company, EaseU-Data Recovery ...
1
vote
0answers
15 views

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: ...
1
vote
1answer
234 views

RDS snapshot: how long does I/O suspension occur?

As we're relying on RDS Postgresql manual backup for our backup strategy, we encountered the issue with the possible downtime of the RDS instance (single AZ) during snapshot creation. According to AWS:...
1
vote
1answer
27 views

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 ...
0
votes
2answers
35 views

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 ...
0
votes
0answers
69 views

pg_dump of schema across AWS regions

I am running a Postgres schema dump using pg_dump -s $DB_URL for a DB hosted in AWS's us-east-1. I'm running this command from us-west-2. The schema file when stored is very small (47K) but it still ...
0
votes
1answer
296 views

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 ...
0
votes
0answers
58 views

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, ...
0
votes
0answers
56 views

Restoring database from R1Soft to a different server without losing information

I would like some guidance regarding an R1Soft problem. I have a server that belonged to a client, and it had R1Soft agent installed in it, backing up information to a remote R1Soft server. In this ...
1
vote
2answers
53 views

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 ...
0
votes
1answer
124 views

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 ...
0
votes
1answer
166 views

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 ...
5
votes
1answer
2k views

Best Way to Backup ClickHouse Data

We recently started using Yandex ClickHouse for our data backend, and I'm working on figuring out how best to backup our data. There seem to be two ways of doing this. ALTER TABLE ... FREEZE ...
1
vote
1answer
1k views

Is it possible to take a snapshot of a database in Azure?

So, to clarify, I'm aware I could dump the database using tools written for the database that don't know anything about azure. I know I could do an import / export. And I know I could just extend ...
0
votes
1answer
105 views

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 ...
1
vote
3answers
425 views

Where to store db backups in centos 7? [closed]

Where should I store my db backups in Centos 7? Are there any best practice for this? Should I put them in /var/lib/<app>/backups as suggested in this answer?
0
votes
0answers
38 views

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/...
0
votes
1answer
795 views

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 ...
3
votes
1answer
294 views

Is there a (mostly) safe way to backup live MySQL databases using zfs snapshots

Basically what I'm looking for is a way to tell mysql (percona-flavored) to take the following steps: Flush all committed transactions to the filesystem Start buffering all transactions (keep the ...
3
votes
1answer
876 views

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 ...
1
vote
1answer
406 views

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 ...
1
vote
2answers
5k views

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" ...
0
votes
1answer
115 views

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 ...
5
votes
2answers
2k views

Cassandra snapshot restoring : random missing data

I'm having a hard time restoring snapshot on Apache Cassandra (version 3.0.9). As far as I can say, I'm following the procedure described on datastax blog, along with several other ones (for instance :...
1
vote
1answer
421 views

Backing up PostgreSQL - being prompted for password

OS: Ubuntu Xenial 16.04 LTS PostgreSQL Version: 9.5.4 I am trying to set up automatic database backups on my server, and every time I run pg_dump, it tells me that no password was supplied. Here's ...
3
votes
1answer
187 views

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 ...
0
votes
1answer
45 views

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 ...
0
votes
1answer
218 views

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-...
0
votes
0answers
129 views

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 ...
4
votes
2answers
2k views

How to do offsite AWS RDS PostgreSQL backups?

As a measure to mitigate against catastrophes such as a malicious entity gaining full access to our AWS account and deleting everything, I am in the process of setting up offsite backups for our ...
0
votes
1answer
234 views

bacula catalog backup error

I have a Bacula (mysql) server on an Ubuntu-server machine. It backs up and restore without issues except for the catalog. Every time it runs the catalog backup it shows an error. My guess is that ...
3
votes
2answers
311 views

Configured Azure Backup sends me a health check report every 15 minutes

I configured my SQL Server 2014 database to back up to an Azure storage account. I also enabled email notifications via EXEC msdb.smart_admin.sp_set_parameter @parameter_name = '...
0
votes
4answers
254 views

How do I perform an Exchange 2010 database backup using Windows Server Backup with Hyper-V VMs collocated on the same drive?

Yeah... I'm not the one who set it up. I've been tasked with setting up backups for their Exchange data. I've read through the documentation and learned about all the caveats that come with using the ...
0
votes
0answers
229 views

SQL Server Management Studio 2012 DB Backup script

I have SQL Server Management Studio 2012 installed on a VM. We have an active DB (attached to an ASP.Net application whose target Framework is 4.0). What I was looking for is a script to backup a DB ...
2
votes
2answers
555 views

What is the risk of a SQL Server backup strategy that is only weekly full backups and daily transaction log backups?

I'm trying to convince a client that their SQL Server backup strategy is insufficient. Long story short is that their current backup "strategy" is a weekly full backup followed by daily transaction ...
2
votes
1answer
2k views

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 ...
0
votes
2answers
2k views

Backup remote database using mysqldump

I am trying to achieve a quick way to do a backup and download a remote mysql database to my local machine, using just the terminal. The remote server uses ssh keys for authentication. I can do it by ...
-1
votes
4answers
1k views

How to mysqldump last 10 rows for EVERY TABLE in a database?

I have seen a lot of articles about "how to mysqldump last 'n' rows from a table in a database". For example: mysqldump --user=superman --password=batman --host=gothamcity.rds.com --where="1=1 ...
0
votes
1answer
96 views

Lock a specific mysql database in shared mysql database

I am trying to migrate a database from one cluster to another cluster. In order to avoid any data loss during the migration, I am trying to lock my database with the WRITE operations. But the lock ...
0
votes
2answers
217 views

Connect by mysqldump to a mysql server only allowing one ip

I have a cloud server with MySQL in it. In this moment, i can't connect from my pc to the server using any of the users. What it want is allow to use mysqldump with an specific user and only allow ...
0
votes
2answers
59 views

Start an uninstalled MySQL server

Our server just crashed after a 140 day uptime reboot (not booting). It was running Plesk and since it's hosted by Online.net, I'm able to run a recovery system and access my data. It was running a ...
4
votes
2answers
552 views

pg_dump compression; Server or Client side

When you are specifying compression on pg_dump, is the compression happening on the server side so that the transfer is quicker or is the pg_dump doing the compression? Thank you
2
votes
1answer
85 views

How to secure the db dump taken from daily run script

In one of my mysql slave servers I have written a daily run script, which 1) stops slave, 2) takes a db dump, 3) starts slave again, 4) encrypts it, 5) copies it to my s3-bucket. I am using aws-cli ...
1
vote
4answers
384 views

reliably write database dump directly to remote filesystem (Linux)

I need to move a very large database (~320 GB) from server1 to server2 (Linux). Because of different extension versions, the database can only be restored on server2 from a dump file as described here....
2
votes
2answers
273 views

Database backup encryption

I've been trying to work out an effective database backup encryption scheme lately. I have a Postgres 9.4 server, I have most of the backup scheme fleshed out I think. Backups will be stored in a ...
1
vote
0answers
135 views

MongoDB fsyncUnlock won't unlock occasionally on Windows

We have a MongoDB replica set installed on Windows servers, with a scheduled backup job. MongoDB is configured to use journaling. The job runs db.fsyncLock() via script on MongoDB (primary server), ...
0
votes
0answers
4k views

Error during Veeam SQL log backup: “Failed to flush file buffers”

My company uses Veeam Backup & Replication to make backups of our VMWare-hosted virtual machines. We use Veeam's SQL log backup feature for our MS SQL 2008 R2 server. Our backup repository resides ...
1
vote
0answers
186 views

What are the limitations of using a scheduled Windows Server Backup instead of SQL Server backups?

We've taken over development and server admin for an e-commerce site, and the client has opted for a well-specced dedicated server, including a second drive for daily Windows Server Backups. However ...
2
votes
2answers
6k views

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 ...
0
votes
0answers
67 views

Fallback to backup server upon failure of main server without third machine

I will soon need to setup a database server on a budget. We are planning to use Postgres on Ubuntu (most likely) and we'd like to have a backup server. For replication, I think I'll just use Postgres'...