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

How can I open .SBF or .SBD files?

I need to read some .sbf and .sbd files but I don't find any software for it. I have downloaded FileViewPro but when I try to open .sbf file, appears an error. A lot of thanks for your assistance
0
votes
1answer
18 views

How to do 10 G Database recovery without archive logs but available redo logs, ctl files and .dbf files

My client's Oracle 10g database crashed abruptly on Win 2003 NT. The oracle was installed on C drive and redo logs, ctl files and .dbf files were in D: It was unable to backup C: but successfully ...
3
votes
3answers
33 views

Is mysqldump a “hot” backup kind?

I see in the documentation that the database backup tools are divided into four categories: hot backups, cold backups, physical backups and logical backups. I understand the the most important ...
1
vote
1answer
15 views

Issue with running multiple mysql commands in a bash for loop

I try to restore some .sql backups using a shell script with a for loop. I run by bash command.sh 'password' using the command.sh below. However, when I typed it out, it didn't run and instead, mysql ...
1
vote
1answer
31 views

How to restore MySQL databases from database files?

Our MySQL on Ubuntu 15.04 stopped working after we moved the computer to a new location and kept giving the missing socket file error. We couldn't really fix it after trying sudo apt-get install -f ...
1
vote
2answers
422 views

Recommendation about mysqldump?

I have approx 90 GB sized database, and I need to schedule a mysqldump backup. How long will it take to perform a full hot backup approximately? I'm asking because I've never had to backup a database ...
1
vote
0answers
8 views

Progress of mongodump operation jams at a random point

We are executing remote mongodumps to backup collections. For some time now sporadically one of these dumps stops to progress any further and remains to log out the same amount of documents processed ...
0
votes
1answer
29 views

Is it possible which documents couldn't be dumped using “mongodump”?

I am removing historical data from a collection in MongoDB (3.2), but first I need a backup of it. The choice has fallen, a simple combination of: mongodump --db myDatabase --collection myCollection ...
3
votes
3answers
290 views

Hyper V replication - vs - sql replication solutions

I need to establish an offsite copy of a number of production servers, including SQL server. Hyper V replication has been chosen as a simple solution (all servers are virtual). This is to supplement ...
1
vote
2answers
278 views

SQL Server hangs during backup on EC2

Once and then our SQL Server will "hang" during its weekly full backup. When this happens, external connections start to timeout. The symptoms are: Connections timeout The sqlservr.exe process sits ...
1
vote
1answer
137 views

How to backup SQL Server database once evaluation period has expired

I'm using Microsoft SQL Server Management Studio from last one month that is evaluation period software. I'm not able to login in management studio. when I enter my user name and password it gives the ...
-5
votes
0answers
50 views

Is it possible to take MS SQL Server 2012 backup in particular date range? [on hold]

Is it possible to take MS SQL Server 2012 backup in particular date range?
0
votes
0answers
12 views

Restoring a backup of 1 database to another puts both databases into Restoring mode

We have a 2 databases- Staging Test At times, we refresh out Test environment with a copy of Staging. We do this by taking a full backup of the Staging database and restoring it over the Test ...
1
vote
2answers
297 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, ...
0
votes
2answers
61 views

Backup encryption questions

We're going to be implementing encrypted backups in SQL 2014 soon and I'd like to know the gotchas or lessons encountered by anyone else who has done the same. I've read up at MSDN and elsewhere, ...
0
votes
0answers
30 views

Backup /www/ directory and all mysql databases

I'm trying to write simple shell script which will zip all databases + www directory. I don't know what is the problem but I've got wired output. I've got zip with .sql file full of hieroglyphics... ...
0
votes
0answers
20 views

Import databases using /var/lib/mysql

I've got some issues with my server, leading me to completely reinstall my debian OS. Before reinstalling, I backed up some files on the server and now it reveals that I have a backup of my previous /...
0
votes
2answers
122 views

Which files in the “MySQL-5.0.27-win32” folder do i need to backup?

Ok, I am using a pretty old MYSQL "mysql-5.0.27-win32" and the file and the structure maybe different from the latest Mysql (mysql 7). Here is the current structure of of mysql-5.0.27-win32: In "...
4
votes
1answer
8k views

Problem with View When Restoring a MySQL Backup

I have a database (InnoDB) with some tables, views and routines... Periodically I do a backup using the command line: mysqldump -u user -ppassword --routines db_name > backup.sql But I have a ...
1
vote
1answer
22 views

Can I specify the default backup location for non-automatic backups?

I noticed that when the BACKUP DATABASE command is issued without the TO clause the backup file is stored to the working directory where the command is issued. I'm wondering if it's possible to ...
0
votes
1answer
31 views

Migrate Database

I'm trying to migrate my database to another server, an older version. Currently my database is on SQL Server 2014, but I need to add migrate it to a SQL Server 2012 because thats the one my server ...
1
vote
2answers
1k views

DB2 ROLLFORWARD option “TO END OF LOGS” - does it read archive logs?

I read about ROLLFORWARD option on link http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0001978.html?cp=SSEPGG_9.7.0%2F3-6-2-4-106 but I could not find ...
2
votes
1answer
52 views

Race condition on incremental backups

I am planing to automate to take incremental backups on a range of sql servers from 2000 to 2012, on a variety of windows too. This will be done with a vbs script that runs on task scheduler. I want ...
-3
votes
1answer
121 views

Downgrade backup from SQL Server 2014 to SQL Server 2012 [duplicate]

Im trying to restore my database on my server, but i got the following error: The database was backed up on a server running version 12.00.2269. That version is incompatible with this server, ...
0
votes
1answer
129 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
29 views

mysqldump: Got error: 1049: “Unknown database 'xx'” when selecting the database - because database deleted during backup? DBaaS

I receive this error during dump (runs a few hours, because 31 GB data files) mysqldump: Got error: 1049: "Unknown database 'ZETF_353D082E_422C_47C4_905F_FF961EEA29B8'" when selecting the database ...
1
vote
0answers
16 views

Postgres - Trying to backup Functions only

I'm trying to follow Craig Ringer's answer to this question: http://stackoverflow.com/questions/13758003/how-to-take-backup-of-functions-only-in-postgres My command is: psql -U username -AT db_name -...
3
votes
2answers
80 views

Automate COPY command - Postgres 9.2

I've a backup table with several distinct IDS... I wanna do a BACKUP of those rows, by ID. The function has to be executed by a limit of account_id ( select dump(21); - Where 21 = number of ...
15
votes
4answers
669 views

Why can't a differential backup specify its base?

This is my first DBA.SE post, so please inform me of any mistakes, thanks! I am a new DBA (not an IT pro, just no one else in the company to do it), so the more basic the explanation the better. I ...
1
vote
3answers
4k views

mysql duplicate entry error 1062 when restoring backup

Sorry, I seen similar threads but I still couldn't find it addressing my issue plus, I needed some more info on this. Requirement: To create an exact replica 'db4' of an existing DB 'db3'. Procedure ...
1
vote
3answers
52 views

Backup throws permission error

I'm trying to backup SQL Server database to upload it to my database server. I am using Microsoft SQL Server Management Studio, Database -> Tasks -> Back Up... And I got the following error: An ...
1
vote
0answers
12 views

Howto restore Trigger filesystem copy (*.TRG and *.TRN files) in addition to mysqldump?

We use mysqldump for backup (without Trigger/Events/Routines included). mysqldump --opt --flush-logs --single-transaction --ignore-table=mysql.event --all-databases The triggers we copy with cp to ...
3
votes
1answer
64 views

MySQL applying second incremental backup causes LSN in the ibdata files to be higher than LSN in the ib_logfiles

Using the backup procedure described below, it gives warnings. These warnings start to appear from the 2nd till 6th (last) incremental backup that is being applied to the base backup. How to solve ...
5
votes
2answers
3k views

SQL Server 2008 R2 Restore COPY_ONLY full backup with transaction logs

After doing some research I cannot seem to find an answer to this question. Background I am attempting to setup a backup plan that fits the following three requirements: Reliability of backups, ...
2
votes
1answer
102 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 ...
4
votes
1answer
62 views

Log backup vs differential backup if latter is broken

Under full recovery mode, will a differential backup "break" the previous log backups? Let me give an example: Let's say we have the following backups: FULL backup 1 Log backup 1 LogBackup ...
2
votes
2answers
5k views

How To Export-Import Database in Oracle 11g(Application Express Edition)?

I am beginner in Oracle 11g. I have created a database in oracle 11g(Application Express). I want to export this database with all data(whole workspace) and import this to another computer where I ...
1
vote
2answers
139 views

PostgreSQL Write Ahead Logs Archive Mode

I'm trying to figure out various things surrounding PostgreSQL and how backups should work together with WAL and Commvault Simpana. Simpana is telling me that everything is ok, but leaves files lying ...
1
vote
2answers
71 views

Large Database backup approx 2 TB and restore with limited disk space

I am working on DB migration from server A to server B. Server A:- DB size - 2 TB - Sql 2008R2 - Multiple Data files stored in diff drives. Server B:- Disk space:- 999 GB - Sql 2014 Enterprise ...
1
vote
0answers
168 views

Problem to understand a 70-462 exam question

This is the question: You administer a Microsoft SQL Server 2012 instance that contains a financial database hosted on a storage area network (SAN). The financial database has the following ...
0
votes
1answer
37 views

Regarding Backup and Restore Strategy

Everyone I have some queries regarding backup and restore strategies. I want to take Backup and Restore of Large Database approx. 60 to 70 GB and it is critical database in SQL Server. Backup ...
1
vote
3answers
72 views

What is the easiest way to make SQL Server backup and send them to Dropbox?

I have three SQL Server databases and I need to make a full backup once a day, differential every 4 hours and transaction log every 30 minutes. How can I do it in automatically? Should I use any ...
0
votes
2answers
81 views

Is there a way to backup a mysql database without having to run mysqldump?

Is there a way to run a backup of a mysql database using sql? We have scripts which run updates against our databases. They only have mysql user credentials, not system login credentials. Is there ...
0
votes
0answers
18 views

InnoDB: Operating system error number 9

I got error when trying to backup with percona. Backup command [xtrabackup --backup --target-dir=/data/backups/mysql/] was worked and When I try to prepare backup [xtrabackup --prepare --target-dir=/...
0
votes
0answers
32 views

Failed to flush the commit table to disk

We recently had this error come up for one our databases https://support.microsoft.com/en-ca/kb/2603910 In order to fix it we patched the server to the latest SP and Security Update. Current version ...
0
votes
2answers
56 views

How to manage multiple SQL Server backups from the one place? [closed]

I have to administer 5 SQL Server databases which are located in different places (5 shops which are located in different districts) , there is no ports/Powershell RM or WindowsFileAndPrint Sharing or ...
2
votes
1answer
63 views

SQL Server: backup error 112: not enough space on the disk - true or not?

Last night my weekly backup on SQL Server 2014, running on Windows Server 2012 R2, failed with the following error in the log: failed with the following error: "A nonrecoverable I/O error occurred ...
1
vote
0answers
28 views

“SHOW TABLES” command returning tables not in the schema

I was debugging a backup script at work and noticed that for some of our bigger tables (greater than 5GB), I'm noticing an odd discrepancy. If I run the command mysql -h $host -u $user -p $pass -e '...
6
votes
1answer
56 views

Best way to backup & truncate transaction logs on a schedule

I'm no DBA, but things being what they are, I have to wear the DBA hat and set up maintenance plans on my SQL Server instance. So for a while I've been having my SSIS overnight process run a Execute ...