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)

8
votes
2answers
152 views

Backing up multiple databases to the same point in time

Usually when we start the backup we do not allow changes to commit or database will be not be accessible. I mean database will be in single user mode but I want to start the backup and release the db ...
0
votes
1answer
16 views

Is it possible to take the table level backup in mysql using any of the script?

I am new to MySQL and I am in need of the script which is taking backup of multiple tables from the multiple databases in single file in MySQL?
1
vote
0answers
19 views

Trouble getting automysqlbackup to keep connection to MySQL server

I am trying to follow the instructions from the following page to set up backups for mysql. https://www.howtoforge.com/tutorial/mysql-incremental-backup-point-in-time-recovery/ However, once I get ...
0
votes
0answers
6 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
1answer
18 views

Export roles *with* privileges under PostgreSQL 9.3

New to backups under PostgreSQL. I've been backing up my database with the general commands, and it works well. Except no users or privileges are stored with it. I understand that I need to do that ...
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 ...
2
votes
1answer
56 views

Why can a log backup not be taken without first taking a full backup?

I've created a new database using the FULL recovery model. Now I am trying to take a log backup without first taking a full backup. I'm aware that SQL Server won't allow us to do so, but I want to ...
0
votes
1answer
77 views

SQL Server BACKUP WITH FORMAT

When doing a SQL Server database backup using the T-SQL BACKUP statement, does WITH FORMAT only wipe out the specified Media Set or does it wipe out all Media Sets 'associated' with the database? ...
0
votes
1answer
38 views

Will an hourly T-Log backup in a Maintenance plan write a file if there are no changes to a DB?

I have an hourly maintenance plan the runs a T-Log backup. Some of my databases may have every hour represented in the file system, while others have some hours "missing" or even none at all. Is it ...
1
vote
0answers
41 views

Backup fails unless compression is enabled

I'm trying to back up a DB to a network share. The backup fails every time with the same error: BackupIoRequest::ReportIoError: write failure on backup device '\\share_name\Backups\filename.bak'. ...
0
votes
0answers
7 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 ...
1
vote
1answer
61 views

Query to back up a PostgreSQL database

I made a CRUD web application that uses a small PostgreSQL database. It is a donors database with the columns name, telephone, blood type, etc. I have some SELECT and INSERT INTO queries, but now I ...
0
votes
0answers
26 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 ...
1
vote
1answer
84 views

How to backup SQL Server database once evaluation period has expired

I'm using Microsoft SQL Server Management Studio from last one month that is evaluation period software. I'm not able to login in management studio. when I enter my user name and password it gives the ...
1
vote
0answers
16 views

I only have the original files of database but no .bak file, how do I restore the database? [duplicate]

We were upgrading a server from SQL Server 2012 to 2014 at work and it was giving us trouble so I passed it off to someone else who, when backing up the SQL Server database, didn't create a .bak file. ...
0
votes
2answers
49 views

MySQL Backup Strategy

We are running the backup from the replication server and it is working good, since we are not facing any other issues, some information for better understanding our strategy: Backup Type: Full ...
1
vote
0answers
37 views

Why does my differencing virtual disk grow so much after restoring a differential SQL Server backup?

Inspired by RedGate's upcoming SQL Instant Clone, I'm using virtual disks to store my test database and gain fast clones via differencing disks. I created a 30 GB VHD and restored a 18 GB database ...
0
votes
0answers
45 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 ...
1
vote
0answers
17 views

Restore log backups to non-readable async AlwaysOn replica [duplicate]

We have 3 SQL 2014 instances in a AlwaysOn Availability Group. Our 2 primary servers are onsite at our primary data center in synchronous replication. A 3rd replica is at our DR site in Async Mode (no ...
0
votes
1answer
40 views

Backup chain for DBs restored from a different server

When a DB is restored from a different server (say, Test is refreshed with Prod), the info on the differential base is brought with the backup. So, the SQL instance will keep relying on the backup ...
0
votes
2answers
31 views

Transaction log backups cleaning

I have a quick question regarding the cleaning of no longer necessary transaction log backups. So, I have a database in FULL recovery mode. Every night, at 10 PM a backup takes place (via maintenance ...
1
vote
1answer
61 views

MySQL Dumper creating multiple files - spamming email confirmations

It's been a little while since I ran mysql dumper, but have done so successfully in the past many times, however when trying now something weird is happening. I had not changed the settings (I have ...
0
votes
0answers
21 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. ...
5
votes
1answer
120 views

Transaction log in the full backup

I have a little misunderstanding when I make SQL Server full database backup. How does exactly full backup work? What data does it backup? Here is a case: I scheduled full database backup supposing ...
1
vote
1answer
40 views

How to backup a secondary log shipped standby mode database

We have a secondary transaction log shipped database configured for standby mode. Its primary purpose is for data recovery and for select only queries for reports etc. As the database is very big we ...
1
vote
0answers
118 views

Types of backups [duplicate]

I'm studying SQL Server and now am learning backup types. I have already learned about most common backups like full, differential and transaction log, but I guess that there are some more, so my ...
0
votes
2answers
43 views

at the moment mysqldump (22 minutes exec time, 5 GB Dump), when to use xtrabackup?

We use the Puppet code for deploying MariaDB. Those are the backup options. mysql::backup::mysqldump: Implements mysqldump backups. mysql::backup::mysqlbackup: Implements backups with Oracle MySQL ...
3
votes
0answers
39 views

What is Data Virtualisation?

I've just been asked whether our company should consider Data Virtualisation for our test environments. The benefits are given as: Screening of sensitive data Fast data refreshes in our test ...
0
votes
1answer
34 views

Window Azure SQL Server DB Backup to a local-Premise

One of my customers stopped subscribing to our services and they INSIST to have their data stored in their local SQL Server. Their data size is quite some amount though. We did try to use the Azure ...
8
votes
4answers
1k views

How are SQL backups different from IT regular nightly server backups?

Our IT department backs up the entire server every night (an SQL Server instance is installed on this server), which should be backing up that server as well as the entire network, in case something ...
1
vote
0answers
34 views

How can I make a database backup faster? [duplicate]

I recently attended an interview for my next job and was asked this: How can I speed up the backup of a database sized close to 1TB or 800 GB in SQL Server? My Answer: We can use Database ...
3
votes
3answers
131 views

How can I make a database backup go faster?

I recently attended an interview for my next job and was asked this: How can I speed up the backup of a database sized close to 1TB or 800 GB in SQL Server? My Answer: We can use Database ...
0
votes
0answers
17 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
1answer
72 views

PostgreSQL : Master-Slave replication strategy and solution for 3 servers.

We have currently 3 servers(X,Y,Z) running Debian X64, two of them host projects(Y,Z), which don't require that much database, as they serve more static content, but the third server(X) is largely ...
-1
votes
3answers
66 views

To take a full backup and differential backup of all databases

Can anyone help me with a script to take a full or complete backup of all databases once in a week and to take differential backups daily. ?
1
vote
1answer
37 views

Differential backups are 2/3 the size of the full backup

I was investigating why my differential backups were taking almost as long as my full backups and I noticed that the size of the first differential backup after the daily full backup was 2/3 the size ...
4
votes
1answer
47 views

Why does Veritas backup take longer through CMDEXEC than cmd?

"c:\...\dbbackex.exe" -f "C:\...\backup.bch" -p policy_name -s server_name -np The above command, when run from command line takes something like 30sec to finish for a small db or transaction logs. ...
17
votes
1answer
319 views

Setting BUFFERCOUNT, BLOCKSIZE, and MAXTRANSFERSIZE for BACKUP command

I am looking for practical guidance for setting the values for the BUFFERCOUNT, BLOCKSIZE, and MAXTRANSFERSIZE of the BACKUP command. I have done a bit of research (see below), I have done a bit of ...
13
votes
3answers
147 views

Transaction Log Backups Serial or Parallel?

We happen to be using SQL Server 2012 Standard Edition. I also happen to use Ola Hallengren's scripts to provide an easy, more flexible framework for doing backups and maintenance. This question ...
1
vote
0answers
33 views

Trying to restore a db2 database but stops at roll-forward with error 'SQL1265N'

I'm trying to restore a backup that is older than the current database. The restore went ok, but the roll forward didn't giving the following error: SQL1265N The archive log file ".LOG" is not ...
2
votes
1answer
70 views

Managed backup to Azure does not delete backup after retention period

I did set up SQL Server managed backup for our databases. I did define retention days to 4, but i just checked the azure storage account where the managed backups are and found that there is still all ...
2
votes
2answers
48 views

Detached DB showing up in back-up history

I found a script to show me the databases that are not backed-up in the last 24 hours: Script to retrieve SQL Server database backup history and no backups SELECT CONVERT(CHAR(100), ...
3
votes
2answers
399 views

Unable to create restore plan due to break in LSN chain

My backup plan is: Full backup - once a day Differential backup - every four hours Transaction Log backup - every 30 minutes. All database backup are stored on my computer. I add some wrong ...
4
votes
1answer
247 views

Full or bulk-logged recovery model?

My database is about 10 GB and I use full recovery model. Sometimes I have to add a lot of data at once and during that time, I change the recovery model from full to bulk-logged. What do you ...
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 ...
4
votes
2answers
81 views

SQL Server backup medianame

If I make full/differential/log backups to disk under full recovery model it is important to specify MEDIANAME? Is it true that MEDIANAME is only for tape backups? If not, when and why should I ...
0
votes
1answer
25 views

SQL Server backup media set and file separation

SQL Server backup media set and file separation If I am going to do such a backup plan under full recovery model for a particular database Weekly full database backup Daily differential backup ...
1
vote
1answer
58 views

What can become a reason of database failure? [closed]

I'm the new one with SQL Server, so, please don't beat me. It's known that one of the best ways to protect your database from the failure is to make regularly scheduled backups. But my question is: ...
1
vote
0answers
20 views

How to restore InnoDB from files

here is the situation I fu*d up my mysql setup, before I did that I copied entire /var/lib/mysql directory to another location. Now fresh installation of mysql is back and I cannot restore my files. ...
5
votes
1answer
117 views

dumping database with “compressed data is corrupt” errors

I'm using pg_dump to dump a large (396 GB) PostgreSQL database: pg_dump --clean --create mydatabase After running for a day, a statement fails with ERROR: compressed data is corrupt and pg_dump ...