7
votes
1answer
655 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
52 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
1answer
88 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
0answers
44 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 ...
0
votes
0answers
31 views

Database and Source Code auto back up

We have more have more than ten server(windows 2003 ) system . Each server have more than three web sites. I had create the sql job to auto back up process. Then copy the back up files into external ...
1
vote
1answer
33 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
55 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 ...
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 ...
3
votes
1answer
91 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
251 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
142 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 ...
0
votes
1answer
23 views

Not Backing Up Files That Don't Change In A WordPress Install

I have a WordPress install and I'm wonder what is generally best practice when it comes to back up. I'm asking here instead of WordPress.stackexchange as this question is not only a WordPress question ...
2
votes
2answers
518 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
103 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 ...
1
vote
3answers
229 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
33 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 ...
1
vote
2answers
269 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 ...
0
votes
2answers
132 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
1answer
247 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 ...
2
votes
2answers
85 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
2answers
140 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
211 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
3answers
319 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
1answer
465 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 ...
-5
votes
2answers
2k views

Possible to just “copy” Active Directory database and files for a backup?

I know it's possible to use system state, but I do not want to do a full system backup... I want to backup AD and that's it. Would stopping all AD services, then backing up all NTDS files be ...
2
votes
2answers
401 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
1k views

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

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
475 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
186 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 ...
2
votes
2answers
233 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 ...
1
vote
1answer
189 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 ...
1
vote
3answers
1k views

How can I delete SQL Server differential and log backups earlier than the earliest full backup still on disk?

When I delete a full backup, I would like to delete all the files that are rendered useless once that full backup has been deleted: specifically, the differential and log backups that occur before the ...
0
votes
1answer
2k views

Auto backup mysql database in phpmyadmin

Can i backup the mysql database automatically every week like scheduled job in local Phpmyadmin. if possible i would like to take the each database separate file.Is this possible ! Thanks
3
votes
2answers
337 views

Duplicating an ESXi host to another ESXi host as a backup solution

I have an ESXi host with the following virtual machines: 1 x Active Directory Server 1 x Remote Desktop Services Server 1 x SQL Database Server 1 x Accounting Software Application Server I have a ...
10
votes
4answers
2k 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, ...
12
votes
6answers
1k views

Downtimeless MySQL backups on a budget

My current MySQL backup scenario is to replicate our db to a second server and run mysqldump on that server to remove any downtime from table or row locking. This is working well but costs $150 per ...
0
votes
2answers
289 views

Keeping two servers in sync - secondary server only to be booted for the backup, or in outage

I've just started a new Software Development job but I've basically been given loads of sysadmin stuff to do because the development team consists of only 2 people + the CTO. I've got pretty much zero ...
0
votes
4answers
399 views

Mysql Backup Solution

I would like to backup my mysql server remotely. I have three problems, and one requirement. I do not have enough space in my server. I can only keep one copy of backup in the local server I do ...
3
votes
3answers
649 views

SQL Server transaction log BACKUPS are very large

In SQL Server 2008 R2 I have a database that has full backups nightly and transaction log backups every ten minutes. The database is in full recovery model. The problem is that the backup files for ...
1
vote
1answer
320 views

will mysqldump lockout select or read only based queries

i have a large database to backup nightly and we currently do mysqldump on the master server which locks all inserts when dumping we use a master slave mysql setup with magento configured to send all ...
11
votes
3answers
914 views

Is this a valid backup strategy for MongoDB?

I've got a single dedicated server with a MongoDB database of around 10GB. I need to do daily backups, but I can't have downtime with the database. Is it possible to use a replica set on a single disk ...
0
votes
1answer
86 views

MySQL database backups to a local server

We have a backup system at the moment, but after a recent scare, we’d like another backup of just the MySQL databases, nightly, to a local server in our office. The databases are pretty big as it ...
4
votes
2answers
563 views

Rackspace cloudserver backup options

I recently signed up with Rackspace to host some database servers. I've got two MySQL servers set up, and have a method to create backups (using the Percona Xtrabackup and innobackupex tools). I've ...
6
votes
3answers
1k views

Creating a *Consistent* *Online* MySQL Backup with InnoDB AND MyISAM tables

I just spent hours building a new database server to replace 2 failed servers from a mysqldump file created a month ago, then used my server's bin-logs to bring that mysqldump up to date. Now that I ...
0
votes
1answer
207 views

How Gmail and other Mailservice providers must be taking there DB Backups? [closed]

Being Anxious, I thought of asking this question in SO, which will certainly help in getting an idea for how the big DB carriers take their backups. How Gmail and other Mailservice providers must be ...
-2
votes
0answers
23 views

DB Backup on Client when Hoster does not answer emails [closed]

I have got a strange situation where my website hoster does not answer support tickets any more. What I am trying to do is to do a full backup of my hosted sql db. I can access the db alright. ...
1
vote
2answers
129 views

Frequency of SQL Server full backups vs. diffs

I have a SQL Server located in a colo center. Currently, our database is about 100Gb. Log files average about 500Mb/day, and differential backups grow by a bit less than that. My current disaster ...
2
votes
1answer
286 views

SQL Server on EC2: What way do i set up the EBS

Good morning. We have a service with a SQL box on Amazon EC2 and, as suggested on this question, we are using EBS to store the data... the problem is, What is the best way to setup the storage? At ...
7
votes
2answers
8k views

How do I create a read only MySQL user for backup purposes with mysqldump?

I'm using the automysqlbackup script to dump my mysql databases, but I want to have a read-only user to do this with so that I'm not storing my root database password in a plaintext file. I've ...
1
vote
1answer
709 views

Best open source Server backup utility with GUI?

I am looking for an open source/free server backup app with GUI (web based front end). Which app do you recommend? I search a little and came up with this list: 21 of the Best Free Linux Backup ...