Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-backup]

251 questions
1
vote
1 answer

Backing up a mirrored SQL environment

I have 2 SQL servers in Mirror configuration. I want to backup these servers but backing up the SQL databases in Mirror state causes an error. These two mirrors also have a witness set. I would like to know how do I create full daily backups from…
Yaron
  • 211
  • 3
  • 10
1
vote
2 answers

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 --single-transaction To create separate dump files, I…
user156845
  • 11
  • 2
1
vote
3 answers

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 changing per day is much less tough - I guess much less…
Onur
  • 119
  • 3
1
vote
3 answers

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 monthly. configuration:…
Fcoder
  • 341
  • 1
  • 4
  • 8
1
vote
1 answer

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 = 'C:\Backup\MyBackup.bak' ... EXEC…
Mr.X
  • 11
  • 2
1
vote
2 answers

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 database is created. The differential backup job…
Sir Code-A-Lot
  • 113
  • 4
1
vote
1 answer

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 follow the suggestion and set the value to a fraction of 1…
alfish
  • 3,127
  • 15
  • 47
  • 71
1
vote
1 answer

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 or ssh to it. Also, I can't shutdown the database.…
JukkaA
  • 13
  • 4
1
vote
3 answers

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 created site assets - predominantly images. Some…
robjmills
  • 990
  • 9
  • 26
1
vote
2 answers

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

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 server.
BeesonBison
  • 177
  • 7
1
vote
1 answer

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? I'm aware that the archived WAL files allow me to…
Dave Duchene
  • 13
  • 3
1
vote
1 answer

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 mysqldump, off one of the slaves. This morning, I…
CamelBlues
  • 303
  • 4
  • 10
1
vote
5 answers

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.
user103373
  • 198
  • 6
  • 19
1
vote
1 answer

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 files after they are a few weeks old. I don't…
Benjamin Bryan
  • 197
  • 1
  • 9
1
vote
2 answers

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 I need to get mail (failure is may be because of…
Sandeep Manne
  • 111
  • 3
1 2 3
…
16 17