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
1answer
338 views

Mysql Incremental Backup and point in time recovery

I'm writing a shell script using the concept of binary logs for point in time recovery. Now, the scenario is such that a full-backup will happen every alternate day and Incremental backup should be ...
0
votes
0answers
11 views

MongoDB fsyncUnlock won't unlock occasionally on Windows

We have a MongoDB replica set installed on Windows servers, with a scheduled backup job. MongoDB is configured to use journaling. The job runs db.fsyncLock() via script on MongoDB (primary server), ...
0
votes
1answer
30 views

Is possible do an online snapshot backup , without archive logs at Oracle Database?

Using Oracle Database Standard Edition 11r2 . I'm looking a way to backup the database with zero downtime , using a snapshot of datafiles (LVM snapshots) and without need backup de archive logs. ...
2
votes
1answer
34 views

Hyper V replication - vs - sql replication solutions

I need to establish an offsite copy of a number of production servers, including SQL server. Hyper V replication has been chosen as a simple solution (all servers are virtual). This is to supplement ...
1
vote
1answer
3k views

Automatic backup MySQL Workbench

Is there a way to schedule AUTOMATIC backups for specific tables in MySQL Workbench?
0
votes
1answer
16 views

Old Data on SFTP [on hold]

There are several old files on an sftp of mine that date back to two years ago. These files are ingested into a MySQL database. I am wondering what to do with the old raw files. The reason I am asking ...
0
votes
2answers
243 views

Extract one MySQL database from a FULL MYSQL Server backup file

I have a small shared windows server on which i'have installed MySQL 5.1 engine for hosting my user's mysql databases. I backup the complete MySQL databases each day by running this script as batch ...
3
votes
2answers
23 views

Is it possible to backup stored routines and functions with Innobackupex?

I am running a few restore tests on my Dev and I've noticed that the stored routines are not being restored with the innobackupx. Is that something achievable ? Am I doing something wrong ? I am only ...
2
votes
4answers
550 views

SQL Server Table Backup

A friend of mine has run into this problem on SQL Server 2008, please suggest a solution: He came to know that auto backup scheduled on server were not taking place since last couple of days, when he ...
13
votes
2answers
4k views
+500

How to do incremental backup every hour in Postgres?

Trying to do an hourly incremental backup of a single Postgres server (Win7 64). I have the following setup in postgresql.conf: max_wal_senders = 2 wal_level = archive archive_mode = on ...
2
votes
1answer
43 views

Can I use a script to restore multiple SQL databases from .bak files?

I'm migrating 100 plus SQL databases over to a new server in a new location. I have the maintenance plan in place to take full back ups and then a script to copy over the .bak files to a temp ...
3
votes
2answers
1k views

How to take pg_dump of a very large postgres database?

I have a production database server running Postgres 8.4 on Cent OS 6.5.The volume of data has increased recently and within few months database now has 18500 tables amounting to approx 350GB database ...
3
votes
2answers
162 views

Backup status report from multiple server in sql server 2005

Per daily routine activities of DBA, as we know backups are important to be monitored and to make sure they are corrupt free, i am trying to fetch a report to get such status. Moreover, we have SQL ...
1
vote
1answer
16 views

should I change mysql platform for higher innodb_buffer_pool_size?

Currently Im running a 160G MySQL database on Xampp (Windows). But Xampp has upper limit for innodb buffer pool size of 4G. My computer has 16G RAM. So if I want to make full use of resources, should ...
2
votes
0answers
42 views

SQL Server DB Backups WaitTypes

I am backing up a database to a network drive. I am seeing the below Wait types for the backup. I have also tried backing up to a local drive and same issue (though backup does run much quicker). ...
0
votes
1answer
400 views

MyISAM : Should I be concerned by these warnings?

I restored some tables from recent Databases backups. Because Im supporting a legacy system that only uses MyISAM tables in their DBs, for backing up I used a little script that pretty much copies all ...
2
votes
4answers
69 views

SQL Server 2008 backup script

I have a lot of SharePoint 2013 databases to backup and if update fail to restore, so I want to automate this operations. ALTER DATABASE [TEST_1] SET OFFLINE WITH ROLLBACK IMMEDIATE GO BACKUP ...
1
vote
1answer
24 views

MonetDB auto-backup mechanic problem

I'm trying to set up mechanism that will automatically create database backup. The idea is to create a script that will be executed by crontab. Seems easy but I'm struggling with the following ...
2
votes
0answers
61 views

Weekly SQL database backup failing

I have a weekly SQL database backup job that is failing. If I look at the end of the history of the job, I see the following messages: Executing query "USE [msdb] ".: 2% complete End Progress ...
3
votes
1answer
36 views

Local Backup from Amazon RDS PostgreSQL database

I have a PostgreSQL database on an Amazon RDS instance. I want to have a local dump of this instance. So far, I've tried with this: PGPASSWORD="Password" pg_dump -h ...
2
votes
2answers
44 views

Restore Error event id 17066 and 3624 while restoring diff backup

I am getting the following error while restoring the Diff back up after restoring the Full backup in Norecovery mode. I am unable use dbcc checkdb as the database in restoring db.Issues happens only ...
1
vote
1answer
109 views

difference between pg_dump command's --column-insert and --attribute-insert

Background: I'm trying to create a dump file that only contains the data in my database. I would like it to create the data with the INSERT command. In reading the manual, ...
126
votes
5answers
233k views

How do you mysqldump specific table(s)?

How can I dump a specific table or set of tables without including the rest of the db tables?
0
votes
0answers
10 views

How can I create a copy of postgis db from one windows machine to another

I have postgres 9.3 database with postgis extension. I want to create a new database on different computer and import all the tables from the source database. In mssql it would be simple , just ...
1
vote
2answers
374 views

Restoring an Oracle Backup Properly

I've been trying to do a proper restore of a database for weeks now and I'm convinced that I'm doing something simple wrong. I took a cold backup of the database before an update to an application ...
9
votes
3answers
293 views

Backup internals - What happens when a backup job is running - in terms of locking and performance overhead in SQL Server?

For MySQL I know the database is backed up table by table in SQL Statements, this results in locking and if you update columns while backing up you might end up in integrity problems. To my ...
1
vote
0answers
24 views

Where is default data directory in DB2?

I have a problem: cannot backup DB2 8.1 with backup command line in Windows 2003. I think my HDD was failure (after read error showed by backup command). So, I want to copy the folder/ directory which ...
0
votes
2answers
29 views

SQL Server database backup and saving at the same time

What will happen when is running differential backup on SQL Server 2012 and some application is trying save data to table at the same time?
1
vote
1answer
71 views

Scheduling a backup in SQL Server 2005

I am trying to schedule back up in SQL Server 2005 with management option. I am unable to find database name while scheduling a backup with full option. Database name is not over there in selected ...
1
vote
1answer
1k views

BACKUP failed to complete the command BACKUP DATABASE

Not sure if this is a false-positive issue or not, but I need quell my curiosity about it. I get the following error message: Error: 3041, Severity: 16, State: 1. BACKUP failed to complete the ...
1
vote
2answers
268 views

SQL Server database backup on Remote site

We have 4 different sites and each site has a SQL Server. Our requirement is to have a SQL Server backup or database (Mdf files) of site 1, 2, 3 in site 4. In case of disaster on any of the site we ...
0
votes
2answers
152 views

Error with making backup in sql Server

When I try to backup a SQL Server 2008 database, I have an error. Is anybody know what is the error? TITLE: Microsoft SQL Server Management Studio ------------------------------ Backup failed for ...
3
votes
2answers
41 views

Prevent logins loss when restoring a database

I'm backuping and restoring databases accross two sql server (v12.0.2000). But it looks like whenever I restore a .bak file, the login I created on the database that was backuped is no more existent ...
1
vote
0answers
42 views

Preferred third party SQL Server backup tool? [closed]

Can anyone list their preferred third party SQL Server (with SQL Server 2012 support) tool? My organization is considering utilizing a third party tool to gain some speed and flexibility for our ...
5
votes
5answers
619 views

SQL Server Backup Process Tuning

I am working for a small company that has 20 full time web sites. And another 20-30 micro sites. We are having issues with the sites freezing every day after the SQL Server Agent backup is running. ...
1
vote
3answers
173 views

How to find what frequent and/or large transaction have taken place in MS SQL Server?

Each day is experiencing about 1GB sum total of all the transaction log backups that day, while at the end of that week the Full DB backup is about 180MB. For a business database for buying/selling ...
-3
votes
1answer
41 views

Backup SQL server DB [closed]

I can take a SQL Server backup to a local disk without any problem, but I need to take a backup to a cloud disk or network folder that I can access. What are the best practices to do this?
1
vote
1answer
42 views

Backup SQL Server with VMware

The VMs I run SQL Server on are regularly backed up by the VMware backup tool. I would prefer not to use this backup solution but I have no choice but to cope with it. The problem I've come up across ...
0
votes
1answer
167 views

Rman controlfile and rotation

I got an Oracle 10g server with a bash script running every night which extract each datafile and create an rman script, which is launched from the bash script itself and make backups. CONFIGURE ...
4
votes
1answer
112 views

Preventing full backups for unmodified/slightly modified databases

Is there a way to either: ensure that unmodified databases are skipped during SQL backups, or even better choose between DIFF or FULL backup depending on the percent database changed since last ...
11
votes
5answers
46k views

media family on device is incorrectly formed. SQL Server cannot process this media family

I am trying to restore a .BAK in SQL server but get the following error: Msg 3241, Level 16, State 7, Line 1 The media family on device 'c:\glyn\JA.bak' is incorrectly formed. SQL Server cannot ...
1
vote
2answers
158 views

How to restore a “contained” database? [closed]

I recently tried to restore to my local development SQL Server a backup from a network instance. To my surprised I received the following error message: Msg 12824, Level 16, State 1, Line 3 The ...
1
vote
1answer
58 views

Full backup at 1am, not started by my maintenace plan

I set up a complete set of Maintenance Plan. Full backup of all databases at 3AM. Differential backup at 6h30, 12h30, 18h30 and 00h30. Log backup at each hour, at 45 minutes (1h45, 2h45...) In my ...
0
votes
1answer
28 views

mongodump with readpref nearest

I have a mongodb cluster where shards exist across multi geographically locations and each of those locations have replica members for each shard. I have setup our DR datacenter. Which also has a ...
1
vote
1answer
23 views

How to determine if a mysql binary log file is empty?

In order to determine whether a database backup is needed or not, I'm trying to see whether a mysql binlog file has any data in it. (During a backup, we make a fresh binlog file and record the ...
4
votes
1answer
57 views

Restoring database without worring about partitions

On our our production database there is a partitioned table called FullLog. This is updated via triggers so we know who changed the database and when. Which is a problem for me when I restore the ...
0
votes
1answer
48 views

fn_dblog not showing up deleted table data

I unintentionally deleted 4 rows from a table. I tried to fetch back the deleted data using a stored procedure (got from internet). However, I was able to see my data in the result of stored ...
0
votes
1answer
355 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
1answer
125 views

WordPress MySQL writes during “Flush Tables With Read Lock” are rejected instead of being queued

I'm running into an odd issue when setting MySQL into a brief read-only mode for backup. Reads continue fine during that "read only" minute, but writes are just rejected instead of being queued to ...
0
votes
0answers
20 views

What's the best way to implement an incremental backup of an SQL Server database using VB.NET?

Basically the situation is like this, there is a database on SQL Server which takes transaction records of a store everyday. What I want to do is create a VB.NET program that will generate everyday a ...