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

pg_basebackup: could not set compression level -1

When trying to run pg_basebackup I received the following error message: pg_basebackup: could not set compression level -1 (null) using the -z option. I received a similar error message when trying ...
0
votes
0answers
284 views

Error while taking backup in Postgresql

While taking a backup from my PostgrSQL database, it is showing this: pg_dump: Dumping the contents of table "gtab17" failed: PQgetResult() failed. pg_dump: Error message from server: ERROR: invalid ...
0
votes
0answers
286 views

Archive log backup error and backup completed with errors

My prod DB backup completed with errors stating the below error. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ...
0
votes
0answers
3k views

Restore a backup from SQL Server 2008 R2 to SQL Server 2014 [closed]

How can I restore a backup from an earlier SQL Server 2008 R2 version to SQL Server 2014? The error I get is 38: reached the end of file although the file is not corrupted. Thank you.
0
votes
0answers
653 views

How to recover a crashed MyISAM table which myisamchk couldn't recover?

We take db backup by stopping the database and then issuing a tar -zcf on the mysql data directory. When we restore the data directory on another machine and try to start the slave, the mysql error ...
0
votes
0answers
72 views

Backup is getting failed with following error

Msg 3202, Level 16, State 1, Line 1 Write on "\w-mum-fp\SQLBKP\Weekly-FL\Interactions_26_01_2014.bak" failed: 1130 (Not enough server storage is available to process this command.) Msg 3013, ...
0
votes
1answer
427 views

Taking hot backup of slave node in postgres (master-slave config with repmgr)

I have a postgresql setup with master-slave configuration using repmgr. I'm struggling with taking a consistent snapshot backup (pg_start_backup) of the slave node, this is due the fact that the slave ...
0
votes
2answers
192 views

I can't import my database into mysql

I have a website based on drupal and I tried to export its database via both Backup wizard and phpmyadmin. the database was exported but I can't import it on my localhost database.this the error ...
0
votes
0answers
775 views

Oracle EXP Error ORA-12704: character set mismatch

I need to duplicate a Oracle 11g Express Edition database from one computer to another computer. I tried exp sys/password FULL=Y FILE=backup.dump (the idea is to do a imp on the other pc) But it ...
0
votes
0answers
384 views

Database backuped, but “Last database backup” property shows bad date

I have this procedure below to backup database(procedure is in backuped database). Procedure is called by external program. Procedure runs fine, backups are created. But when I want to find out last ...
0
votes
0answers
112 views

Recommended plan for 0min RTO and RPO

I have a Windows Server 2008R2 Server, running SQL Server 2008R2 SP2. The server currently only does a full backup once daily. The server's operational hours are between 8am and 5pm. The server's new ...
0
votes
0answers
87 views

Backup in Mysql periodically

I have trouble scheduling a backup in mysql periodically, most of the tools do not recognize the geometric field, for example navicat which says Can not get geometry object from data you send to ...
0
votes
1answer
415 views

Backup/Restore File Groups SQL Server [duplicate]

I've got a database with 3 Filegroups and each filegroups own a single file, Filegroup names are Primary, SecondFG and ThirdFG. I want to backup ThirdFG separately each time without backing up the ...
0
votes
2answers
131 views

Backup certain tables in MySQL [duplicate]

Is it possible to take backup of certain table in mysql? Suppose I have 10 tables, and I want to take a backup of 8 tables through one command. How can I do this?
0
votes
0answers
668 views

Is it recommended to run a Oracle schema backup when there are active sessions?

I need to backup two schemas in a Production database (Oracle11gR2) that are being accessed by an application and some other systems. These schemas are quite small and exp will be used for the export. ...
0
votes
0answers
122 views

Tape rotation strategies

I am trying to find a tape rotation strategy that would be optimal under the following conditions: Backup Media Rotation strategy should support the following: Media Archives required ...
0
votes
0answers
35 views

Performing a Transaction Log Backup on a Live Database [duplicate]

I have a server 2012 database that has a transaction log that is growing at a rapid rate. i have a job that runs once a day after production hours which backs up the log file and shrinks it. The ...
0
votes
0answers
370 views

How to do point in time recovery of binary log files into .sql file

I have written a shell script to do an incremental backup of MySQL database. For point in time recovery I'm using the binary logs generated in /var/lib/mysql directory. For point-in-time recovery, Im ...
0
votes
1answer
54 views

Is possible do an online snapshot backup , without archive logs at Oracle Database?

Using Oracle Database Standard Edition 11r2 . I'm looking a way to backup the database with zero downtime , using a snapshot of datafiles (LVM snapshots) and without need backup de archive logs. ...
0
votes
3answers
79 views

Oracle RMAN Back-up files in red hat can be read in windows?

We have performed a cold back-up of a database using Oracle RMAN. The back-up ran on a Red Hat Server and then the files were copied to a mounted external hard-drive. Can this back-up files then be ...
0
votes
1answer
128 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
2k views

What is best strategy for backup on streaming replication(hot standby) environment

I have questions. What is best strategy for backup on streaming replication(hot standby) environment. I’d like to do backup on slave server and restore(PITR). First, I set up streaming ...
-1
votes
1answer
48 views

SQL Server database backup file is successfully created in a path but no such file path is available in my local machine

When I tried to take backup of SQL Server database, it was successfully created in C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\ but no such path is available on my local ...
-1
votes
1answer
162 views

IO Frozen in error SQL error log

The log shows IO DBName is Frozen follow by thaw but yet my database schedule backup task which normally been running isn't since the network team are doing backs (not database backups, according to ...
-1
votes
2answers
1k views

How do I connect to a database with a blank password using a shell script?

## connect to mysql and source backup file ## USER="root" PASS="" mysql -u$USER -p$PASS database_name < backup.sql Above is my shell script which I used to source database but still its asking ...
-1
votes
1answer
32 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 ...
-1
votes
1answer
584 views

How to merge data from 2 databases [duplicate]

I have a SQL-Server database that crashed while I was away on vacation. All info from 5/2/13 is missing from our current database because my replacement implemented a back-up of the database from ...
-1
votes
1answer
192 views

Back up my ASPNETDB

I want to back up my database but I got this error: Cannot open database "ASPNETDB" requested by the login. The login failed. Login failed for user 'My-laptop\user'. I'm using SQL Server Express ...
-1
votes
1answer
279 views

Should I keep pg_xlog on the same disk as data if using disk snapshotting?

We're running on EBS volumes on EC2. We're interested in leveraging EBS snapshotting for backups. However, does this mean we'd need to ensure our pg_xlog is on the same EBS volume as our data? (I ...
-1
votes
1answer
1k views

Oracle XE: Transfer Database from Linux to Windows

our professor gave us a linux VM with a Oracle XE 11g Database. I want to transfer this Database to my Windows installation because I dont't want to boot up the VM for every exercise. Everything ...
-1
votes
1answer
299 views

Does SQL Server full restore set the differential base?

Differential backups are taken as the difference between the current state, and the last full backup called the "differential base". Does restoring a full backup reset the differential base? If so, ...
-1
votes
1answer
234 views

“Backup mysql database by copying the data file even when MYSQL server is running” solution! Is there any problem for this backup solution?

I am using MYSQL-5.0.27 I have 2 exact same MYSQL folder "mysql-5.0.27-win32". One in the Virtual Private Server (VPS) & the other in Local PC. At the beginning, these 2 folders are exactly the ...
-1
votes
1answer
65 views

quick checkpoints for development mode

i'm a programmer, not a dba. i need a mechanism to quickly make a snapshot of a database (oracle 11g XE) before i run migration. migration changes data, grants, DDL (tables, triggers, lexers, views ...
-1
votes
1answer
1k views

In the domain of SQL Server backup, what is a backup set, backup device, backup media, backup media set, backup media family

I'm not a native English speaker and I've read the descriptions in BOL but still can't understand what exactly are they. Can anyone explain in an easy understand way? Thanks.
-2
votes
1answer
54 views

Backup SQL Server database to the cloud or network folder [closed]

I can take a SQL Server backup to a local disk without any problem, but I now need to backup to a cloud disk or network folder that I can access. What are the best practices to do this?
-2
votes
2answers
478 views

How to Find All SQL Server database back list in my system? [closed]

My SQL Server 2008 R2 system has different database backups on different drives like C:, D:, E: Now I would like to see all database backups listed in SQL Server 2008 R2. Thanks for your time
-2
votes
4answers
4k views

how to restore .bkp file in SQL Server [closed]

I have a .bkp file, how can I restore it to SQL Server? I have SQL Server 2008 and SQL Server 2012. Any idea?
-3
votes
5answers
14k views

Safely deleting a SQL Server log file (.LDF)

I can make sure my app is in a consistent state. I can rollback all the uncompleted transactions if any (just in case) it's ok I can DETACH the database What do I need the log file for after that? ...
-3
votes
2answers
767 views

Incremental backup in SQL Server [closed]

I got a task for backing up my clients data through internet. Client has about 50 GB of data there. So I need to back up the data and pass through internet, but it takes about 8 to 9 hours for this ...
-3
votes
1answer
1k views

SQL Server backup devices autentification by user without access to local computer account or AD [closed]

Please is there way to create procedure to create Backup Device by using different user account, for user account without acces to local computer and not defined in AD too, because description from ...
-3
votes
1answer
331 views

SQL Server 2012 Express Database Backup Script [closed]

Just a quick one. I want to do a full weekly backup of my SQL Server 2012 Express database. I have created a SQL script and batch file to automatically do a full backup of my database each week and ...
-4
votes
1answer
98 views

Oracle database and data has been corrupted. Is there a way to get it back? [closed]

The Oracle database has been corrupted and both the data and backups were lost in the corruption. Is there anything I can do to recover my data? It would be terrible if it were all lost.