The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
2answers
1k views

PGP decryption fails with error for one file

We store database backups encrypted with PGP Command Line 9.7.0. Files look like 2009.bak.pgp Here's command line used to backup these files: pgp --encrypt F:\2009.bak --recipient admin@company.mail ...
0
votes
3answers
115 views

MySQL backup and save in external server

I have MySQL 5 installed in a Ubuntu server. I want backup the database for: latest 7 days weekly and store those backups in another server. I prefers the tool runs in the same server that host ...
0
votes
1answer
432 views

Is it possible to dump a postgresql db and restore it in mysql?

I'm trying to get migrate data from a postgre db into mysql (mariaDB) and was wondering if it is possible to restore a db in mysql from a pgsql dump?
0
votes
1answer
146 views

Backup and bz2 large mysql datefile with innobackupex in the background

I'm using the following command to backup a large running mysql database (~500GB). innobackupex --user=user --password=***** --stream=tar ./db-backup | bzip2 - > backup.tar.bz2 Since the backup ...
0
votes
3answers
490 views

How does tape backup affect production systems such as SQL Server

I am not a systems person or a DBA, and as I was reviewing a bid for a project, I started to wonder how the tape backup (LTO-5 3000) affects live production applications such as Sql Server Databases ...
3
votes
2answers
3k views

MDBDATA log folder is full, MDBDATA backup keeps failing

Our MDBDATA log folder has gotten full and it's causing users outlook to lose connection. To remedy the problem my co-worker suggested that we move old logs onto our D: drive since it's not being ...
1
vote
3answers
401 views

Good backup strategy for heterogeneous data consisting of images/databases/office files/svn repositories/

I'm looking for a simple on-site (i.e. not online) backup solution for our small company. Right now we have approximately 4TB of data in total, maybe adding ~500GB per year. The amount of data ...
0
votes
1answer
34 views

Remove Backup Configuration in SQL Server

I did a backup to a particular database and restore it in another Server. Now I want to remove that backup. But I couldn't remove it. Whenever I remove it, I got the attached error. Could you please ...
0
votes
2answers
1k views

Server failed, can I retrieve my database from the my hard disk?

I have an old server running Windows Server 2003 R2. Windows got corrupted due to an improper shutdown. I attempted to repair the Windows installation, but it made things worse (it gets to the ...
0
votes
2answers
157 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 ...
3
votes
2answers
13k views

Recover mysql database - mysql/mysqldump gives “table <database>.<tablename> doesn't exist (1146)”

Backstory Ubuntu died (wouldn't boot) and I couldn't fix it. I booted a live cd to recover the important stuff and saved it to my NAS. One of the things I backed up was /var/lib/mysql. Reinstalled ...
0
votes
1answer
394 views

Using rsync to make daily backups every 24hrs

I would like to backup /home/* /root/* and mysql databases to a set of RAIDed drives. Performance wise I want to do incremental backups. Would this be the idea? rsync -al /home ...
5
votes
1answer
531 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?
2
votes
2answers
105 views

Backing up Entire MySQL Directory

In regards to: Remounting MySQL under a new mount point What would be the best way to backup MySQL data before moving the mount point? Can this be done with MySQL running? Would a simple rsync off ...
0
votes
1answer
317 views

Can you a virtual service account access the network in workgroup

By default SQL Server Uses a virtual account for the sql server service: NT SERVICE \ MSSQLSERVER which is a Virtual Account. I know you can give this account nework access in a domain by adding ...
1
vote
1answer
312 views

Database backup with T-SQL script - Issue with Declare and Set Variables

Can someone tell me why I can't backup my database with the script below? I can run the script but it didn't create the backup. I"m using SQL Server 2008 DECLARE @pathName NVARCHAR(512) SET @pathName ...
1
vote
1answer
3k views

SQL 2008 Backups to UNC Share Failing 0xC002F210

This problem is driving me NUTS!! We take backups of all of our production databases to a network share, which are then backed up to tape nightly. 8pm Mon-Fri - Full backup, followed by log backup ...
0
votes
2answers
209 views

Differential backup of new sql database fails until full backup is made

I have setup a job that runs every night and makes a full backup of all databases on the server. During the day, another job makes differential backups every few hours. The problem comes when a new ...
2
votes
1answer
370 views

Using mongodump with an auth enabled mongodb server

I'm trying to do a daily backup of my mongodb server (auth enabled) using the mongodump tool. mongodump provides two parameters to set the credentials: -u [ --username ] arg username -p [ ...
1
vote
1answer
161 views

Minimum mysql wait_timeout?

On a hard-hit database server which ofter suffers from maximum connections being saturated, mysqltuner.pl suggests me to set wait_timeout (< 1) I am wondering whether it would be wise to ...
1
vote
1answer
2k views

SQL Server 2012 Maintenance Plan succeeds but does not perform backup

I have a new SQL Server 2012 AlwaysOn Availability Group on Windows Server 2008 R2 Ent SP1. I'm creating a Maintenance Plan on the Primary Replica which is supposed to do Full (non-copy-only) backups ...
2
votes
1answer
483 views

Postgresql 9.0.8 Physical Backup on Windows Server 2008 R2 results in “Access is denied”

I've built a script to perform a physical backup of a Postgresql 9.0.8 database by following the "Standalone hot physical database backup" recipe in the PostgreSQL 9 Administration Cookbook ...
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 ...
1
vote
1answer
1k views

How to export database from Oracle 10g

I'd like to export database with all the triggers, indexes, grants and user accounts from Oracle 10g database. Problem is I only have SYSDBA access to the server, so I can't access the servers files ...
8
votes
3answers
4k 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
437 views

MySQL in amazon AWS: backup and disaster recovery - EBS snapshots v/s RDS

I will be uploading a web application to amazon ec2 instance in the next couple of weeks. I am using : windows server 2008 r2 64 bit as an amazon instance along with a 30 GB EBS. The only confusion i ...
1
vote
3answers
384 views

Backing up data (including mysqldumps) to S3

We have a web app on a number of servers and we want to add an additional layer of redundancy by backing up the key data to S3. The key data is the MySQL database and a folder containing dynamically ...
2
votes
2answers
100 views

How to back up a database with thousands of files

I am working with a Fedora server that runs a customized software package. The server software is quite old, and its database consists of 1,723 files. The database files are constantly changing - ...
2
votes
3answers
2k views

How can I split phpmyadmin's server backup to database backups?

I have a big .sql file which i created with phpmyadmin to back up my development databases. is there any way to split this big backup into several files, each file for a separated database? the file ...
1
vote
4answers
2k views

Mysqldump causes “Too many connections”

A scheduled backup using mysqldump on one of our databases is causing Too many connections. The database is of both InnoDB and MyISAM tables with size of around 500Mb. The Too many connections appears ...
1
vote
2answers
198 views

Does Plesk 9 (CentOS) do a MySQL database dump of all databases each day? [closed]

Anybody know? At the moment I've been looking into setting up something running via CRON to do this but if Plesk already does it 'behind the scenes' then I don't want to add unnecessary tasks to the ...
0
votes
2answers
73 views

Moving database to new server

I'm restoring a backup of a production database to a new server. The new server also hosts the application which makes use of the database. As such I'd like to use the same user/pass combination to ...
1
vote
1answer
113 views

If I have Postgres streaming replication on, do I still need to archive my WAL files?

I have set up two servers running Postgres 9.1, with one configured as a hot standby for the other using streaming replication. Given that, is there any reason for me to be archiving my WAL files? ...
2
votes
1answer
630 views

Consistency of virtual machine backups using ghettoVCB

I have a ESXi host with both Windows and CentOS virtual machines running. A couple of them are running SQL Databases (MSSQL and MySQL). I am trying to setup a backup strategy using the ghettoVCB ...
2
votes
2answers
600 views

How to store 250TB of data and develop a backup/recovery plan? [closed]

I'm really new to this topic, so big apology for stupid questions. I have a school project and I want to know how to store 250TB of data with life-cycle for 18 months. It means every record is ...
0
votes
1answer
2k views

How to schedule a backup in Plesk for Database and configuration? [closed]

I like to make a scheduled backup in plesk 10.4. My target is to Take the backup of Database and configuration and put in the FTP location. I dont see any option in backup manager in plesk. Any ...
0
votes
1answer
708 views

SQL Server Agent job fails to backup to remote folder

I have created a SQL Server Agent job (in SQL 2008 R2) to back up some databases on a server. This task runs fine when the backup folder is set to a folder on that machine, but when I try to set it to ...
1
vote
1answer
81 views

Backups from MySQL slave server — Good idea or bad?

I'm have one MySQL master and two MySQL slaves set up to replicate. I'm running my database backup process, consisting of an Xtrabakup (via the perl wrapper Innobackupex) backup and an atomic ...
1
vote
5answers
534 views

Mysql large database backup

How can I backup a large database in mysql? Folder size of Database is more than 5GB & contains 1.5 Lakh tables. I have tried to backup server through phpmyadmin but no luck.
0
votes
1answer
307 views

SharePoint Sites go into read-only when SQL Server Backup is running

I have SharePoint 2007. When the database backups run using SQLCMD, SharePoint sites go into read-only. Users can't add anything to the sites and the buttons are grayed out. On the backend the ...
1
vote
1answer
280 views

Backing up SQL backups on a network share

Currently I have Maintenance Plans configured to backup SQL Server databases to local drives, then the files are picked up by Commvault nightly, and my SQL server maintenance plan deletes the backup ...
0
votes
2answers
1k views

CentOS Postgres, Backup/Restore

We recently inherited a company and their CentOS server with a Postgres running their CSR db. They have a backup system in place which we know nothing about. It creates backups of the Postgres DB in ...
2
votes
2answers
238 views

Is backing up to a NAS over private fibre link better than tape?

I have recently taken over the responsibility of a small business network of 35 users. I am a bit green on backup strategies and am considering my options. We currently backup our SBS Server to tape ...
0
votes
2answers
2k views

How to make pg_dump less resource greedy

I have configured cron to invoke pg_dump on a daily basis using following rule: # xyz database backups: 00 01 * * * root umask 077 && pg_dump --user=xyz_system xyz | gzip > ...
3
votes
1answer
130 views

SQL Server backups - transferring between instances

I work in a development shop where we primary use SQL Server for our day-to-day development and testing. Sometimes issues occur on someone's machine, often a labtop, that I would like to reproduce on ...
1
vote
1answer
194 views

Strategy to take cloud (amazon aws) backups

I need to take different type of backups(code backup, database backup, user uploaded files backup) from amazon instances, I need to make sure this backups are running properly and if any backup fails ...
0
votes
1answer
272 views

MSSQL techniques to archive-backup content

We are now moving from a MySQL to a MSSQL 2008R2 database. As the project is a web application that we need to be able to scale well, we need to rework the way the DB handles data. We have 3 separate ...
1
vote
1answer
37 views

Individual Customer Backup from Multi Customer DB

We have a multi customer database, that's about 95gb in size. One of the customers is requesting a monthly backup of their data. We have a script that strips out all records from all tables that are ...
0
votes
3answers
77 views

How to warehouse data that is not needed from MS SQL server

I have been asked to truncate a large table in MS SQL Server 2008. The data is not needed but might be needed once every two years. It will NEVER have to be changed, only viewed. The question is, ...
0
votes
1answer
77 views

Windows based Mogo database running on EC2 backups

Currently we have a windows 2008 server running a Mongo database hosted on Amazon EC2. Without looking at database replication to another database what can we do to make sure the database is getting ...