For production backup, MongoDB recommends mongodump instead of mongoexport for accuracy of data. However, I would need to "scrub" data off a MongoDB database before backing it up. I am not aware of ...

I would like to run the pg_dump command from a remote host off my database server that only allows fully verified certificate based connections. How should I go about doing this? The man pages for 9.1 ...

At the start of each month I have to give a team a copy of the live database which is held in a backup from 1am each morning (D:\Backup) - We then copy this database elsewhere onto a dev server and ...

I am learning oracle db, and in Oracle XE, there are autobackup and backupset directories under flash_recovery_area/XE. In both directories, there are bkp files under the datestamped directoy.
What ...

How do you backup your mysql database so you can be sure that you are 100% protected of data loss whatever problems that may happen? I am thinking to rent one or two servers that i will use only for ...

I'm relatively new to database driven sites. In order to backup a database I use phpMyAdmin's Export function from the server and download the output to my computer. That works, but it requires me to ...

I have a manual full backup happening every night, post which I am taking differential backup after every hour but after three to four differential backups a full backup happened through third party ...

This question is about MySQL Backup (or Dump) whereby i want to backup and store information from only information related to a person; SchoolA from the School Table in this example.
So, I should not ...

I have database with around 160 GB size. The database contains the data is from 2013 to until today, there are 180 tables, I want to remove the records in specific date range like 2013 to 2014 in all ...

I'm confused about tranasaction logs for SQL Server. I was under the impression they can be used to roll the database forward. For example say I made a software release on Sunday, I added three new ...

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), ...

There are several old files on an sftp of mine that date back to two years ago. These files are ingested into a MySQL database. I am wondering what to do with the old raw files. The reason I am asking ...

I am running a few restore tests on my Dev and I've noticed that the stored routines are not being restored with the innobackupx. Is that something achievable ? Am I doing something wrong ?
I am only ...

I need to establish an offsite copy of a number of production servers, including SQL server.
Hyper V replication has been chosen as a simple solution (all servers are virtual). This is to supplement ...

Currently Im running a 160G MySQL database on Xampp (Windows). But Xampp has upper limit for innodb buffer pool size of 4G. My computer has 16G RAM. So if I want to make full use of resources, should ...

I am getting the following error while restoring the Diff back up after restoring the Full backup in Norecovery mode.
I am unable use dbcc checkdb as the database in restoring db.Issues happens only ...

I have a problem: cannot backup DB2 8.1 with backup command line in Windows 2003. I think my HDD was failure (after read error showed by backup command). So, I want to copy the folder/ directory which ...

I'm backuping and restoring databases accross two sql server (v12.0.2000).
But it looks like whenever I restore a .bak file, the login I created on the database that was backuped is no more existent ...

The VMs I run SQL Server on are regularly backed up by the VMware backup tool. I would prefer not to use this backup solution but I have no choice but to cope with it.
The problem I've come up across ...