Tagged Questions

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

0
votes
1answer
17 views

WordPress MySQL writes during “Flush Tables With Read Lock” are rejected instead of being queued

I'm running into an odd issue when setting MySQL into a brief read-only mode for backup. Reads continue fine during that "read only" minute, but writes are just rejected instead of being queued to ...
0
votes
1answer
52 views

How to restore a database to the latest file in a backup set [on hold]

USE ICT; GO BACKUP DATABASE ICT TO DISK = 'E:\Backup\ICT.bak' -- Verwijder dit bestand a.u.b. GO RESTORE DATABASE ICT_TEST FROM disk = 'E:\Backup\ICT.bak' WITH REPLACE, MOVE 'ICT' TO ...
0
votes
0answers
22 views

Validate MySQL/PostgreSQL backup without running server [on hold]

We have some MySQL/PostgreSQL servers that we already backed up daily. Now we want to validate those backup files to see if any corruption happens. The common way to do this task is just restore the ...
0
votes
0answers
17 views

MySql backup for certain database contents

So i have a database containing custom functions and cleanup procedures and obviously content under tables which i want to back up using automating script which works but doesn't create a proper ...
0
votes
0answers
41 views

Restore from copy of SQL Server backup file produces invalid data error

We have an instance of SQL Server 2008 R2 SP2 sitting in a DMZ. When I back up one of its databases to a drive local to that server, then run a RESTORE VERIFYONLY against the backup file, it declares ...
1
vote
1answer
43 views

Combining log shipping and regular log file backups

Following on from my earlier question, I'm trying to set up a combination of Log Shipping and database backup. What I have in place is: Log Shipping set up between my two servers, to run every 5 ...
1
vote
2answers
82 views

SQL Backup tuning large databases

I am tuning SQL backups using compression, writing to multiple files, and changing the BufferCount and MaxTransferSize options. I have SQL instance with a 4 TB database and several smaller databases ...
0
votes
0answers
42 views

SQL Server : how to decide if FULL backup or DIFFERENTIAL

The following scenario (on SQL Server 2008 R2 and 2012 servers) A co-worker of mine restored another DB into the one our process was trying to create a differential backup for. As I am currently only ...
0
votes
0answers
14 views

How can I import “.sql” file into a new database? (using Python or even IPython)

all! I have a "bakupdb.sql" file which contains tables from a web page (created with Django) and some data (that is inserted into the tables). It's a dump back up data. I don't have anything else - ...
2
votes
1answer
35 views

SQl Sever Backup Exclude Users

I have a database on SQL Server 2012 that I need to backup and send to someone on a different network / domain. Is there a way to create a full backup file that will not include the users / security ...
0
votes
2answers
87 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 ...
0
votes
1answer
21 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
44 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 ...
0
votes
1answer
52 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
1answer
250 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 ...
0
votes
2answers
66 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
160 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
43 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 ...
1
vote
0answers
38 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
64 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
36 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
23 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
109 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
90 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 ...
0
votes
1answer
63 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
73 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 ...
1
vote
2answers
87 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 ...
0
votes
2answers
92 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
132 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
140 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
1answer
36 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 ...
1
vote
1answer
66 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
282 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
70 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 ...
1
vote
0answers
475 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
75 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
32 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 ...
2
votes
2answers
54 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
votes
1answer
342 views

Automatic backup MySQL Workbench

Is there a way to schedule AUTOMATIC backups for specific tables in MySQL Workbench?
3
votes
1answer
108 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: ...
0
votes
1answer
62 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 ...
0
votes
0answers
70 views

hot/live sql backup

please excuse my ignorant question as I am still fairly new to database things so I have a mysql database and a part of it has file with average size of 10M I store them in their own directory and ...
1
vote
2answers
102 views

“WITH REPLACE” Restore failing with same logical filenames

Does using WITH REPLACE when the logical filenames match (to avoid using WITH MOVE) fail when the backup is from a different version of SQL? I have a backup from SQL 2008 but when I attempted to ...
1
vote
2answers
95 views

How to deal with very large transaction logs in SQL Server [duplicate]

Here is my situation: I have being asked to deal with a SQL Server 2008 R2 database that has a transaction log that is several times bigger than the database itself. The database is in full recovery ...
0
votes
1answer
73 views

SQL Server 2000 Backup fails with Status = 33

I am trying to take a Full Backup of a database size about 75GB. It is SQL Server 2000 - 8.00.2055 x86 version. I have plenty of disk space where the backup is being created. So disk space isn't an ...
0
votes
1answer
53 views

Script to Add a Job to a SQL Server DB

I want to add a job to my DB to make a back up weekly but i want to do it from an script, i've serched and with what i found i made this: CREATE SCHEMA job go CREATE PROC BACKUPS @dir varchar(max) AS ...
0
votes
1answer
64 views

Restoring pg_dump hangs

Aim: backup a database and restore it in database2 pg_dump A PG Dump has been created by issuing the following command: c:\Temp>pg_dump -U postgres postgres > backupTest2.sql Opening ...
0
votes
3answers
75 views

What is the quickest way to restore a DB

Lately I have been finding myself restoring a DB to my local instance of SQL-server a lot more. I wanted to speed up the process by writing a script and then just executing it in order to restore over ...
0
votes
2answers
86 views

Is it safe to copy DB files directly from an LVM snapshot?

I saw two different approaches for backing up database with LVM snapshot. This article suggests spawning another MySQL instance to do an SQL dump. MYSQL Performance Blog suggests that it is safe to ...
1
vote
0answers
84 views

1 TB Database import, best options? [closed]

Friends, We have received 1 TB external hard drive with 750 GB MS SQL server zipped backup file in it from our client. We need to import this database at our end and then write programs to retrieve ...