Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-backup]

251 questions
1
vote
1 answer

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 the command I'm using to test: pg_dump --host…
Alexander
  • 184
  • 2
  • 11
1
vote
4 answers

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. The problem is I don't have enough space on…
kontextify
  • 189
  • 1
  • 10
1
vote
0 answers

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), then performs a Kaminario file-system snapshot,…
Danny
  • 121
  • 6
1
vote
1 answer

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 on a Buffalo TeraStation TS-XLBF NAS. At some point,…
waldrumpus
  • 117
  • 1
  • 9
1
vote
0 answers

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 currently the server just has SQL Server Express,…
andrewb
  • 151
  • 8
1
vote
0 answers

MongoDB Backup & purge

I'm exploring solutions for a basic dbadmin need : periodically backing up and purging data in MongoDB. Basically, I need a logrotate for mongodb. I have a backend program filling a collection. I deliberately didn't implement a backup and purge…
Cyril CHAPON
  • 109
  • 5
1
vote
2 answers

restore mongoDB databases from manual backup (not used mongodump): strange permission problems

Is it possible to restore databases which were manually copied from /var/lib/mongodb to eg. /home/foo/mongobackup ? I am not sure if the backup was made after stopping the mongod service. Either way, no files were written to the database when doing…
nylki
  • 203
  • 2
  • 9
1
vote
2 answers

How to use fsyncLock() safely in backing up a single mongod

I read in MongoDB's official documentation: important: db.fsyncLock() may block reads, including those necessary to verify authentication warning: When calling db.fsyncLock(), ensure that the connection is kept open to allow a subsequent call…
Luke Nguyen
  • 111
  • 2
  • 7
1
vote
0 answers

autopostgresqlbackup postgres authentication error

I am trying to use autopostgresqlbackup on ubuntu on an ec2 instance. I can log in with psql on the command line and it is picking up my .pgpass file and everything looks fine. When I run 'sudo autopostgresqlbackup' it just hangs and my error file…
Stephen Burke
  • 111
  • 2
1
vote
1 answer

Redhat wal-e installation

I am trying to get https://github.com/wal-e/wal-e installed on a Redhat system. I have been using the pip method to do the installations. I believe I installed all required dependencies and it's still throwing the distribution not found error. See…
Jacob Waller
  • 135
  • 5
1
vote
1 answer

Backup Mongodb on EC2 through EBS snapshots - timing issue

I'm following this guidance http://docs.mongodb.org/ecosystem/tutorial/backup-and-restore-mongodb-on-amazon-ec2/ I have 4 EBS 1000 IOPS volumes assigned to instance. These 4 volumes through MDADM assembled into software RAID10 array. I want to do…
DmitrySemenov
  • 835
  • 2
  • 15
  • 27
1
vote
0 answers

Backup RHEL 5 Web Server Disk and DB Data to USB Drive, Best Way to do this?

We are using a dedicated web server with Redhat Enterprise Linux 5 installed, we are using this to host a couple of our websites. We asked our host to attach an external USB hard drive to our server so we could make a backup copy of our current…
officeboi101
  • 121
  • 1
  • 3
  • 5
1
vote
1 answer

Backup slowness after changing the SAN switch

We have a netbackup environment Recently we changed the connectivity of two of our sql servers(cluster servers) from one SAN switch(MDS 9509) to another (MDS 9513) followed by which we are experiencing longer backup times for these servers. The…
user200794
  • 11
  • 2
1
vote
1 answer

Import SQL Dump from Command Line

I have an SQL Backup that has hundreds of individual databases inside of it. The backup is around 70GB in size and I have spent countless hours attempting to restore it on a new machine due to the previous one becoming corrupted. I am currently…
Aidan Knight
  • 650
  • 3
  • 11
  • 19
1
vote
2 answers

How to avoid restoring deleted user accounts when recovering from backup?

Typically in websites, when a user wants to permanently delete his/her account, is necessary to remove this account also from the backups to avoid unwanted reactivations in case of backup restoration?
ramirecio23
  • 21
  • 2
1 2 3
…
16 17