Questions tagged [backup]

Making copies of data which may be restored after a data loss event or to recover data from some earlier point in time.

Filter by
Sorted by
Tagged with
6
votes
3answers
2k views

Mysqldump treats some table as View

When doing a mysqldump, some tables are being skipped because mysqldump treats them as View rather than Table although they're 100% tables. So for some tables it looks like -- Retrieving table ...
6
votes
1answer
381 views

What 'resets' the transaction log

I'm trying to create a backup plan which creates a full backup twice a day. A differential backup every hour and a log backup every 5 minutes. It works fine but I've noticed the log backup (.trn file)...
6
votes
3answers
6k views

Is SQL Server's FILETABLE suitable for storing large files (bigger than 10 GB)?

There is a project for lab. The requirement to save the lab data (raw data and related infomation ) for research for years. So the data must be saved for years, but the data is so big, every raw ...
6
votes
5answers
663 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. ...
6
votes
2answers
8k views

List DB2 backups

Is there a way to list the DB2 backups? All I can find is db2 list history backup all for <dbname> but I think you need to check through all of those to see if they've since been deleted. This ...
6
votes
2answers
6k views

Is there any way to replace sql server file_guid with new GUID?

I have two databases with same file_guid. Getting following error when trying to restore second database in Amazon RDS. Aborted the task because of a task failure or a concurrent RESTORE_DB ...
6
votes
4answers
5k views

Is mysqldump a “hot” backup kind?

I see in the documentation that the database backup tools are divided into four categories: hot backups, cold backups, physical backups and logical backups. I understand the the most important ...
6
votes
2answers
9k views

Is it possible to Clone a RedShift Database?

For some test and development work we would like the ability to routinely clone existing RedShift databases (all schema and all data). Something like a backup-restore. The best I can find starts by ...
6
votes
3answers
12k views

How to retrieve master log position and master log file in shell script

I'm writing a shell script for point in time recovery for MySQL database.For the below statement I need to specify the start position and end position of a log file. mysqlbinlog --start-position=...
6
votes
4answers
14k views

how to dump a single stored procedure from a database

I need to create a dump file that contains a single stored procedure from a database, not all routines. I've tried something like this: mysqldump -u root -pssmart --skip-triggers --no-create-info --...
6
votes
3answers
14k views

Can anyone explain to me the concept “incarnation” in Oracle database in an easy-to-understand way?

The Oracle documentation describe incarnation as: incarnation A separate version of a database. The incarnation of the database changes when you open it with the RESETLOGS option, but you ...
6
votes
1answer
4k views

Does my choice of pg_dump format impact restore speed?

According to the docs for my version of Postgres (8.4.2), pg_dump can "output in script or archive file formats." The script-formatted dump (4GB) takes 1.5 hours to restore, and I'm wondering if the ...
6
votes
2answers
15k views

RMAN-06054: media recovery requesting unknown archived log, Where is SCN kept?

I have the following situation: Backups of DB1(located on srv1 server) database are taken everyday at 1:00 AM. I took backed up files(datafile,archivelog,controlfile,spfile) of 24/10/2011 and ...
6
votes
2answers
6k views

Why is mysqldump file so large?

We have a 2GB MySQL DB. We started a mysql dump of this DB this morning and the resulting dump file is 27GB! Can anyone shed some light on what's going on here? Questions Why is this file so large? ...
6
votes
3answers
495 views

Azure SQL Database Restore after Server Failure - Where are the Backups?

According to this article, an Azure SQL backup can be used to "Restore a database to another geographical region. This allows you to recover from a geographic disaster when you cannot access your ...
6
votes
1answer
698 views

Difference between Replication and Erasure coding techniques

I hope I am asking in the right community, If not, any suggestion will be appreciated. I am doing a survey paper where I am doing a comparison between erasure coding and replication techniques. At ...
6
votes
1answer
601 views

Why can a differential backup not be copy-only?

I have noticed that copy only backups does not allow for differential backups. What is the reason the copy-only backup option is disabled for differential backups?
6
votes
3answers
10k 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 ...
6
votes
2answers
18k views

Restore .Bak file to different Server

I Copied some database backups from one server to another server(new instance no databases are present).I tried restoring using below command Restore database dbname from disk='g:\e2bak\dbname.bak' ...
6
votes
4answers
4k views

Backup and restore “mysql” database

I use the following command to backup some normal databases: mysqldump --host=host --user=user --password=passwd --result-file=result.sql -R --single-transaction database_name My question is : do I ...
6
votes
2answers
2k views

Transaction Log Truncation with Copy Only

I have a database backup job set to use full backup with the Copy only option on once daily. The copy only is on because from what I have read that is the only way to backup a database that is ...
6
votes
1answer
679 views

How to back up a small database in SQL Server 2008 R2 Express Edition

I will shortly be migrating a database from SQL Server 2000 (part of SBS 2003) to SQL Server 2008 R2 Express Edition The database is small, and there are only a few hundred short transactions per day ...
6
votes
1answer
10k views

MySQL - MySQLDump problems with large table

I have a MySQL database that is 10.6GB - that has both MyISAM & InnoDB tables. One particular table (called 'responses') is 8Gb - this table is InnoDB. The live database is replicated to a ...
6
votes
2answers
4k views

Does .bak file also contain backup of ldf file?

I am running MS SQL Server, which is holding mdf and ldf files of sizes 110 GB and 245 GB respectively. My question is, if I take .bak backup of said database, will it result in 355 GB (110+245) ...
6
votes
1answer
5k views

Which are the minimum privileges required to get a backup of a MySQL database schema?

Which are the minimum privileges required to get a backup of a MySQL database schema? I am interested only on the schema, not on the data. Are SELECT privileges required?
6
votes
1answer
3k views

Are there performance benefits to turning off archivelogging? Is it wise?

The first part of the question is pretty simple; has anyone run a DB in both archivelog and noarchivelog mode? Were there any measurable performance benefits to turning off logging that you could ...
6
votes
4answers
205 views

What is the best SQL server backup strategy for large DB with few tables and lots of immutable data?

We have a large DB (500GB and expanding). 95%+ of the data is stored in 3 tables (one table has 2bn+ rows). The data is largely immutable - i.e. once it's added it's only then read afterwards. We can'...
6
votes
2answers
764 views

SQL Server Backup transaction error

Hi I am attempting to backup the transaction log file to setup mirroring in SQL Server I execute BACKUP LOG CUSTOMER TO DISK ='K:\JonDB\CUSTOMER.trn' WITH INIT GO And I receive Processed 6587361 ...
6
votes
2answers
47k views

Archive Logs filling up Flash Recovery Area (FRA) space

I got hired to fill a position of DBA that I wasn't quite ready to fill, and while the training is getting me there, I am running close to a potential issue. My oracle 11g database's Flash Recovery ...
6
votes
3answers
9k views

how to restore differential back daily basis on sql server DB

Im working with SQL Server DB, what i need is that i have a DB1 and clients site communicate with this DB,Reporting module of the application is also using the same DB (i-e That shows different ...
6
votes
4answers
506 views

Only do log backup if necessary in SQL Server

We have transaction log backups taken every few minutes from many databases. Is there a way to determine if there were any committed transactions since the last backup and only then do a log backup? ...
6
votes
1answer
3k views

How to create a SQL Server 2008 backup without logs with mirroring

How do I create a backup of a SQL Server 2008 in a mirrored setup without any logs? We need to do this so that when we restore our local development databases, we would have the most up to date data,...
6
votes
2answers
14k views

Why is my MySQL dump file and my phpMyadmin export file different sizes?

I am looking to create a cron job to backup my MySQL database. I am using this command: $ mysqldump --user="User" --password="Password" -A --single-transaction > /home/user/Export-`date +"%F"`...
6
votes
2answers
3k views

Transaction log is growing very fast

One of our SQL Server 2014 database transaction logs is growing very fast and I cannot find the root cause for this. Database in Simple recovery mode. During full backup the log file grows to its ...
6
votes
1answer
2k 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 ...
6
votes
2answers
21k views

SQL Backup issues / Operating system error 995

Last night backups of some databases failed. Backups are being performed using CommVault. Below is error message in SQL Server logs 01/05/2016 23:03:58,spid58,Unknown,BackupVirtualDeviceFile::...
6
votes
1answer
749 views

SQL Server Backup Schedule Overlap

I have a SQL SERVER DB that i want to backup via automated schedule (using GUI maintenance plan) . I have 2 choices when configuring a schedule : 1) do not bother about log backup , full backup and ...
6
votes
2answers
507 views

Understanding Backup Types

I have recently started a role as a junior DBA... Yesterday I created a new database for a co-worker and my boss asked me to make sure we get a backup plan on it asap. I didn't think much about it, ...
6
votes
1answer
6k views

Backup a database with a huge number of tables

Is there a way to backup a PostgreSQL database with a huge number of tables? An attempt with pg_dump for a database of about 28000 tables resulted in the following error message: pg_dump: WARNING: ...
6
votes
2answers
547 views

SQL Server Transaction Log Initial Data Load

What is the standard process when initially populating a database with 5GB+ to avoid a large transaction log? From my understanding the log file would jump to a large size after the initial load and ...
6
votes
1answer
922 views

Copy a SQL Server 2000 database to another box without interrupting the backup chain

I have a small-but-important MS SQL Server 2000 database that I'd like to copy to a development box. I understand that the usual way to do this is to make a copy of a full backup file, and restore ...
6
votes
2answers
1k views

How to automatically stagger transaction log shipping to minimize bandwidth usage peaks?

The following question pertains to Microsoft SQL Server transactional log shipping (TLS). We're using SQL Server 2008 R2 SP1, although the question is probably relevant for all recent editions. ...
6
votes
1answer
514 views

RESTORE VERIFYONLY locks file in Azure Blob Storage

I'm using SQL Server 2012 SP2 to backup my transaction logs directly into Azure Blob Storage using the BACKUP TO URL statement. I am then attemtpting to verify my transaction log as follows: RESTORE ...
6
votes
2answers
12k views

Set database offline with rollback immediate takes an hour to complete

Every night we take our production database offline, detach it, and then re-attach it to sever any active connections before start of our backup procedures. The first command is: USE master ALTER ...
6
votes
2answers
1k views

Best practice for securely backing up RDS Postgres “offsite”?

We're running Postgres on RDS, which is largely great. The big issue with it, however, is to do with AWS' security model, which allows anyone with various permissions to delete everything - your DBs, ...
6
votes
1answer
3k views

Best strategies to have a backup of an RDS MySQL database

I have an AWS RDS MySQL database. I'm not a DBA, so my knowledge is limited. I wish to design strategies to have zero data loss in case of a failure, in terms of replication or data backup. I know ...
6
votes
1answer
749 views

Backup to three drives suddenly slow

The situation: I have a 1.3 TB Database (SQL 2005) that I am currently backing up to 2 network shares on separate machines and on one local USB. (Don't ask why - long story involving a DBA that quit ...
5
votes
5answers
5k views

Can I restore a database to a point of time without backup?

I have an SQL 2005 database with logging set to FULL but without any backups. Is it possible to restore it to a point of time?
5
votes
5answers
9k views

How can I tell if a SQL Server backup is compressed?

We have recently upgraded from SQL Server 2005 to SQL Server 2012. Under SQL Server 2005 there is no option to create compressed backups as there is in 2012. If you attempt BACKUP DATABASE ... WITH (...
5
votes
2answers
1k views

Do I need full recovery mode when I have multiple daily backup?

I have created 5 maintenance plans on my SQL server (say 50 !) which generate databse backup 5 times daily. As I read in this Q/A the full recovery is good when I need Point-in-time recovery. My ...