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)

0
votes
1answer
29 views

PostgreSQL-Backup from windows hard drive to linux

I'm in a bit of a pickle here. I managed to copy the whole postgresql installation directory to a backup drive but how would I retrieve it from Linux with the same architecture and version. Is this ...
1
vote
2answers
53 views

Partial backup restore of read-only file group on new database

Let's say, I have a database myModel2015 that contains two file groups - Primary A and Secondary Read-Only B. Then, I am creating a partial backup of the secondary file group. Now, let's create a new ...
2
votes
3answers
379 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 ...
1
vote
1answer
58 views

Is it possible to convert .trn (transaction log) file to human readable form

I have used below SQL statement to get the transaction information done on 2015-10-26, but the information not in human readable form. ** SELECT * FROM fn_dump_dblog ...
0
votes
3answers
111 views

Is it possible to restore database only with .trn files?

How do I restore database only with .trn (transaction log backup) file? I did below two steps Microsoft SQL Server Management studio shows "Restoring". 1) RESTORE DATABASE [database_name] FROM ...
-3
votes
1answer
59 views

Generate Script Of Database in SQL Server 2008 [closed]

How to Create Script for the Database Objects in SQL server 2008 r2 and restore it in database.
1
vote
1answer
87 views

First log backup after FULL taking lots of space

In the backups I'm doing in my database, the first LOG backup I do after the FULL backup is taking too much space, even more than the full backup. For example: 4:50 AM: FULL BACKUP - .bak 7.2GB ...
2
votes
1answer
76 views

Restore a point between two full backups

I make two full backups on Oct 1 and Oct 10. I want to restore the server to a state in Oct 5. So I just do as follows: Perform a transaction log backup on the server on Oct 23. I have never backup ...
0
votes
1answer
66 views

What or Who is taking SQL Server backups [duplicate]

I have inherited a SQL Server 2008 R2 (SP3) Database. There are backups being taken daily at seemingly random times. The backups are not being saved locally on the server. I see the backup information ...
1
vote
1answer
63 views

SQL Server full backup location

I created a full backup with SQL Server 2014 Management Studio. After that I removed it and created Differential backup, everything worked with no errors. How the server knows against what ...
2
votes
0answers
176 views

mysqldump vs mysqlpump

I just heard about mysqlpump - it looks like it was released with MySQL 5.7, however MySQL 5.7 still includes mysqldump. They're both backup programs, but could anyone summarize the main differences? ...
0
votes
1answer
44 views

Why does sys.fn_hadr_backup_is_preferred_replica take so long? Is there a better way?

I am using sys.fn_hadr_backup_is_preferred_replica to query the databases on each of my Availability Group replicas to figure out if the database should be backed up on that replica - then, if the ...
0
votes
0answers
21 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
1answer
82 views

Why take full backups when you can do COPY_ONLY?

With a SQL Server 2012 availability group, you can only take COPY_ONLY full backups on replica. You can make regular BACKUP LOG. As it's possible to restore logs backups after a database restoration ...
0
votes
0answers
22 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 ...
2
votes
2answers
41 views

Deleting data directly from backup file

Is it possible to update the data directly inside the backup file (*.bak) in SQL Server 2014? The scenario is that I want to automate the process of providing the "smaller" database to some ...
2
votes
2answers
52 views

How to optimize performance of backup process? Servers go down during backup

The context - So I am an intern (So I'll appreciate a more noob friendly response) and we have several websites on a server of which we do a backup daily, at midnight. We use MongoDB and there's a ...
1
vote
2answers
214 views

Script to backup all databases

I'm working on automating backups of SQL Server databases on SQL 2008 R2 Express. These backups are initiated daily by the Windows Task Scheduler, which execute a batch file, which in turns executes a ...
6
votes
1answer
566 views

Why do we use FILE = 1 in scripts for restoring a database

Recently when I came across the script for restoring a database, I got a doubt on why we have to use "FILE = 1"? Can't we restore a database without that statement!? Basically, what it is used for?
2
votes
1answer
128 views

SQL Server backup status report

We have 30-40 SQL server instances in different servers (2012 with AlwaysOn). Is there any kind of report that can be made which captures the daily backup status and sends a mail, perhaps, or at least ...
3
votes
1answer
145 views

Ola Hallengren solution, backups not cleaning up

I have about 30 SQL Server 2005-2014 instances, all of which use the excellent Ola Hallengran maintenance script to produce my full/diff/log backups. This has worked for me for years with no issues, ...
1
vote
2answers
47 views

Can I surveillance the backup taken in SQL Server?

I have a SQL Server and I want to put some surveillance on it, to know if someone is taking a backup. I know that I can make an audit to monitoring the backup. But I want to have some kind of trigger ...
0
votes
0answers
27 views

How to backup SQL Server 2014 database with SC Data Protection Manager using SQL script

I'm trying to set up the database maintenance solution for SQL Server 2014 using this SQL script and System Center Data Protection Manager 2012 r2 as a BackupSoftware (like SQLSAFE, SQLBACKUP and ...
1
vote
2answers
112 views

Switching to Simple Recovery - shrinking transaction logs

Standard disclaimer: I am an "involuntary DBA" (a nice phrase I saw in this article) and have done lots and lots and lots and lots and lots of reading on this subject, but am still ...
7
votes
5answers
2k views

Backing up & restoring 10-20 SQL Server dbs to a ~synchronous state?

I need to backup up 10-20 SQL Server 2008 R2 dbs with sizes 10-50 GB, while they are online and used simultaneously by a single enterprise app. I also need to restore them to a state that is largely ...
1
vote
1answer
81 views

How do flush innodb table, copy files, then unlock tables from Windows bat file?

I can successfully execute "FLUSH TABLES myTable FOR EXPORT;" in MySql Workbench. Then I can copy the cfg and ibd files I need, and then I can go back to workbench and run "UNLOCK TABLES" and all is ...
0
votes
1answer
45 views

Backup/restore check data is the same SQL Server

I'm a trainee SQL DBA. I'm using SSMS 2008r2. I've backed up a database and restored this as a new database on a new instance. I want to check to see if the data is the same on both databases. Is ...
1
vote
1answer
39 views

MySQL Incremental backup on Master/Slave

I've a mission critical MySQL Master/Slave config, which I'm backing up with innobackupex. I want to speed it up a little as the backup is about 60GB, so I'm considering something like a full backup ...
1
vote
2answers
131 views

How to change dbid in oracle to specific value?

I want to change dbid of oracle 11g database. Current dbid = 2241883xxx And want to set dbid = 1380515xxx
-2
votes
1answer
47 views

Restored database smaller than the backup file [closed]

The new database created from a restore file is half the size of the backup file I restored from. Why? Original backup settings: Recovery Model: SIMPLE Backup Type: FULL
1
vote
1answer
103 views

Promoting warm standby to master with Postgresql 9.4 using streaming replication

I've currently got 2 database servers running Centos 6 and Postgresql 9.4 (identical clones on the same network). They are set up as a primary and a backup created using pg_basebackup from the ...
2
votes
1answer
93 views

Fast local backup - Very slow backup via Network

Since last week, i'm having this problem. Backups are taking forever to be done if I make them via Network. If I backup the database to a local disk ( or N'nul' ) it's very fast. It's strange ...
2
votes
1answer
57 views

Backing up to Nul on an SQL Mirror

I've seen and read a lot of questions about the transaction log and I know that backing it up to nul is usually frowned upon, however my understanding is that this is from a data recovery perspective. ...
2
votes
1answer
42 views

SQL2012 - Send backup to client via SQL Job

Something I thought would be fairly easy.. We host a website for a client. They would like us to send them a database backup monthly. They have Email limits that make sending via EMail not viable. ...
0
votes
1answer
36 views

Microsoft SQL migration full/diff backup/restore

I would like to move a database from one physical location to another. I already have a copy of the full database backup at the new location which is done by a nightly SQL job and is about 20GB. If I ...
3
votes
3answers
261 views

Understanding the impact/risk of turning off “verify backup integrity” on SQL backup

Currently we use standard maintenance plans for backups on the SQL Server 2005/2008/2008R2/2012 servers in our environment, and the "Verify backup integrity" box has always been checked. Some of the ...
0
votes
2answers
135 views

FLUSH TABLES WITH READ LOCK not working?

I use this command to "lock" my database, flush logs , take a LVM snapshot and release it. Testing the recover + binlogs , appear it's not working. (I discovery this when during the recover, applying ...
2
votes
1answer
100 views

Weekly full backups and daily differential backups, saving the full backups from each week?

I am wanting to create a maintenance plan that performs a full backup that is done every Sunday morning. After work hours on Monday through Friday, I want to perform a differential backup based on ...
0
votes
0answers
78 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 ...
1
vote
1answer
94 views

SQL Server database backup(2012) restore on lower version(2008)

We want to restore 2012 *.bak to 2008 sql server, we don't want to prefer import/export logical backup. Looking forward to know downgrade procedure.
2
votes
1answer
55 views

Should I backup a database with only temporary data?

I have a database, in SQL Server 2008, with only temporary data, but it has tables with a certain structure which I need. Should I back it up? And if I should, should I make one copy of it or should ...
1
vote
1answer
38 views

mongodump replicaset - 10 hours data loss acceptable - do we need --oplog (oplog.bson) option?

We have a 3 node replica set. We take backups from secondary with mongodump. Our customer said that it's ok too loose 10 hours of data in worst case. So we decided we don't need point in time ...
0
votes
1answer
109 views

Restore MySQL Database with only .frm files

One of our servers (running Ubuntu 12.04) recently crashed during a power outage, and MySQL refused to start back up. After a lot of trial and error, I decided to completely reinstall it. Since I ...
0
votes
1answer
59 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
1answer
33 views

Use --databases on mysqldump or not?

I have seen this two ways: mysqldump -u username -ppassword --databases mydb >with.sql mysqldump -u username -ppassword mydb >without.sql I did a linux 'diff' on the two and the with.sql file ...
0
votes
0answers
16 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
77 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 ...
0
votes
0answers
36 views

Backup MYSQL data to HIVE

I have some very large tables in Mysql which I want to backup to Hive. I am using Sqoop for it and it works pretty well. But now, if I have to make any changes in mysql table's schema, I have to ...
0
votes
0answers
22 views

SQL Server schedule DB backup question [duplicate]

I'm new to database administration and I have a general question about the DB backups. I have a full DB backup scheduled to run everyday at 12am that saves backups up to a week. My question pertains ...
8
votes
2answers
684 views

Can't find process that is creating backups

We have an instance of SQL Server 2008 installed on a customer server. The customer's IT department is in charge of the various backups of the machine. The SQL Server log shows there is a full backup ...