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
58 views

Simple or Full Recovery

I have numerous replication subscribers that have to have backups done to keep log files under control. They do get a LOT of inserts/deletes during the day. I have been using simple recovery because ...
1
vote
1answer
456 views

DB2 - question regarding RESTORE OFFLINE backup and Archive Logs

I configured last night DB2 to be in Archive Mode. I created required offline backup at 23:00 last night. First online backup will be created at Friday night. Archive logs now keep coming to the ...
2
votes
1answer
31 views

onsite and offsite backup question

We have an sql database of 165GB (includes filestreaming) and we do an onsite full backup every evening using veritas. We would like to also have an online backup in place just so that we don't need ...
5
votes
6answers
5k views

Backup sql database directly to FTP server

Is it possible from SQL Management Studio to create a backup directly to an FTP server? Basically, instead of choosing the destination to a disk, I sould like to be able to specify an FTP location ...
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 ...
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 ...
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 ...
-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.
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
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
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 ...
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
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 ...
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 ...
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 ...
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? ...
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 ...
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
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 ...
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, ...
6
votes
8answers
12k views

Taking backup of all the databases in SQL Server

I have a Microsoft SQL Server 2005 DB server. In the DB server, I have around 250 user databases. I have to take a back up of all these databases. Since, manually taking backup consumes lot of time, I ...
1
vote
2answers
215 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 ...
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 ...
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 ...
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 ...
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. ...
4
votes
2answers
2k views

Does a MyISAM table locks if I copy it while MySQL is running? (READ DISCLAIMER)

DISCLAIMER: I'm very aware this is not supposed to be done, but time consistency between tables aren't a concert here and Im trying whatever pops in my mind right now to have alternatives for ...
2
votes
1answer
253 views

Use pg_dump with postgis extensions?

I'm using Postgres 9.4. I'm trying to dump a database (both the schema and the actual data) with the PostGIS extensions (set up using CREATE EXTENSION): $ pg_dump prescribing -U prescribing -h ...
1
vote
2answers
113 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 ...
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
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
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 ...
-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
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. ...
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 ...
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.
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 ...
1
vote
1answer
399 views

Backup error: Failed to flush the commit table to disk

When I try to backup a SQL Server 2008 database, I receive an error: Backup failed for Server 'SQL2008TEST'. (Microsoft.SqlServer.SmoExtended) Failed to flush the commit table to disk in dbid 32 due ...
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 ...
0
votes
1answer
280 views

difference between pg_dump command's --column-insert and --attribute-insert

Background: I'm trying to create a dump file that only contains the data in my database. I would like it to create the data with the INSERT command. In reading the manual, ...
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 ...
4
votes
3answers
21k views

SQL Server 2008 Database Restore Error - Cannot open backup device 15105

I am trying to restore from a backup and getting the following error Msg 3201, Level 16, State 2, Line 1 Cannot open backup device 'Z:\FULL_BACKUP.bak'. Operating system error 3(failed to ...
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
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
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 ...