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 (1)

1
vote
0answers
261 views

To configure MySQL Enterprise Workbench for Incremental Backup with Online Backup option

Could not acquire management access for administration RuntimeError:Could not initialize WMI interface: Workbench.wmiOpenSession():Could not connect to target machine. When i am trying to configure ...
1
vote
0answers
100 views

Database backup hangs both in SSMS and XMLA

I am using SQL Server Analysis Services 2008 R2 Service Pack 3. My database was recently upgraded from Analysis Services 2005 and since that time I have been unable to do a backup either from SSMS or ...
1
vote
0answers
218 views

Are ZRM (Zmanda Recovery Manager) incremental backups reliable?

I had an issue while restoring incremental backups and I'm wondering if they are reliable. I'm making weekly full backups and daily incremental backups and I needed to restore a single database after ...
1
vote
0answers
269 views

pg_basebackup could not get WAL end position from server

I'm trying to pg_basebackup my database. I followed instructions in PG Mauals and set it up properly (check on other server and database), but my backup isn't ending - on end of progress it's ...
1
vote
0answers
358 views

How to restore everything (including “postgres” role) from pg_dumpall backup

I have a postgres 9.1 server running and I do backups with pg_dumpall -c -f /nfs/backup/fulldump.sql I'm testing restoring the backup to another server with psql -f /nfs/backup/fulldump.sql ...
1
vote
0answers
704 views

Backup failed due to lack of hard drive space…how?

I had a maintenance plan fail last night (runs daily) for the first time in ages. The following is the specific error I received, minus the actual database name: Extend Disk Backup: failure on ...
1
vote
0answers
854 views

Backup Restore Procedure error SQL Server 2008 R2

We use a stored procedure to do a backup and restore of databases as a copy function. This allows our front end users to spin up sites from pre created template databases. Lately we've been getting ...
1
vote
0answers
374 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 ...
1
vote
0answers
422 views

restore using mysqlbinlog failing

While doing restore from a MySQL binary log file, it is failing with the following error . mysqlbinlog mysql-bin.000036 | mysql -u root -p asdb ERROR 1032 (HY000) at line 48: Can't find record in '...
1
vote
0answers
117 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 ...
1
vote
0answers
276 views

Backup of msdb stuck in rollback

A native full backup of msdb on a SQL Server 2005 Enterprise instance (9.0.4053) deployed on a two-node Win2K3 cluster (Microsoft Windows NT 5.2 (3790)) is currently stuck in rollback. The DB is in ...
1
vote
0answers
182 views

Way to make differential backup from full different but from same database

I have the following situation: Our sql server is running in a cloud service. The database to be backed up have 60gb. We need to make a local copy of the database for some tests, and it need to be up ...
1
vote
0answers
14k views

Failure Of Backup Due To Limit Exceeded For Recovery Files Since Cannot Reclaim Disk Space [RMAN-03009,ORA-19809,ORA-19804]

While I try to take incremental backup level 0 by using the command RMAN> backup incremental level 0 database plus archivelog; , encountered this error. RMAN-00571: ============================...
1
vote
0answers
549 views

DBCC Physical only giving Connection failure

I have a SQL server 2012 Ent DB. The hosting company is trying to setup new backup solution using Symantec Backup Exec. They have come back and said our database is corrupt because they get these ...
1
vote
0answers
52 views

Backing up the SQL Application

I have a Windows 2008 R2 server that needs to be periodically reset to a clean state. Normally I would look at creating an image of the system drive, however due to organizational reasons I cannot use ...
1
vote
0answers
137 views

Import from incremental backups to a new host in Oracle 11g

I am using Oracle 11g. I would like to know that whether it is possible to import from incremental level 0 & 1 backups to a new host using RMAN. If yes, how can I do that? For level 1 I am using ...
1
vote
0answers
143 views

Backup headerinformation hold wrong database name

We're in the proces of preparing our migration to our new servers aswell as SQL 2012 and everything is looking fine and dandy and i'm testing some of the scripts we will be using. One of these ...
1
vote
0answers
262 views

Rackspace Cloud Databases: incremental backup

Rackspace Cloud Databases are a little bit special in that we do not have access to the bin_log file, they are not servers in the traditional sense. I do have a couple of Cloud Servers with them but I ...
1
vote
0answers
817 views

How to backup a running SQL Server CE database with full data?

I need to move my running windows-based app (built in C#) to another machine, but I also need to transfer the whole data, how can I take a backup from the .sdf file and use it with the new installed ...
1
vote
0answers
771 views

Cannot remove .bak file

I have a java application that: Reads a .bak file from a windows fileshare and restores it in SQL Server on a remote windows server Does various modifications on the database restored from the .bak ...
0
votes
0answers
16 views

Backup MySQL to different destinations

I'm working with MySQL databases on Windows and I need a solution how to backup them to Amazon S3 and DropBox. I have 5 databases 600-900 MB each and I need to backup 3 of them to DropBox and another ...
0
votes
0answers
5 views

How can I open .SBF or .SBD files?

I need to read some .sbf and .sbd files but I don't find any software for it. I have downloaded FileViewPro but when I try to open .sbf file, appears an error. A lot of thanks for your assistance
0
votes
0answers
12 views

Restoring a backup of 1 database to another puts both databases into Restoring mode

We have a 2 databases- Staging Test At times, we refresh out Test environment with a copy of Staging. We do this by taking a full backup of the Staging database and restoring it over the Test ...
0
votes
0answers
30 views

Backup /www/ directory and all mysql databases

I'm trying to write simple shell script which will zip all databases + www directory. I don't know what is the problem but I've got wired output. I've got zip with .sql file full of hieroglyphics... ...
0
votes
0answers
21 views

Import databases using /var/lib/mysql

I've got some issues with my server, leading me to completely reinstall my debian OS. Before reinstalling, I backed up some files on the server and now it reveals that I have a backup of my previous /...
0
votes
0answers
30 views

mysqldump: Got error: 1049: “Unknown database 'xx'” when selecting the database - because database deleted during backup? DBaaS

I receive this error during dump (runs a few hours, because 31 GB data files) mysqldump: Got error: 1049: "Unknown database 'ZETF_353D082E_422C_47C4_905F_FF961EEA29B8'" when selecting the database ...
0
votes
0answers
20 views

InnoDB: Operating system error number 9

I got error when trying to backup with percona. Backup command [xtrabackup --backup --target-dir=/data/backups/mysql/] was worked and When I try to prepare backup [xtrabackup --prepare --target-dir=/...
0
votes
0answers
32 views

Failed to flush the commit table to disk

We recently had this error come up for one our databases https://support.microsoft.com/en-ca/kb/2603910 In order to fix it we patched the server to the latest SP and Security Update. Current version ...
0
votes
0answers
22 views

Backup options for database with large objects

I have a database that includes a table with references (as oids) to large objects that have been stored in the database via the JDBC Large Object manager. I need to make regular backups of the ...
0
votes
0answers
48 views

How to schedule the daily backup of a specific database in PostgreSQL?

I have a database 'ahrims', I want to schedule PostgreSQL under linux to backup this specific database (not all databases) at 4:00 PM daily. How can I achieve this? Please help!
0
votes
0answers
24 views

Can I delete an Oracle “Whole database backup” while a level 0 backup is being created?

I have created a Whole database backup using: -- In SQL*Plus ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 5000G SCOPE=BOTH; ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = 'O:\ORA_FRA'; alter system set ...
0
votes
0answers
33 views

Incorrect database backup file size in SQL Server 2008 R2

I am getting different sizes of the database backup file from SQL Server 2008 R2 even when backing up at very granular or frequent intervals. Scenario: I have taken database backup at 8:00am = ...
0
votes
0answers
30 views

Restoring a mysql database from raw files found in a mysql folder

My webhost screwed me. The dedicated server I had had a failed hdd and I lost the drive. I backed up all files but not the databases. I was able to save some MYI and MYD files but no able to do a ...
0
votes
0answers
79 views

Database as it is raw content

recently I asked my hosting company to give the backup of my database . I asked them to create a new database and import backup to that database. But they reply cannot dump database ...
0
votes
0answers
17 views

3023 : File serialization issue with transaction log backups

I am trying to take a transaction log backup on one of the AO replica servers. It throws an error saying that backup operations must be serialized. I googled this and found that only one backup should ...
0
votes
0answers
7 views

Is making a recursive hard link of all files inside cassandra data file directory a safe way to back up the entire database?

I have a single node cassandra cluster running on my local machine. I want to back up my data file directory. My question is pretty simple. Say I was to search the entire data file directory and ...
0
votes
0answers
15 views

pgadmin III backup screen freeze

I wanted to get a backup for a very large database with pgAdmin, I started as usual backups, but after a couple of hours it still runs, and I can't cancel it also. I don't even get to see the file ...
0
votes
0answers
29 views

MySQL Storage Engine and Memory

I recently found out that, the databases does not have standard architecture(data model), some of them are, No relationship between tables(entities). No indexes defined. Only integer and varchar ...
0
votes
0answers
47 views

Performance drops after online backup

We are using DB2 Express-C 10.5.5 on Ubuntu Server 12.04.5 64-bit. Every night we do a full online backup: backup db MYDB online to /home/db2inst1/backup compress include logs after backup we do log ...
0
votes
0answers
23 views

Can I merge a newer version of a database with a backup copy

I have a backup of a database, and a newer version of the database. The newer copy, however, is does not include information that is in the older backup. I want to merge these into one - all tables. ...
0
votes
0answers
20 views

MS Access - Extract Data from Proprietary mdb file

my friend has this "software" that manages financial records, with a lot of user data per record. This "software" is really an access file. To launch it, you use msaccess.exe program.mdb, and it ...
0
votes
0answers
25 views

MySQL Enterprise Backup

Hi I've been looking for MEB version 3.12. But it seems the Oracle's eDeliver does not have this version. The available version is 4.0.xxx. I need this older version because my MySQL server version in ...
0
votes
0answers
31 views

Is it possiable to force WiredTiger use multiple files to avoid large Incremental backups?

MongoDB's original storage engine creates sequential files, so the old data is located in old files, in that case incremental backups are done with the new file for each database, in wiredTiger the ...
0
votes
0answers
19 views

Wordpress DB's and fixing corruption

I'm usually over in the Wordpress stack exchange but I thought this would be more pertinent in this community. Recently I took down a site I spent a few years developing it's content and closed the ...
0
votes
0answers
157 views

Could not locate a valid checkpoint record postgres

I have a database postgres in windows server and two slaves for reading. I need do Incremental Backup. What I've done: - Create Base Backup from pg_basebackup - Save WAL files Restore What ...
0
votes
0answers
26 views

Best way to generate backups with 'INSERT ON DUPLICATE KEY UPDATE'

I have been using HeidiSQL to generate MySQL backups using 'REPLACE INTO' however have recently come across the problem this causes with foreign keys & have been told using to use 'INSERT ON ...
0
votes
0answers
117 views

Backup and restore DB through stored procedure

I need to backup a database from a server/db TO a destination Server/db. The process is pretty cool because you specify the Source Server and DB and the Destination Server / DB and the code is ...
0
votes
0answers
80 views

MySQL – Backup/Restore Selected Tables/Fields Only

I support a Python application (includes some C modules) that utilises a MySQL database. A number of clients are running this in a standalone environment but have agreed that we can use their data ...
0
votes
0answers
18 views

msdb.dbo.backupset vs user table

Is there any particular advantage or disadvantage to using msdb.dbo.backupset as opposed to a custom table to log backup details, other than the proven reliability of backupset, and the risk of ...
0
votes
0answers
142 views

Backup storage file corruption: file not found. Possible cause of this error is corruption of backup file

I backup my SSAS cubes called "BI LIVE" and restore it to a specific location on a different server. I am using sql server 2014. This is where you can see the routine I use to run the backups: How ...