Making copies of data which may be restored after a data loss event or to recover data from some earlier point in time.

learn more… | top users | synonyms

3
votes
0answers
43 views

Restoring differential backup creates DEFUNCT log file?

Here is my problem. I'm trying to move a database to a new server via a full restore, then cutover with a quick differential backup/restore. I can do a full restore without a problem, but when ...
0
votes
1answer
66 views

Problem with mysqldump and view

When using mysqldump to backup MySQL, I got following error. mysqldump --all-databases --routines >> all.sql mysqldump: Couldn't execute 'show table status like 'hdkien'': SELECT command denied ...
3
votes
1answer
30 views

Do I need to stop the service to back up the database? [on hold]

OK. Noob alert here :) We have several database driven applications using MS SQL Express, Pervasive, MySQL, and some sort of flat file database. PostgreSQL "may" be added later. We have backup ...
0
votes
1answer
30 views

Slow performance of remote restore

Over the weekend, I was participating in a DR test. On the database side, that meant restoring backups from the production system to the DR system. What struck me as odd about the performance of the ...
2
votes
1answer
26 views

Recovering a partial PostgreSQL archive

I have $PGDATA/base but nothing else. It was taken from an installation after the postgreSQL service was shutdown, so is clean. Is there any way to recreate the other elements in $PGDATA that allow ...
0
votes
0answers
17 views

help me restore a database

I have a database backup that I'm trying to load so that I can extract some historical averages. I think it was a MySQL database, but with some syntax adjustments I was able to create the one and only ...
1
vote
1answer
30 views

changing auto shrink setting breaks backup?

I have a database that seems to be functioning fine with no apparent errors except that any full backup taken is broken - attempting a restore fails with an error "RESTORE detected an error on page ...
5
votes
4answers
159 views

Only do log backup if necessary in SQL Server

We have transaction log backups taken every few minutes from many databases. Is there a way to determine if there were any committed transactions since the last backup and only then do a log backup? ...
0
votes
1answer
70 views

Restoring a SQL Server 2008 R2 backup on SQL Server 2005

I'm getting an error whenever I restore a testing database on SQL Server 2005 that was backed up from SQL Server 2008 R2. It seems that I cannot restore from a higher version of sql onto lower ...
1
vote
1answer
55 views

What synchronizes two delayed replicas, which is part of the replica set, included in sharded cluster?

Please take a look at my mongodb map at http://postimg.org/image/krzvmep4d/ What synchronizes two delayed replicas, which is part of the replica set, included in sharded cluster? How can I use my ...
0
votes
0answers
10 views

specify database while executing mysql binlog

We have different mysql servers with same database names, is it possible to restore their binlogs into one server (different database names) ?
2
votes
1answer
29 views

Database Backup from 2008 R2, Restore on 2012 Failover Cluster Instance

I have a production database server having sql server 2008r2. This is an old server and considering our load, we are moving to a better hardware configuration, Now the new environment is a cluster ...
-2
votes
0answers
31 views

log shipping backup job getting failed frequently

Even i am facing similar issue some of the log backups are getting failed for the same reason stated above the first possibility that came to my mind was the same it could have been a network issue or ...
0
votes
1answer
49 views

Postgresql create database from backup programmaticly [closed]

I got a big problems here. Let's say I got the table A (with columns like id, name etc) in the main database. So when I making INSERT into A I need to create new database lets say B_id. I got .backup ...
0
votes
0answers
33 views

Quick MySQL Backup (1 file per table) - v2

Improving bash shell script written by RolandoMySQLDBA. Continuing the following thread: Quick MySQL Backup (1 file per table) I tried to adapt your script, but after the first rsync was done, I get ...
0
votes
1answer
41 views

What is best strategy for backup on streaming replication(hot standby) environment

I have questions. What is best strategy for backup on streaming replication(hot standby) environment. I’d like to do backup on slave server and restore(PITR). First, I set up streaming ...
0
votes
0answers
68 views

Why has the backup time significantly increased?

I'm using Sql Server 2012. The problem is that the backup takes about twenty minutes now, whereas only a few days ago it took a matter of seconds. The database has increased by about a sixth since ...
3
votes
2answers
155 views

Does a MyISAM table locks if I copy it while MySQL is running? (READ DISCLAIMER)

DISCLAIMER: I'm very aware this is not supposed to be done, but time consistency between tables aren't a concert here and Im trying whatever pops in my mind right now to have alternatives for ...
4
votes
1answer
58 views

Understanding Backup Types

I have recently started a role as a junior DBA... Yesterday I created a new database for a co-worker and my boss asked me to make sure we get a backup plan on it asap. I didn't think much about it, ...
1
vote
0answers
46 views

Get postgres snapshot from Amazon RDS

I can not find a simple way to get a copy of the nightly backup I take of my Amazon RDS postgres instance so I can restore it on my local machine to play with. Right now I'm doing a pg_dump when I ...
1
vote
0answers
17 views

Mysqldump --flush-logs results in small backup files?

New to MySQL and just learning how to setup a daily full backup (binary logs enabled). My goal is to run a daily full backup of the databases/schemas and reset the binary log. I'm currently using an ...
-2
votes
4answers
119 views

how to restore .bkp file in SQL Server [closed]

I have a .bkp file, how can I restore it to SQL Server? I have SQL Server 2008 and SQL Server 2012. Any idea?
1
vote
3answers
57 views

Is bulk-logged recovery model ever a good choice if point-in-time restore is not needed?

Is the Bulk-Logged recovery model in SQL Server ever preferable to Simple if point-in-time restore is never needed? I have read many articles about transaction log models, but cannot find a clear ...
3
votes
1answer
39 views

How dependent are backups on msdb tables like backupset?

I am trying to get some practice making a backup maintenance plan and restoring those backups. I have a script that churns through the most recent full database backup and any subsequent transaction ...
0
votes
1answer
50 views

Postgres Point-In-Time Recovery with a limited point in time

I'm configuring PostgreSQL WAL-based backup for point-in-time recovery. Actually, I don't really need any point in time beyond 1 month ago and don't want to waste time for the logs older than that. ...
1
vote
2answers
48 views

Backing up my SQL Server System Databases

I'm trying to create a recurring scheduled job to fully backup the master, msdb and model databases, I'm using the Maintenance Plans for SQL Server 2008 R2, in the "Specific Databases to choose from ...
0
votes
0answers
25 views

How to write a simple application for copying a MySQL database for periodical backup

I want to use MySQL for my Java application as a database engine. I have two different applications that must be run on two separate computer networks. The first program saves the data in the ...
1
vote
1answer
37 views

Backups in Availability Groups

In case of async commit setup and the backup preference set to secondary replica. I have observed, in case of high unsent log size, log backup on secondary replica starts failing for that database ...
1
vote
0answers
72 views

What's is the best way to get incremental changes from production to incrementally changed development database?

I came to a new dev team where all development is on the same (instance) of an SQL Server (2005) database once in 1-2 days restored from a current full backup of production database replacing a dev ...
0
votes
0answers
59 views

How to recover a crashed MyISAM table which myisamchk couldn't recover?

We take db backup by stopping the database and then issuing a tar -zcf on the mysql data directory. When we restore the data directory on another machine and try to start the slave, the mysql error ...
1
vote
1answer
26 views

Restoring backup from mysqldump does not remove additions

I am restoring a backup from a mysqldump and noticing that if I made additions (in the form of new tables) to the database they persist after the restore. I can go back in and remove those tables to ...
1
vote
1answer
31 views

Backup Database (SQL 2000 Compatibility) on SQL Server 2005 with CHECKSUM, but Page Verification TORN_PAGES Detection

I am trying to backup a 250GB database on SQL Server 2005 running in SQL 2000 compatibility mode. The page verification is set to TORN_PAGES detection. So, far the backup has been corrupted when we ...
1
vote
1answer
37 views

Create database before restore multiple files

I've several database, most of them have multiple files (both data and logs) and multiple diff and trn backups. I've already a restore script (scheduled and working on other server) that takes all the ...
1
vote
0answers
62 views

SQL Server 2012 - Large backup file size

We have the following setup: Once a week (Sunday at midnight), a full database backup is performed. A new BAK file is created for this purpose, let's call it Backup1.bak. From then, a transactional ...
1
vote
1answer
85 views

DB2 - Archive Mode - on what values to set LOGPRIMARY,LOGSECOND,LOGFILSIZ?

we must set our database from CIRCULAR to ARCHIVE mode in order to enable ONLINE backups. Backups will be done every 1 day. Database is now almost 30GB. Database grows approximately 1GB per month. ...
1
vote
2answers
47 views

Backup architecture for frequent backups of business critical DB

We've got a database (mysql) driven application which contains business critical information, were looking at building a system that will allow us to backup the db frequently (every 15 minutes, ...
0
votes
1answer
48 views

why mysql binlog creating new log file daily

I have started binary logging on MySQL server on my Ubuntu. It start creating log files in /var/log/mysql. My my.cnf configuration is as follows: log-bin="/var/log/mysql/" expire_logs_days=10 ...
0
votes
1answer
74 views

What does it mean to backup a database

What does it mean to backup a database? My impression is that you would simply dump everything that makes up the database into some format that can be stored externally and used to restore from when ...
4
votes
1answer
110 views

Settings for a MySQL backup only slave instance

I have two instances of MySQL running one a server, set up as master and slave. It's all working smoothly together and I'm only using the slave instance for backups to avoid locking up the live ...
1
vote
1answer
258 views

Query that displays backup information (successful and failed) SQL Server

I have two jobs that backs up two different databases. Job 1 backs up DB1 Job 2 backs up DB2 DB1 fails to back up due to low space on Drive 1 resulting to a Job 1 failure. To fix that issue, I just ...
0
votes
0answers
33 views

Backup is getting failed with following error

Msg 3202, Level 16, State 1, Line 1 Write on "\w-mum-fp\SQLBKP\Weekly-FL\Interactions_26_01_2014.bak" failed: 1130 (Not enough server storage is available to process this command.) Msg 3013, ...
1
vote
0answers
63 views

Differential backup job is working but not the Full daily backup

I have a full backup job for my database that runs once daily, I see it posted daily in the folder that it should go to, but when I check the "View History" for this job in SQL Server Agent, there are ...
0
votes
1answer
52 views

Oracle backup and recovery using RMAN

Can some please provide a quick guide for backup and recovery of Oracle 11 DB? I just need to test it very quickly so i don't need something too fancy, but should be scheduled. Thanks in advance.
2
votes
0answers
58 views

backup history script produces incorrect results

I have a database that is backed up via maintenance plan. The database is scheduled to be backed up at 8:00PM. It usually takes 6 hours to complete. According to this query, SELECT distinct ...
2
votes
1answer
144 views

“Database is in transition” Error

Today I was trying to restore a database over an already existing database, I simply right clicked the database in SSMS --> Tasks --> Take Offline so I could restore the database. A small pop up ...
0
votes
0answers
110 views

SQL Server backup/restore between systems with different storage sector sizes

We have a system where we create template databases and back them up and distribute them to customers. We recently upgraded our 'build' server to use SSD with a 512 sector size and received an error ...
1
vote
2answers
106 views

T-SQL script to perform a compressed backup with maximum compression level [duplicate]

I have a database with full backup of almost 2GB. When I perform a full backup (without compression) and then compress it with winrar it become 140MB, but when I backup WITH COMPRESSION syntax the ...
0
votes
1answer
83 views

Taking hot backup of slave node in postgres (master-slave config with repmgr)

I have a postgresql setup with master-slave configuration using repmgr. I'm struggling with taking a consistent snapshot backup (pg_start_backup) of the slave node, this is due the fact that the slave ...
0
votes
2answers
36 views

I can't import my database into mysql

I have a website based on drupal and I tried to export its database via both Backup wizard and phpmyadmin. the database was exported but I can't import it on my localhost database.this the error ...
0
votes
1answer
30 views

MongoDB replication to local hard drive

MonogDB's dynamic schema has made me thinking about replacing MySQL. I eventually want to use MongoDB as the default for all new app developments. But this project runs on only 1 dedicated server ...