Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-backup]

251 questions
2
votes
1 answer

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 7am-7pm Mon-Fri, at half-hour interval - Log…
Matty Brown
  • 675
  • 3
  • 13
  • 24
2
votes
1 answer

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 [ --password ] arg password Unfortunately they don't…
bb-generation
  • 163
  • 1
  • 5
2
votes
2 answers

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 of the only User database. The task is…
Sheree
  • 51
  • 1
  • 4
2
votes
1 answer

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 (Riggs/Krosing), but I adapted it for Windows Server 2008…
sevzas
  • 233
  • 3
  • 11
2
votes
2 answers

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 a security requirement for encryption of sensitive…
d.howser
  • 21
  • 3
2
votes
2 answers

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 - they continually grow and changes are not…
Neal
  • 23
  • 2
2
votes
4 answers

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 for about 2-3 minutes We understand that…
vbachev
  • 23
  • 1
  • 3
2
votes
1 answer

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 script, I have successfully executed the backups and…
drcelus
  • 1,254
  • 4
  • 14
  • 28
2
votes
2 answers

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

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 stored for 18 months and after this period of time can…
luccio
  • 123
  • 4
2
votes
2 answers

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 (LTO 2). In addition, separately, we backup an SQL…
iWeasel
  • 161
  • 8
2
votes
3 answers

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 earliest full backup that is still on disk. Does…
Mark Freeman
  • 131
  • 1
  • 3
2
votes
1 answer

Cleanup Backup Files without xp_cmdshell or maintenance plans

Background: We've got a backup script which needs xp_cmdshell to run. I decided that on new servers, we are not going to enable xp_cmdshell. I enabled xp_cmdshell when the job starts and turn it off at the end. The problem is that if a full…
Sam
  • 2,020
  • 1
  • 16
  • 22
2
votes
2 answers

Oracle RAC failover backup procedure

We have Oracle 11gR2 RAC database on two nodes. We also have a RMAN backup script that works fine, using a recovery catalog database which is located in a town 20km from the data center. The script for database backup works fine, and is started from…
Predrag Simović
  • 21
  • 1
2
votes
1 answer

Full, Differential and Log backups of databases, MSSQL an MYSQL

Best I give a back story so you get the full picture. I am in the process of setting up a new business, which hopefully will start in April 2012, and as such I am preparing every aspect of it. One part of the business will be web hosting. I am quite…
Anthony
  • 367
  • 1
  • 4
  • 14
2
votes
4 answers

Transferring PostgreSQL Database Between Servers

Is it possible to directly transfer a PostgreSQL database between two PostgreSQL servers? I've currently been setting up a "development" version of my production database by using pg_dump to serialize the entire database to a file, download the…
Cerin
  • 3,600
  • 19
  • 61
  • 79
1 2 3
…
16 17