The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
0answers
9 views

Should I back up full-text catalogs?

I am developing a small app for SQL Server database backup (version > 2005). I intend to use VSS snapshots (component based) to back it up and supported modes are Full & differential. Is it ...
2
votes
1answer
953 views

How to backup/restore excluding filestream varbinary in SQL Server 2008?

There is an application used in a production site that uses SQL Server 2008 as its DBMS. The database schema uses Filestream Varbinary to save binary data on the filesystem instead of directly into ...
-1
votes
0answers
23 views

MySQL databases, phpMyAdmin, exporting and importing = CORRUPTED :(

I tried to export all of the MySQL databases using phpMyAdmin as an SQL file. After downloading it, I did an SCP of it to the new server which is a local to remote transfer. Now, when I am trying to ...
0
votes
1answer
87 views

Complex retention policy

I have daily database backups scp'd to a directory on a local linux machine for multiple databases. The naming format is [dbname].backup; there is no timestamp and currently the latest backup ...
1
vote
4answers
4k views

Backup SQL Server DB to a remote drive

I am trying to backup a SQL Server database to another drive letter located on another network on another domain. The location has already been mapped to Z:\ and corresponds to \\10.98.76.6\Backups\. ...
2
votes
2answers
115 views

Will a Veeam 8 Snapshot Backup be be unable to restore my non-quiescable file-based databases if someone is logged in to them at the time?

We have some very old file-based databases (multi-user, but not Server-based) that are running on some VMs on an VMWare ESXi. Setup HyperVisor The ESXi is running ESXi version 5.1.0 Virtual ...
0
votes
2answers
31 views

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, ...
1
vote
2answers
418 views

Ola Hallengren's SQL Backup to Network Location not working

Good Evening All, I have set up Ola Hallengren's SQL Server Maintenance Solution on several SQL Express servers (2008 to 2012 R2) in the past few years. I recently have started having issues with the ...
0
votes
0answers
23 views

Adding a VSS Writer to a proprietary MS Access Backend Database?

Is it possible to add a VSS Writer to a proprietary MS Access Backend Database (.mdb)? And do I need to add it, or is it already there? If I run vssamin list writers I get: Writer name: 'System ...
0
votes
1answer
28 views

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

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

Can I restore the “mysql” system database along with another from a mysqldump backup?

Basically, what I did is: mysqldump -uroot -pxxx <some_options> --result-file Backup.sql --databases mysql customappdb Is it sane to later do mysql -uroot -pxxx < Backup.sql Or do I ...
1
vote
3answers
536 views

Hourly database backup

I have a VPS with Kloxo control panel, I want to have database backup from one of my websites in every 2 hour. How i can do this? Kloxo doesnt support Hourly backups, only support daily, weekly and ...
1
vote
1answer
96 views

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

s3cmd: on-the-fly backup

To do backups I created a script that makes an archive of all the folders I need to backup, sends it to S3 (through s3cmd) and then deletes it after upload has been completed. I'm looking for a way ...
0
votes
0answers
62 views

Options to include with mysqldump when taking backup of hybrid databases

I'm planning on taking backups of all MySQL databases on a remote production server. The combined database size is around 2 GB. Most of the tables are InnoDB ~1.8 GB and the rest are MyISAM. Now I've ...
5
votes
1answer
470 views

MS SQL Server DB version without restoring?

Is there a way of telling which version of Microsoft SQL Server a database backup is from without restoring it?
-6
votes
1answer
61 views

Database Backup using DOS commands or any other useful commands [closed]

I am planning to backup my database files from network drive to one other. Here is my requirement: All database should be backed up excluding certain file names starting with msdb, model etc. this ...
1
vote
1answer
45 views

Postgresql: missing data after crash

I've just rebooted my server after a crash/reboot (which I haven't determined the cause of yet). Server: centos, Postgresql: 9.2.8 It looks like all my postgresql databases were reverted to the state ...
0
votes
1answer
268 views

SQL Server database backup to Windows Azure Recovery Service

I have some VMs on Windows Azure and IIS and SQL Server 2012 is installed on them. I also created a Backup Vault on Windows Azure and installed the Windows Azure Backup Agent on the VMs. It works ...
0
votes
1answer
39 views

SQL Server Backup to Azure Tool

I downloaded and tried the Microsoft SQL Server Backup to Azure tool for SQL Server 2008. My goal was to get access to the backup compression functionality built into it. I have it configured to ...
2
votes
2answers
1k views

Encrypting Amazon EBS Snapshots

Would love it if someone could help me out with this: The setup is a distributed LAMP architecture hosted on Amazon EC2 instances. MySQL Percona. We use Amazon's EBS snapshots for backups. We have ...
2
votes
2answers
400 views

simple script to backup PostgreSQL database

Hello I write simple batch script to backup postgeSQL databases, but I find one strange problem whether the pg_dump command can specify a password? There is batch script: REM script to backup ...
2
votes
3answers
8k views

Incremental/Differential MySQL Backup using mysqldump

Are there any techniques to use mysqldump (or similar command) to make incremental or differential backups for MySQL?
7
votes
1answer
4k views

Why can NT AUTHORITY\SYSTEM create SQL Server database backups?

I have a scheduled task (in Windows Task Scheduler) that connects to SQL Server using SMO (Windows Authentication) and creates a database backup. So far, this task was running under the Administrator ...
0
votes
1answer
219 views

Backup MongoDB database copying files in `dbpath`?

I need a daily backup of all MongoDB databases in our single-instance server (without stopping the MongoDB service). Our server is in Rackspace so I'm wondering if a valid strategy could be just add ...
0
votes
0answers
69 views

MySQL-ZRM: net_write_timeout

I have a backup system using MySQL-ZRM. Since I have some growing tables on a few databases and I write everything to a NFS, backups are now failing. I suspect the problem here is net_write_timeout, ...
0
votes
2answers
153 views

MySQL Backup - incremental

I know that you can use mysqldump. I am currently dumping the following way: ${MYSQLDUMP} --single-transaction -u ${MUSER} -h ${MHOST} -p${MPASS} $db | ${GZIP} -9 > $FILE From my understanding ...
0
votes
0answers
25 views

Exchange 2010 logs

Exchange 2010 sometimes doesn't delete its logs after full backup completion! Usually, we we just delete these logs (and we didn't face any problem because of that) However; is there another way to ...
0
votes
1answer
354 views

postgresql - Approach for 'live'/hot file backup?

Forgive me for the ignorant question, but I see postgres has their WAL logs, and there are talks about using filesystem snapshots, and the WAL with the snapshots may or may not be sufficient ...
1
vote
2answers
330 views

Any issues with filesystem-only backups on PostgreSQL?

I am running my DB server in amazon cloud, and I have the database files on a separate EBS volume. When it comes to backup/restore operations, I found it infinitely simpler to just do a ...
0
votes
1answer
3k views

pg_dump: [archiver (db)] connection to database failed: FATAL: Peer authentication failed for user “postgres”

I'm trying to backup my Postgres DB to another server but I keep getting denied access. my pg_hba.conf file looks like this: # DO NOT DISABLE! # If you change this first entry you will need to make ...
1
vote
0answers
197 views

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

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

Does it change anything when I disable obsolete parameters in SQL Backups? SKIP , stats, Nounload , norewind etc

I am pretty new in managing Computersystems but I always want to know everything to get out the maximum. When we last time deployed a new version of our application I was given a backup script to ...
1
vote
1answer
75 views

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

How to create a consistent backup of an application (database and files on a disk)? [closed]

I have an application where some data is stored in a database and some directly on a file system. When a user performs an operation, his action can trigger a change to a database and to some file on a ...
0
votes
2answers
211 views

Is there a debian-sys-maint equivalent in centos?

I am using debian-sys-maint as practical way to do database dumps in our debian systems, somenthing like this: mysqldump -u debian-sys-maint -p`cat /etc/mysql/debian.cnf | grep password | tail -n 1 | ...
0
votes
1answer
277 views

pg_dump fails, no space left, need to delete partial backup file to free space

Easy points. On my mac, postgres.app 9.2, I ran "pg_dump pdbt > pdbt.sql". It used up all my space and then failed with the error below. Now I want to free up the space taken up by "pdbt.sql" but I ...
8
votes
3answers
3k views

Do InnoDB tables got locked during mysqldump when mixed with MyISAM?

I'm looking for a backup solution for my mysql servers and I need as less downtime as possible. I have the following: MySQL servers they are not replicated each server stands for its own This ...
0
votes
1answer
157 views

Why does the mysql backup grow if a table is crashed?

I use this backup script on my debian squeeze server to create a backup of all mysqltables: #!/bin/sh BACKUP_DIR=/var/backups/mysql/ DATE=$(date +%Y-%m-%d) for i in /var/lib/mysql/*/; do ...
0
votes
1answer
283 views

How to run a mysqldump automated with SAFELY stored mysql credentials?

I'm looking for a way to SAFELY run daily backups using mysqldump. Safely means not storing username/password in a text file or any other unencoded format. I know there is (apparently it isn't) a way ...
3
votes
1answer
129 views

Backup of write heavy Solr / MySQL server

I am attempting to set up an automatic backup for a server running Ubuntu. This server is used to host a couple applications which are rather write heavy and subject to a good amount of traffic. To be ...
2
votes
1answer
693 views

ssh connection operation timed out using rsync

I use rsync to backup my remote server on my local device but when I combine it with a cron job my ssh times out. Just to be clear, the data is stored on a remote server and I want it stored on my ...
2
votes
1answer
241 views

LVM+MongoDB. Dropping in speed of backup creation

Till recent time we have been making mongo backups archiving LVM snapshot on hidden SECONDARY server with RAID10 on SAS disks. Currently operation on making snapshot from volume with 500 Gb of data ...
-1
votes
2answers
589 views

Postgresql pgdump script on RHEL5: “failed: fe_sendauth: no password supplieddatabase ”

What I'm trying to accomplish is having a pg_dump script run as a cron job. Right now I'm just trying to get the script to run by invoking it myself at the command line. I've searched the postgresql ...
10
votes
4answers
3k views

Should I backup and restore the `mysql` database?

In the process of creating an automated solution for backing up and restoring an entire MySQL server, I've come across the mysql database which seems to contain user accounts, permissions, metadata, ...
0
votes
3answers
282 views

mysqldump --single-transaction with dump files separated by table?

Using mysqldump, how can I create a consistent backup of a MySQL (InnoDB) database and have the dump files be separated by table? To create a consistent backup using mysqldump, I know there is ...
0
votes
2answers
1k views

No match for a database image file was found based on the source database alias “URCDB”

I used IBM Data Studio to backup a test database named URCTEST. Now, I want to restore it to the actual (empty) database, URCDB. I've got little experience with IBM DB2, so I assumed this was ...
3
votes
1answer
3k views

Is a MySQL stored procedure able to insert/update to a remote backup MySQL server?

Is it possible to create a MySQL stored procedure that can execute a given insert or update and then also have it connect to a 2nd server and run the same commands? I want to basically call one server ...