The database-backup tag has no wiki summary.
0
votes
0answers
23 views
SQL Server 2012 backup Maintence plan per dataabse
I am using Ola's maintenance solution. New Senior DBA wants me to use native maintenance plans for user database backups. One maintenance plan per database. So on one server it would be 20 backup ...
1
vote
0answers
30 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
2answers
71 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 ...
0
votes
0answers
23 views
Backup a database from IIS database manager
According to this article it should be possible to backup remote database with IIS Database Manager. I managed to connect to my remote site and the database, I see tables and data, but I can't ...
0
votes
1answer
22 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 ...
-1
votes
1answer
76 views
How Log shipping works on secndary Oracle DB [closed]
We are located here in Canada and have an Oracle system in Europe which we are looking to prepare a DR system. The ideal is to have the DR system here in head office (Canada) but question would be ...
1
vote
2answers
32 views
How to avoid restoring deleted user accounts when recovering from backup?
Typically in websites, when a user wants to permanently delete his/her account, is necessary to remove this account also from the backups to avoid unwanted reactivations in case of backup restoration?
...
1
vote
1answer
38 views
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 ...
0
votes
3answers
117 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 ...
2
votes
2answers
164 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
90 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
50 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
0answers
25 views
Non-root user backup MySQL databases as cron job [duplicate]
Possible Duplicate:
How do I create a read only MySQL user for backup purposes with mysqldump?
I have seen different scripts to dump MySQL databases on a per user basis, but I need some ...
0
votes
0answers
23 views
Microsoft Dynamics CRM Hosted Granular Backup [closed]
We are starting to implement a hosted Dynamics CRM system for our company and our independent dealerships.
The dealers will be sharing a database with us so I have been tasked with finding a backup ...
0
votes
1answer
45 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
128 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 ...
1
vote
2answers
366 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
142 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
29 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
85 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 ...
1
vote
2answers
98 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
0answers
122 views
How dump PostgreSQL database to MS SQL Server 2012? [closed]
i have a database on PostgresSQL trying to do a backup with pgadmin to restore it on MS SQL Server 2012, is there a way to do that?
thanks
0
votes
2answers
94 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 ...
2
votes
2answers
908 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
181 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 ...
4
votes
1answer
215 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
68 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
63 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
106 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
390 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
104 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
119 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
86 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 ...
0
votes
1answer
329 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
112 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
305 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
559 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 ...
7
votes
3answers
784 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 it's own
This ...
0
votes
1answer
222 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 ...
0
votes
3answers
203 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
89 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
329 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
522 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
141 views
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 ...
0
votes
2answers
60 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
87 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?
...
1
vote
1answer
298 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 ...
-6
votes
2answers
1k 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
271 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
788 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
...
