0
votes
0answers
25 views

I need a way to implement an incremental Backup/Recovery on mysql client

I need to be able to do a point-time recovery in mysql client from the mysql server. For example I need to Download only the information that have change since last backup. I can do that using log,but ...
2
votes
1answer
60 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 ...
1
vote
1answer
47 views

How to document an archived database? [closed]

You've stored the backup file in a safe place, but what kind of info do you store with it? database type (SQL Server) compatibility level (SQL Server 2008) application name application owner ...
1
vote
1answer
412 views

How to flush SQL Server database from RAM to hard disk?

As part of the nightly maintenance plan, my working MS SQL Server 2012 databases are backup-ed with options of simple recovery and full backup. Transaction log is not backup-ed. Also, at nights the ...
1
vote
1answer
95 views

Is it possible to change the drive that Microsoft DPM backs up to?

A while ago our sysops guys created a 15 minute transaction log backup schedule using Microsoft DPM. We often have an issue where there won't be enough space on the Log drive to perform a backup ...
2
votes
3answers
137 views

Reasons to Backup (or not backup) QA and Dev Databases

Pretty simple question: is it standard/best practice to backup dev and QA instances of the database? Assume that the schema information is kept in some form of source control.
3
votes
2answers
1k views

How can I dynamically back up all SSAS databases on a given instance?

I want to dynamically back up all the databases on a given SSAS instance using a SQL Agent job (which would most likely involve executing an SSIS package). It is imperative that this is a dynamic ...
2
votes
1answer
1k views

How to restore IBM DB2 database from AIX to Windows?

I had made backup from remote IBM DB2 server in AIX using this command: ./db2 backup database DBEMP to /home/dbemp/backup Then I grab the backup file using FTP Client from my Windows. I run this ...
4
votes
2answers
7k views

How to backup IBM DB2 Database online?

I tried to backup the IBM DB2 (LUW) Database using this command: ./db2 backup database DBEMP to /home/user1/db2bkup But I got this message: SQL1035N The database is currently in use. ...
-1
votes
1answer
175 views

How to merge data from 2 databases [duplicate]

I have a SQL-Server database that crashed while I was away on vacation. All info from 5/2/13 is missing from our current database because my replacement implemented a back-up of the database from ...
5
votes
1answer
2k views

Appending backups while overwriting expired sets

I've been reading up on this, but the online documentation is a bit difficult to understand and seems awkwardly written. For example the INIT, NOINIT. One says it will try to overwrite everything. ...
0
votes
1answer
2k views

How to automatically regularly a week backup SQL Server database if changes exist in the database for the previous week

I´m new to SQL Server administration. I´d like to create automatically backup database every sunday night, if there was any change in previous week (if not, backup is unnecessary). Is there some way ...
2
votes
1answer
323 views

Assertion failure from InnoDB while restoring using Innobackupex

I thought I would give back to all those people who help me when I have a problem. This might be something old, but I did not find it anywhere so here goes: We recently upgraded our production DBs ...
0
votes
2answers
262 views

Is command BACKUP asynchronous operation

I got strange delays when backed up a group of databases (20 more) in one scope (TSQL) to the same file location. Is it possible that multiple backup operations are running at the same time? I have ...
2
votes
2answers
164 views

How to compare the database of a backup from another environment

Has anyone had any luck with taking a backup (approx 30 tables) from an Oracle database's live environment, then loading a test environment with this backup and doing a comparison between the test ...
8
votes
4answers
10k views

How to detect any changes to a database (DDL and DML)

There are a lot of databases on my client's sql server. In common, these databases is under development, so developers can design, refactor, do data modifications and so on. There are some databases ...