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)

2
votes
2answers
49 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
58 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
352 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
1k 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
191 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
244 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
49 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 ...
1
vote
0answers
58 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 ...
11
votes
5answers
2k views

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

I need to backup up 10-20 SQL Server 2008 R2 databases with sizes between 10-50 GB, while they are online and used simultaneously by a single enterprise app. I also need to restore them to a state ...
1
vote
1answer
105 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
50 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
41 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
223 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
50 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
144 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
139 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
85 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
56 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
54 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
656 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
202 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
150 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
105 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 ...
4
votes
5answers
71 views

Which type of backup does a SQL Backup file store?

I want to know, which type of backup does a SQL Backup file store? A full backup, differential backup or transaction log backup?
1
vote
1answer
215 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
51 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
123 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
0answers
73 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
42 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
18 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
123 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
53 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
919 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 ...
1
vote
0answers
19 views

Split Mirror Backup in db2

In my database apart from storing the daily backup, the disks are getting used for other purposes also. So how can I do the disk mirroring for Split Mirror Backup if I don't use external storage?
0
votes
1answer
48 views

How do I update my database generated pg_basebackup through WAL files?

Following on from this post... I have a backup generated by pg_basebackup regularly, I would update it through the WAL files. What is the best way to do it?
1
vote
1answer
79 views

How I compact WAL files?

I like compact WAL files. Actually I do: archive_command = 'cp "%p"C:\\%f"' What is the best way to do it?
3
votes
2answers
91 views

How to write “Verify backup when finished” in T-SQL?

In SQL Server one can cross an option under Reliability which says "Verify backup when finished", when one makes a backup through the management studio. How can I write it in T-SQL? (I want to write a ...
1
vote
0answers
54 views

Best method for daily incremental copy of Postgres database

I'm trying to figure out the best plan of attack for making a nightly copy of our Heroku PostgreSQL production database to our local development environment. The database is rather large and grows ...
1
vote
1answer
72 views

How I create backup with backup by dump and WAL files in PostgreSQL?

I have a backup and WAL files, I like update my backup with WAL files. Anyone know how to do it? Thanks
1
vote
2answers
104 views

My Backups Broken

Our SQL server was running with a Domain Admin user for the SQL Service account. Our backups are accomplished with a script: DECLARE @name VARCHAR(50) -- database name DECLARE @path VARCHAR(256) ...
2
votes
1answer
103 views

How is my database being backed up?

I'm using SQL Server 2008 R2. Someone else set everything up. I encountered an error today: Autogrow of file 'ASPState_log' in database 'ASPState' was cancelled by user or timed out after 1748 ...
1
vote
1answer
394 views

How can I pass the server name as parameter for a XMLA script?

I have a PROCEDURE sp_backupSSAS - it backups SSAS databases. it works fine. I had previous problems with it, but they were sorted out here: routine to backup ssas databases fails with: The XML for ...
0
votes
2answers
27 views

When to use full backup or full backup and then differential backup [duplicate]

There is a SQL Server 2012 database that has the following configurations Recovery mode : Simple Backup Schedule : Full backup at 01:00 hours daily as well as differential database backup 13:00 ...
1
vote
0answers
32 views

Backup corruption in logs

Good Morning Everyone, Full backup job failed today. I checked the job history, logs and found backup corruption in the logs. Could you please advise on how to fix this. Also, how to make sure the ...
1
vote
2answers
114 views

parse rs.status() output to display one secondary node for mongodump destination

I wish to run mongodump to secondary (not primary). So I need as output hostname and port of one secondary. # ./mongo -udbadm admin --port 27100 -p --quiet --eval ...
1
vote
3answers
248 views

What all files are required for restoration process of SQL Server in Full + Diff + Transactional backup policy

I am reading about different types of backup policy in sql server. I am not clear with backup policy for Full + Differential + Transactional backiup My main attention is towards what all files would ...
1
vote
1answer
119 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 ...
2
votes
1answer
97 views

One SQL different Results by using SQLOLEDB or MSDASQL

I'm using VB6 with SQLOLEDB and MSDASQL. By switching the provider I notice that I'm getting different results with one query. My query checks some server settings and executes one of two BACKUP ...