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)

7
votes
0answers
51 views
+100

Keeping (Partial) Backups Small when using SQL Server FILESTREAM

I have a database with nearly 1TB of FILESTREAM data that I don't need backed up (if the data was deleted it'd be recreated automatically in a couple of hours, so it just isn't important). Most of the ...
0
votes
0answers
7 views

Dumping and restoring tables in PostgreSQL - ERROR: extra data after last expected column

I am trying to dump and restore multiple tables from a database on one server, to a different database on another server. Both are running Postgres 9.4 on linux. The command for the backup was: $ ...
0
votes
2answers
114 views

Alternative for taking the backup of SQL DB's on backup drive

We just got new servers to take care of, regarding their backups, handed over by the company B who used to manage the backups, but they never did via any mant'ce plans or SQL jobs.They did that task ...
0
votes
1answer
105 views

mysqldump collation issues

I have tried my hand at building a shell script to backup our wordpress database using tar balls and chron jobs on a Debian environment. The problem I am facing now is that our wp database after ...
0
votes
0answers
29 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 = ...
3
votes
4answers
100 views

Is it enough to have only full backup and transaction log backup only for a good backup plan?

If Full backup is scheduled for every Sunday at 12 pm and differential back up is scheduled for for every 6 hours and transaction log backup is scheduled for every 15 minutes. My problem is what is ...
0
votes
3answers
44 views

Backup Error with Msg 3201, Level 16, State 1, Line 1 & Operating system error 3

When i am taking the backup in network share drive with mention below TSQL. Use DatabaseName Go Backup Database DatabaseName To Disk=N'H:\DatabaseBackup\DatabaseName.bak'; Go I am getting the ...
1
vote
1answer
114 views

PostgreSQL WAL recovery not working due to missing WAL

I am using pgBarman for PITR recovery. Now it's a bit of a crisis, because the Barman backup and the WAL archive seems like it cannot be recovered. We're running PostgreSQL 9.3.6 and latest stable ...
1
vote
2answers
248 views

Cannot open backup device Error

I have a SQL Server Agent job that backs up a database on a remote server to a network drive. Linked Server, I believe is set up correctly but I get the following error: Msg 3013, Sev 16, State 1, ...
0
votes
2answers
469 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 ...
-1
votes
1answer
19 views

Restore DB script

I wrote this script for restore DB: declare @dir nvarchar(70), @year nvarchar(4), @month nvarchar(2), @day nvarchar(2) set @year = datepart(year,getdate()) set @month = datepart(month,getdate()) ...
1
vote
0answers
14 views

msdb.dbo.backupset.compressed_backup_size is inaccurate?

I thought the value in msdb.dbo.backupset.compressed_backup_size represented the size, in bytes, of the full, differential, or log backup file (that is, the BAK, DIFF, or TRN file). However, although ...
16
votes
5answers
77k 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
0answers
38 views

SQL Server 2008R2 - BAK file backup performance issue

Just note I'm not a DBA or anything close to that. Problem: We are using SQL Server 2008 R2. We have 32 databases and backup to local disk (3PAR) using SQL Server maintenance plan. Normally it ...
1
vote
2answers
2k 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 ...
1
vote
0answers
25 views

How to backup SSIS packages and CUBE Projects from Visual Studio 2013.5?

I'm using VisualStudio 2013.5 to develop SSIS, SSDT and SSAS Cubes (multidimensional and tabular model). I would like to ask you is there a possible to backup SSIS packages and SSAS cubes from ...
3
votes
3answers
225 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 ...
3
votes
1answer
31 views

Is there a non-blocking operation to back up MyISAM tables using Percona XtraBackup?

I've been reading through the website of Percona XtraBackup and it claims that: Percona XtraBackup can back up the following storage engines by briefly pausing writes at the end of the backup: ...
5
votes
4answers
5k views

SQL Server 2012 always-on backup, full vs copy-only

I need a quick clarification on copy-only backup vs full backup as it pertains to transaction log numbering and restore if required. I have SQL Server 2012 setup with always on for multiple ...
3
votes
2answers
230 views

Identify the type of a SQL Server backup

Long story short, we had a hosting plan on www.hostforlife.eu (btw, terrible service even on more expensive packages, plus they lost ALL files on their servers and we had to restore our backups as ...
2
votes
1answer
14 views

PostgreSQL read-only user for pg_dumpall

I'm running a PostgreSQL instance which is used by several related applications, each of which has its own database. For backups I want to create snapshots of the complete data in the instance and I ...
2
votes
2answers
33 views

Cannot see new drive in SSMS maintenance wizard

I'm trying to setup a Backup Maintenance Plan in SSMS for Sql Server 2012, running in a failover cluster on Windows Server 2012. The current plan backs up to the same cluster volume where the ...
0
votes
1answer
681 views

Backup SQL Server to Google Drive

I have Microsoft SQL Server 2014 on an Azure VM (Windows Server 2012 R2) with one database. Is it possible to configure an automatic backup to my Google Drive folder? Maybe a special tool or ...
0
votes
0answers
18 views

Is it possible which documents couldn't be dumped using “mongodump”?

I am removing historical data from a collection in MongoDB (3.2), but first I need a backup of it. The choice has fallen, a simple combination of: mongodump --db myDatabase --collection myCollection ...
1
vote
2answers
231 views

SQL Server hangs during backup on EC2

Once and then our SQL Server will "hang" during its weekly full backup. When this happens, external connections start to timeout. The symptoms are: Connections timeout The sqlservr.exe process sits ...
1
vote
1answer
19 views

Large `mongodump` followed by `mongorestore`

I have a fairly large (~240GB) Mongo database that I need to transfer across a sluggish network and onto a new server. Traditionally for these situations, I've found that a mongodump followed by a ...
5
votes
3answers
3k views

SQL Server 2012 database backup successfully report but no backup file

I have created maintenance plan in SQL Server 2012. And every day, the maintenance plan should backup the database. There is no database backup file when I look in the folder where the backups must ...
5
votes
4answers
12k views

PostgreSQL: How to backup only One Schema from a database and restore it on another server

I have a database named "A" which has two schemas "B" and "C". I want to backup and restore Schema "B" on a different server? not sure how to do this as I am new to Postgres. Do I have to create a new ...
1
vote
2answers
94 views

Backup Error (.bak)

I need to backup the database in SQL Server 2014. When I am trying to do so, I am facing this problem which is not saving backup as a (.bak) extension. And when I try to select (Files and ...
-1
votes
0answers
29 views

What are a flashback and bounce? [duplicate]

In the context of a database backup, specifically, Oracle, what is a bounce and a flashback?
0
votes
2answers
118 views

Which files in the “MySQL-5.0.27-win32” folder do i need to backup?

Ok, I am using a pretty old MYSQL "mysql-5.0.27-win32" and the file and the structure maybe different from the latest Mysql (mysql 7). Here is the current structure of of mysql-5.0.27-win32: In ...
0
votes
1answer
56 views

Sql Server log: is 'Backup|Log was backed up' the same as 'BackupDatabase: Log files done'?

One transaction log file is growing and growing for a couple of days and I can't find out why. Now I figured out that either the way the activities are stored in the sql logfile OR the behaviour of ...
0
votes
1answer
641 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
47 views

Oracle: Can a tablespace stay in backup mode forever?

Recently I discovered in a legacy Oracle 8.1.7.3.0 database that the tablespace holding de AUD$ table has been in backup mode for six months. Dunno who issued the begin backup command on it six moths ...
1
vote
1answer
25 views

How can I do an incremental `mysqldump` without dropping table?

I'd like to fetch the last 100 rows of a table via a mysqldump, but I already have the rest of the table. How can I only fetch the last 100 rows for a mysqldump and then replace (or overwrite) any ...
0
votes
1answer
48 views

Automate backup using Windows Task Scheduler

I want to run an automatic backup of SQL Server 2012 Express using Windows Task Scheduler. I have 3 user databases. I want to backup all 3 user databases through a single stored procedure and a ...
1
vote
1answer
85 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 ...
5
votes
2answers
4k views

Incremental backups using MySQL Workbench

I need to start doing regular backups of my databases, and I'd like them to be incremental; that is, only backing up the tables that have been changed. I use MySQL Workbench, and I've used the export ...
1
vote
1answer
8k views

Automatic backups for MySQL Workbench

Is there a way to schedule AUTOMATIC backups for specific tables in MySQL Workbench?
1
vote
0answers
14 views

MySQL quick database transfer between two servers

I am migrating a reasonably large (18GB) database used for a website from one server to another. There are two tables which make up 95% of that size and they do not have to be fully transferred for ...
1
vote
0answers
19 views

Point to MySQL Binary Logs

So we have two linux servers that have a shared backup folder. The one server that is doing all the backups is working perfectly fine and has point in time recovery set up, which requires binary log ...
3
votes
1answer
31 views

Copy-only as the routine backup

We are in planning to upgrade from SQL Server 2008 R2 to SQL Server 2014, with the intention of using Availability Groups. One of the secondaries will be used to do backups. I have tested and ...
2
votes
3answers
247 views

Restrict user to only take COPY_ONLY backups

Is there a way to force users to only take a full backup with COPY_ONLY so they don't interfere with differential backups? Our developers need to take backups every now and then but they don't ...
1
vote
1answer
109 views

SQL 2014 AlwaysON Backup

I have 2 SQL server 2014 configured as AlwaysOn cluster. I've found that full backups are not supported on the secondary replica just read only backups. I have several questions regarding the issue ...
3
votes
1answer
100 views

How to check the health of a SSAS database? And of its backups?

regarding backups of the SSAS databses, based on the following behaviour: Backup on an empty SSAS database hangs Is there a way to check whether or not the SSAS backup is healthy? I would accept ...
2
votes
1answer
300 views

How to verify a SSAS Backup and how to perform Integrity Checks in SSAS?

I have a procedure to backup SSAS Databases that is working successfully. I also delete the SSAS backup files that are older than 2 days. What I am looking forward to implement is: 1) How to verify ...
0
votes
0answers
18 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
1answer
37 views

How to check if a postgresql backup is finished or not? [closed]

I started my backup yesterday, but now I don't know if it is finished or not. Can you please help me?
0
votes
1answer
41 views

“Unrecognized configuration parameter: qreplace_function” trying to backup a database

I am new to PostgreSQL and I am trying to backup a database with the pg_dump utility. I am using this command: /opt/PostgresPlus/9.4AS/bin/pg_dump -U (username) -f ...
1
vote
2answers
101 views

Backing up multiple instance System Databases with distributed Maintenance Plan

I am running maintenance plans on a server, which is running several instances of SQL Server 2104. I have set up a nightly maintenance plan to run backups for all user databases, with the backups set ...