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)

1
vote
2answers
2k views

Can I stop a SQL database backup after it has already started?

I am looking to do a full database backup of a SQL database in SQL Server 2008. My questions are: *Can I stop, pause, or cancel the backup after it has started if it is taking too long or slowing ...
1
vote
2answers
1k views

Does a database backup reduce size/increase free space of the log file? [duplicate]

Novice question, sorry! Got a SQL Server database and the log file is massive and keeps growing every day. I've archived data from the database and then done a full backup. I was expecting the log ...
0
votes
1answer
3k views

How can I solve postgresql problem after deleting wal files?

I turned the archive_mode on on my postgresql configuration for testing a backup server . And since the wal files took lots of disk space, after my test I turned it off and also deleted the wal files. ...
0
votes
1answer
66 views

Backup policy for Oracle 11g database in non-archive mode

My database is in non-archive mode and its size is 5 TB (monthly 200 GB increment). Currently we are taking the full backup monthly. As database growth is high, backup size and time had increased ...
1
vote
1answer
444 views

How to take physical backup of MYSQL database

I am trying to find out some tool which can take physical backup of MYSQL database. Like mysqlbackup but it is not open source. There is mysqldump but i want to take physical backup. Can someone ...
1
vote
1answer
1k views

BACKUP failed to complete the command BACKUP DATABASE

Not sure if this is a false-positive issue or not, but I need quell my curiosity about it. I get the following error message: Error: 3041, Severity: 16, State: 1. BACKUP failed to complete the ...
0
votes
2answers
233 views

Error with making backup in sql Server

When I try to backup a SQL Server 2008 database, I have an error. Is anybody know what is the error? TITLE: Microsoft SQL Server Management Studio ------------------------------ Backup failed for ...
3
votes
1answer
153 views

What is the use of Archivelogs?

Hi I am new to Oracle Database . Using Oracle 11g R2 I want to know the purpose of archive logs created at archive log destination, how they are helpful in database backup. Suppose I am having ...
0
votes
0answers
225 views

Please anybody help me with oracle db importing?

I try to import .DMP file with impd comand. root@HP:~# impdp SYSTEM/xxxxxxxxx log=4.log file=as.DMP and i get this ;;; Import: Release 11.2.0.2.0 - Production on Thu Oct 2 12:21:14 2014 ...
0
votes
1answer
59 views

How Can I restore a database to a point of time without Old backup? [duplicate]

I have a database in full recovery mode with five tables. I accidentally deleted one table. I don't have any old backups. Can I restore the database with five tables?
1
vote
3answers
165 views

Restrict user to only take COPY_ONLY backups

Is there a way to force users to only take a full backup with COPY_ONLY so they don't interfere with diff backups? Dev need to take backups every now and then but they don't always remember to use the ...
1
vote
1answer
396 views

MySQL backing up MyISAM tables by copying the physical files - and automating the process

I have 2 databases with MyISAM tables running on a Windows 2008 Server. These databases are about 20GB in size with a few tables with millions of rows. My question regards backing them up on a weekly ...
4
votes
2answers
4k views

Migrate all databases from one SQL Server 2005 to another

We have a production SQL Server 2005 server on which we are hosting 200 databases. We want to host these databases on our new server. On new server SQL Server 2005 is installed and is ready. I want ...
3
votes
1answer
95 views

SQL Server Replication w/o network connection

Is there a way to use SQL Server Replication without a network connection? My would-be publisher is an SQL Server 2005. It is on the "outside" as it is connected to my company's primary LAN, which is ...
1
vote
1answer
892 views

Backups failing for all databases

Here is the error message in its entirety: Failed:(-1073548784) Executing the query "BACKUP DATABASE [MCM] TO DISK = N'F:\Backup\MCM\M..." failed with the following error: "BACKUP DATABASE is ...
0
votes
2answers
175 views

Change SQL Server backup destination while retaining server's knowledge of location

I currently have a number of SQL Server (2008 R2) databases that are receiving tlog and differential backups. The backups are currently being stored on a NAS that is going to be repurposed. I need to ...
1
vote
2answers
2k views

Backup without using SQL Server Management Studio

I am trying to take a backup on a Windows Server 2003 and SQL Server 2005 installed on it. But, there is no SQL Server Management Studio on it. How can I take full backup of a particular database.
2
votes
1answer
59 views

Is tlog backup on replica clearing VLFs on the primary?

Is it true that a transaction log backup made on the secondary database is clearing the inactive VLFs on the tlog file on the primary database (in case of Availability Groups)? I was not able to find ...
0
votes
0answers
84 views

MySQL Cluster online backup vs mysqldump. Automatization of cluster backups

There is some special kind of backups in MySQL Cluster: online backup It creates copies of data at Data Nodes. If I understand correctly this is backup of all data that can be stored at Data Nodes, ...
1
vote
0answers
198 views

pg_basebackup could not get WAL end position from server

I'm trying to pg_basebackup my database. I followed instructions in PG Mauals and set it up properly (check on other server and database), but my backup isn't ending - on end of progress it's ...
1
vote
2answers
89 views

Does a whole-server backup guarantee a reliable backup of running databases?

Many hosts offer a full-server backup once per day. However, I've been told that a backup of this kind doesn't guarantee a reliable backup of running databases, because even if the database uses ...
0
votes
0answers
240 views

pre-process, anonymize, data before creating a dump from sql-server [closed]

I would like to be able to automatically create dumps from a production machine (SQL-Server 2008R2 and up). In those dumps some data needs to be anonymized (mainly by scrambling nvarchar-fields) so no ...
0
votes
1answer
81 views

Reporting Services DBs not appearing in Management Studio, but can be queried?

I've set up a server with native reporting services, connected to a database server which hosts its two databases. I'm trying to run a backup of the two databases so I can add them to my availability ...
0
votes
1answer
1k views

Backing entire Postgres database server up with pg_basebackup

I back Postgres DB 9.1 up using following command: pg_basebackup -h 127.0.0.1 -U replicationuser -D /storage/test_backup -Ft -z -P In postgresql.conf I have this set: wal_level = hot_standby ...
2
votes
1answer
684 views

Percona's xtrabackup --apply-log fails with “all log files must be created at the same time”

I'm trying to figure out why applying logs on my xtrabackup files isn't working. I created a VM running MySQL 5.5.24. Then I created the sakila test database and backed it up with the following ...
2
votes
1answer
1k views

How do I backup/restore database encryption key in order to restore on new server

I am currently in the process of restoring a TDE encrypted database to another instance. I have backed up master key and certificate, and have restored them to the new server fine, but I am still ...
1
vote
1answer
653 views

Transaction Log Shipping Removal, Backup and Drop Database

I have databases (about 15 different) Production Databases set for Log_Shipping and I would like to take a full backup of it and need to drop from production later on because we have already move it ...
0
votes
1answer
53 views

how I Backing Up SQL Server database? [closed]

I am new to SQL Server Admin and am hoping to get some help? I have a database that only contains views of data from another database. It has no tables at all. Is there a way to backup the data in the ...
1
vote
2answers
200 views

What Current Continuous SQL Server Backup Solutions Are there?

With Mirroring being deprecated in SQL Server 2012 and up along with AlwaysON Availability Groups costing $7k per core, I am wonder what options are there for constant reliable backups with a somewhat ...
1
vote
2answers
2k views

How to backup large MongoDB database

What is the recommended way to back up large data sets in MongoDB? Let's say we have a data size in the order of 10TB - how would you back that up? We're considering a hidden, possibly delayed, ...
2
votes
2answers
334 views

Transaction Log Backups

I am working on backup+recovery scenario and I came across a situation where I could not figure out how I would have to deal with it. We have couple databases where sometimes there may not be any ...
1
vote
3answers
402 views

SQL Server 2005 Log Truncate - how long for a 60Gb log; mins, hours or days? [closed]

I have taken over an old website. To cut a long story short the people that host the computer, backup all the database files, but there is no maintenance plan in place for the backup (e.g. they ...
0
votes
2answers
891 views

Access denied to user ODBC, but trying to login as root

I'm trying to do a backup of a MySQL database on Windows, but for some reason it's trying to log me in as ODBC instead of root - does anyone know why? As you can see below the red line, I can login ...
0
votes
2answers
2k views

How to restore operational Oracle 11g Database from full backup?

Imagine that things gone bad and all we have is a fresh Windows Server and full cold backup of our Oracle database. In case of SQL Server 2000/2005/2008/2012 it was really a matter of few mouse ...
0
votes
1answer
124 views

PostgreSQL replication with periodic log shipping

I'm using Windows Server 2008 R2 with 64-bit PostgreSQL 9.2 on both test machines. What I wish to achieve is that one server will be a master and other will be a slave. This is just for tests, finally ...
0
votes
0answers
1k views

SQL Server 2008 R2 backup fails to restore on SQL Server 2008 R2 SP2

My DR SQL Server got automatically updated by Windows update from 2008 R2 to 2008 R2 SP2 and since then I can't restore backups from my production machine which is still on 2008 R2. 10 percent ...
1
vote
1answer
78 views

How to guard against backup corruption due to spurious bit errors?

There's always a very small chance that a backup that was just written to disk is corrupted. Disks are not 100% reliable. Bits can be flipped with very low probability. I have seen that happen on ...
5
votes
3answers
1k views

Avamar SQL Agent running against live SQL Server databases

We use a large company as our service provider. The tech people from that service company are pushing very hard to install something called the Avamar SQL Agent which purportedly will be used to ...
1
vote
0answers
223 views

How to restore everything (including “postgres” role) from pg_dumpall backup

I have a postgres 9.1 server running and I do backups with pg_dumpall -c -f /nfs/backup/fulldump.sql I'm testing restoring the backup to another server with psql -f /nfs/backup/fulldump.sql ...
3
votes
0answers
5k views

how to resolve intermittent SQL backup issue?

We have this issue on aprox 100-300 SQL machines each month and it's never re-occuring. If you re-run the backup it will complete. The problem exists in both win2k8 and win2k12 machines. Backup ...
1
vote
1answer
355 views

Fix transaction log file after database update

I have a databases that are regularly (monthly) updated. An update includes a lot of new or changed T-SQP procedures, functions, indexes creation, etc. A database X has transaction log file with the ...
2
votes
2answers
148 views

Is it necessary to run apply-log immediately after innobackupexec has run?

i have been trying to read other questions, but i did not find a answer to suit me. So excuse me if i ask something that has been already asked. I'm trying to organize my self and backup all my mysql ...
3
votes
2answers
262 views

Copying datadir directory enough for backing up a database with InnoDB tables?

I have an innodb table with 80 million rows and it's extremely slow with mysqldump so I'm thinking of copying the datadir directory for a backup / transfer. I used to copy database with only MyISAM ...
1
vote
1answer
4k views

Automatic backup MySQL Workbench

Is there a way to schedule AUTOMATIC backups for specific tables in MySQL Workbench?
0
votes
1answer
144 views

Backup/restore using OPENDATASOURCE OR OPENROWSET

Has anyone ever successfully taken a backup or restore to another server using OPENDATASOURCE/OPENROWSET? I am not able to use linked servers so I am exploring this idea.
4
votes
1answer
141 views

Optimized Way of Scheduling a Differential Backup

I am working with a data warehouse with SQL Server 2012 and was wondering what would be the most optimized, AUTOMATED procedure for a backup/restore strategy. Current observations and limitations: ...
1
vote
1answer
718 views

Restoring a database, changing recovery model

I regularly make a backup of my production database, then restore the same onto a test database, so developers can always have recent data for testing. The production database uses full recovery ...
0
votes
1answer
252 views

How to retrieve stored procedures from raw data

I have all the raw data from a database that I can't access through the mysql program anymore. I was able to get the tables by copying the .frm files over to the new installation of mysql, but I don't ...
1
vote
1answer
122 views

Maintenance plan backup and reload the same database

I want in my maintenance plan every night to copy the production database to a backup, and reload the newly-created backup into a test database. By reading here: Restore database - maintenance plan ...
5
votes
1answer
198 views

Sql Server Backup to URL (Azure) ERROR

I'm trying to take advantage of the new backup to url function in SQL Server. I have created a valid cert and tried a simple backup, but I get the same error every time no matter what I try. I have ...