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
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
974 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
22 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
52 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
84 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
96 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
55 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
79 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
111 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
108 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
427 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
29 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
34 views

Backup corruption in logs [closed]

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
126 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
262 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
142 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
98 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 ...
0
votes
1answer
58 views

Fullbackup + Differential/Copy-only

We have a PROD full backups copied over to support envs daily and we restore to support environments to triage some issues, as the DB is growing big we would want to run the full backup copy only on ...
0
votes
1answer
81 views

MySQL backup practices

I have a MySQL master-master replication with second master in read-only mode. My questions reg backup are: I have 10 databases so should I take daily backup as one dump containing all the ...
0
votes
1answer
580 views

How to copy tablespace from one database to another database in Oracle 11g

How to copy tablespace and datafiles from one database to another database in Oracle 11g in same server ?
0
votes
1answer
24 views

Mongo DB Site to Site Migration

I am somewhat new to MongoDB but I do have some experience with MySQL and PostgreSQL. Currently, I need to migrate Mongo DB from one site to another. The sites should be identical (development and ...
2
votes
2answers
245 views

How to backup the current code of a stored procedure and its permissions as well?

I often get requests to alter stored procedures, in both test, development and production environments. I would like a simple way to save the current code of the stored procedure, before the changes, ...
1
vote
1answer
45 views

Looks like a postgres backup/dump structure (A sort of a forensic/data archeology question)

I was given a compressed folder that contains number of subdirectories, and, among others, directories named .pgdir with number of numerically sequenced files in a <9999>.dat.gz format and one in a ...
1
vote
2answers
112 views

Backing up multiple instance System Databases with distributed Maintenance Plan

I am running maintenance plans on a server, which is running several instances of SQL Server 2104. I have set up a nightly maintenance plan to run backups for all user databases, with the backups set ...
5
votes
1answer
128 views

SQL Server restore differential after restoring full backup

Here is the situation: I had a full backup, and a differential backup. I have restored the full backup into the database. But accidentally lost that backup file. Now I would like to apply the ...
-1
votes
1answer
186 views

How to reduce the size of ldf file? [duplicate]

We take full backups of the DB every day (in full recovery mode) and keep them for 10 days. Because of our requirements, we don't want to take incremental or differential backups of the DBs. Now we ...
2
votes
0answers
224 views

Issues with mysql enterprise backup, assertion failure on restore

I'm trying to restore a backup to a new server, but having some issues with corruption. The source server has a 2.5T table which is very active. I copied the latest backup over to a new server and ...
2
votes
1answer
2k views

pg_restore: [archiver] did not find magic string in file header

I'm using PostgreSQL 9.1 and want to restore backup files generated with pg_dump: sudo pg_dump -h 127.0.0.1 -U postgres --clean --inserts -E UTF8 -f out.sql database_name This command generates a ...
0
votes
0answers
73 views

Percona: Innobackupex failing when taking incremental backup

I have been trying to take incremental backup as below and its getting error all the time. Innobackupex 2.1.8 Linux x86_64 Mysql 5.5.45 Step1: innobackupex -uxxx --stream=xbstream datadir > ...
1
vote
1answer
125 views

SQL 2014 AlwaysON Backup

I have 2 SQL server 2014 configured as AlwaysOn cluster. I've found that full backups are not supported on the secondary replica just read only backups. I have several questions regarding the issue ...
0
votes
2answers
181 views

Understanding RMAN Backupset

I feel a bit confused when I read about RMAN! what are the differences between: RMAN> backup as backupset RMAN> backup database; RMAN> backup database plus archivelog; RMAN> backup ...
3
votes
3answers
251 views

Putting the database in backup mode before making file system changes

We are planning to make a small change in the Linux file system. To be on the safe side, I thought I would take a SAN-level snapshot of all the drives beforehand. I was thinking I should put the ...
2
votes
1answer
123 views

Does a database backup include all files? [closed]

If I have two files in my database (mdf & ndf), when I do a backup of the database with the statement: backup database mydb; are both the two files are backed up?
3
votes
1answer
463 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 ...
0
votes
1answer
48 views

Automate Backup of SQL Server Database Structure

I have a data warehouse which isn't huge only about 16Gb in a Microsoft SQL Server Standard Edition 2014 database. However, now that it forms part of our production system I don't like developing on ...
3
votes
1answer
111 views

How to check the health of a SSAS database? And of its backups?

regarding backups of the SSAS databses, based on the following behaviour: Backup on an empty SSAS database hangs Is there a way to check whether or not the SSAS backup is healthy? I would accept ...
1
vote
0answers
380 views

how to pass the “file path” as a parameter in powershell?

I have recently added a SQL Server JOB on SERVER-A that goes to SERVER-B and backups all the SSAS databases. This seems to be fine. However when I want to delete backups older than 3 days, using ...
2
votes
2answers
61 views

How do I define the frequency of my mongo backup

I want to know if there is a way to define in Mongo the frequency of backups have to be executed. There is any config file for that? An example will be excellent!! UPDATE I want to create a ...
0
votes
0answers
65 views

.dmp file generating problem on oracle

I have a server windows2003 with oracle 10g and developer 6i. My experience is when I install developer 6i first and then install database 10g then .dmp file generate perfectly using imp or exp. but ...
0
votes
0answers
44 views

Checksum mis-match found on a table while restoring data using mysqlbackup

We are trying to restore MySQL data (which was backed up using a single image) using the mysqlbackup utility. But, all of a sudden, it is showing checksum mis-match for table t1 Our questions ...
3
votes
0answers
48 views

Compress backup taken from two different environments take different time to restore

I have two backup files one from Normal SQL Server and one from SQL Server from Azure VM. The restore of these backup files is totally different from each other. Though the database backups are ...
0
votes
1answer
247 views

what is the fastest way to restore MySQL database without using dump files [closed]

what is the best procedure to quickly restore the MySQL database without using dump files. can any body help me in this regard. Thanks in advance.
2
votes
1answer
129 views

Database Backup - In Process - Power Outage

I am using SQL Server 2008 R2. What happens if a database backup (Full/Differential/Transaction Log) is in process and there is a sudden power outage or the system crashes? Does that corrupt the ...
0
votes
1answer
62 views

RMAN archivelog backup in Oracle 11gR2

I use below command to do RMAN backups on rhel 5.9, but archivelog backups always ends up in $ORACLE_HOME/dbs Backup as compressed backupset database plus archivelog format '/path' How to use ...
4
votes
1answer
6k views

I/O is frozen on Database & also I/O was resumed on Database on daily basis in log with complete Backup

I would like to say that as on daily basis i got the message in my log file. First The I/O is frozen on Database (DatabaseName) message appears in log. The message is like I/O is frozen on ...
1
vote
1answer
67 views

Migrating all MySQL databases from from one server another. Getting error during import

I create a mysqldump on all the databases on the source server with this command: mysqldump -h mysql-01 -u root -p --all-databases > newdump.sql This takes about an hour, but runs fine. Now, ...
1
vote
1answer
51 views

Restore Postgresql data after hdd crash

My HDD crashed, so, I can't make a Postgresql backup. It seems that my data tables are OK (I can view the data via pgAdmin). However, when I run pg_dump I get this: pg_dump: Error message from ...
0
votes
1answer
152 views

ASM RMAN BACKUP FAILED

I'm trying to migrate a filesystem to ASM but when I start with RMAN backup, I face the following error, which is weird because I haven't performed any backups before on the same database. RMAN> ...
1
vote
2answers
273 views

Cannot open backup device Error

I have a SQL Server Agent job that backs up a database on a remote server to a network drive. Linked Server, I believe is set up correctly but I get the following error: Msg 3013, Sev 16, State 1, ...
7
votes
0answers
2k views

Mongodb incremental backups

I was given the task to setup incremental backups for mongodb replicaset, as start point of course I googled about it and could not find anything on mongodb docs, I did find however this question ...