Reloading a database from a backup, typically for disaster recovery, or to make a copy of a database onto another server.

learn more… | top users | synonyms (2)

2
votes
1answer
2k views

Mongo DB Replica set Stuck at RECOVERING state

We have created a replica set and now the problem is 2 members of replica set [3 members set] are in recovering mode from 48 hours. Initially the size of recovering nodes was increasing and now even ...
0
votes
1answer
449 views

How to use imdpd to import data file into different schema including index from different tablespace as well

The original data pump file is generated by the schema which living in two tablespaces(OLD_SCHEMA_DAT and OLD_SCHEMA_IDX), if import back to the original tablespace, everything is fine, but when I use ...
2
votes
1answer
7k views

RESTORE failing with OS error 32, file being used by another process

I am writing a set of procedures for (partially) automating DB deployment for a customer, which mostly works fine, but sometimes a RESTORE command is failing with the OS error 32, about a file being ...
2
votes
1answer
392 views

Disk Crashed, NDF(Index) file lost

I have database with : -two filegroups (PRIMARY and INDEX) -three files .mdf(data), .ndf(index) and .ldf(log) every file is on different disk, yesterday disk where was NDF file crashed so I lost ...
0
votes
1answer
146 views

how to Use old mysql database after reinstall mysql in RHEL 6?

I was getting problem in starting and login mysql server so I backuped /var/lib/mysql folder and reinstalled mysql server. Now I want to use old database files like: ibdata1 and database folder ...
2
votes
1answer
3k 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
2answers
490 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 ...
3
votes
2answers
370 views

Restore database into new DB without replacing the file structure

Our Network Admin has setup a MS SQL 2012 server and wants the DBs setup so the database files are located on 4 different drives. My problem here is when I try to restore a DB from a different system ...
0
votes
1answer
74 views

how to restore?

I am not sure if this has been addressed already. I have been a long time reader but this is my fifth post. I need assistance with a database restore solution. I receive a full BAK and the transaction ...
-8
votes
1answer
707 views

SQL Server Restore Database Error [closed]

I get the below error for restoring some databases. Some restore ok. Others fail with this error... Cannot open backup device 'I:\Backups\TestDB.bak'. Operating system error 2 (failed to retrieve ...
1
vote
2answers
3k 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
46 views

I'm building up a large MyISAM table from a few dumps. The first 21GB took less than 10 hrs total. The next 5GB is forecasted to take two months

I had a couple machines building up identical MyISAM tables. I've dumped all of those tables to a few files, and am now trying to restore them all into a single table on my own machine. The first ...
1
vote
0answers
333 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 ...
4
votes
1answer
2k views

Tail Log backup when doing a restore?

Typically when doing a restore of a DB from a production server to a non-production server I will use the WITH REPLACE option as when I forget I get an error about the tail log not being backed up. ...
1
vote
0answers
23 views

Restoring corrupt database - “mdf is not a primary database file” [duplicate]

Unfortunately the hard disk of my system is damaged. I am trying to recover my database, but it cannot be attached again to SQL management studio 2005. The error is myfile.mdf is not a primary ...
0
votes
1answer
192 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.
1
vote
2answers
3k views

MSSQL Restore Database is terminating abnormally

When I'm trying to restore a database, I'm getting this error in MSSQL: Msg 3287, Level 16, State 1, Line 16 The file ID 1 on device ...
4
votes
1answer
168 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
2answers
164 views

How to restore MySQL database from Files

Primary hard disk where MySQL (version 5.1) was installed is crashed and I had to re install entire OS. I have all the files including ibdata1 file. How do I go about recreating and attaching database ...
1
vote
1answer
1k 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 ...
1
vote
2answers
14k views

ORA-01033 “ORACLE initialization or shutdown in progress” caused by ORA-10567 “REDO is inconsistent with data block”

I faced an error while logging to database with regular user (non SYS/DBA): C:\Users\user>sqlplus tester@orcl ORA-01033 ORACLE initialization or shutdown in progress However I can connect via ...
1
vote
1answer
208 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 ...
2
votes
2answers
797 views

Restoring a tablespace to a different database

Any ideas as to how we can re-create a tablespace on a different server? We have a cold backup, so we can copy the datafiles to the target server. Can we just create a new instance on the target ...
1
vote
1answer
3k views

Backup/restore of a database that has a filestream

I have a SQL DB to which I have recently added Filestream data. Now we have a daily backup/restore to a QA server, and since I added the Filestream data, this has started failing. So I modified the ...
2
votes
2answers
477 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 ...
0
votes
1answer
497 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
164 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
576 views

can we transfer sql database backup from one server to another server directly?

I want to transfer sql database from one server to another server directly, instead taking back up of that database and copy that back up in another server and then restore it. Please tell me, Is ...
4
votes
1answer
3k views

Restore All Databases Script

I am migrating SQL Server DBs to a new instance. I have been told that it is possible to dynamically build a RESTORE script from available backups in the system catalog. Does anyone know of a sample ...
0
votes
2answers
1k views

Restore InnoDB to different machine

It was pointed to me from serverfault that the following question would be a better fit here so this is basically my original question from there. I currently have backups that were taken with ...
3
votes
3answers
5k views

how to restore differential back daily basis on sql server DB

Im working with SQL Server DB, what i need is that i have a DB1 and clients site communicate with this DB,Reporting module of the application is also using the same DB (i-e That shows different ...
2
votes
1answer
301 views

SQL server Index rebuild and restore not working

Hey everyone I am having an issue with my database. Below is a copy of CHECKDB. When I attempted to do a restore from a backup the restore had the same errors. It appears that my details table is ...
0
votes
1answer
2k views

MS Access .mdb & .ldb database corrupted

I am using a A.mdb database. You know when connecting the database Microsoft automatically create a .ldb file. Unfortunately my pc shutdown when connecting the database. As a result after restart the ...
0
votes
0answers
97 views

The fulltext catalog upgrade failed because of an inconsistency in metadata between sys.master_files and sys.fulltext_catalogs

I am using sql server 2008 and when trying to restore .bak file I'm getting this error: The fulltext catalog upgrade failed because of an inconsistency in metadata between sys.master_files and ...
1
vote
0answers
58 views

Strategy for multiple distinct databases in PostgreSQL

I have a 30 gb db in PostgreSQL 9.2. Running On Amazon Linux on an ec2 (web virtual machine), with the data directory mounted from its own drive (EBS). I'll call the database db30. On production ...
0
votes
1answer
117 views

Upgrade SQL Server 2000 engine

I have SQL Server in which I need to upgrade and restore a .bak file Server 1: Microsoft SQL Server 2000 - 8.00.194 (Intel X86) And by requirements I need it to match Server 2: Microsoft ...
4
votes
1answer
603 views

Repair SQL Server Database [closed]

Can anyone give me a complete guide to verifying/repairing a SQL Server database? At the moment our backup is failing on the Solarwinds database saying the database NetPerfMon is corrupted (we are ...
0
votes
2answers
1k views

Error 9002 state 3 after RESTORE DATABASE

I'm trying to restore a database from a validated backup (through RESTORE VERIFYONLY). The command I've used : RESTORE DATABASE [RESTORE] FILE = ...
0
votes
1answer
223 views

PostgreSQL: After restoring data, unable to use Views (permission denied)

I'm attempting to get a PostgreSQL environment running locally. I'm using 9.2.8, and have restored data from a backup made by the DBA of the production environment. The restoration worked fine ...
1
vote
1answer
900 views

DB2 LOAD: Poor performance while loading table with large BLOBs

I need help regarding LOAD-command with BLOBs. I notice very poor performance while loading a table which contains large BLOBs. While tracing the OS, I only have about 15MB/sec I/O-speed. But in ...
1
vote
1answer
793 views

Restore a WordPress database from .frm and .idb only

I had a WordPress website running a long while ago. I used WAMP server. Then, I uninstalled WAMP. Today I would like to work again on my website; all that remains of my database is this (I cannot find ...
1
vote
1answer
83 views

Partial restore of Progress DB

I have progress .bup files for my databases The environment I am restoring too has less space and because I have no control over this environment I wish to make the databases smaller. To do this I ...
2
votes
1answer
1k views

mysql restore from data directory

I recently asked a question regarding the restoration of a pretty huge (around 300 to 400 GB) mysql database and got some nice suggestions as seen here. Now, I have backed up the data directory of ...
1
vote
1answer
91 views

Equivalent SQL Server's Backup COPY ONLY in DB2

In, DB2 when you have a recovery strategie, you have a Full backup, then some deltas or incrementals in between. They are creating based on the previous full (first delta, or any incre. ...
1
vote
3answers
3k views

mysql database restore takes long time

I am in the process of reinstalling a Ubuntu server to rhel6 server. I have a pretty huge database. When I checked the mysql data directory size, it was around 354 GB. However, I dumped the entire ...
4
votes
1answer
2k views

SQL Server 2005 Restore Backup Status Recovery Pending

So at work something dreadful happened a database server went down and I am having an issue recovering one of our databases from our backups. When I try to restore from a backup using SQL Management ...
1
vote
1answer
630 views

Restore mysql from database snapshot

I have a folder containing the snapshot taken from a database. They are all in the format organisation_product_tablename.sql. How can I restore them back into the database? EDIT 1: I managed to ...
1
vote
1answer
223 views

database not restoring from dump file

I'm running the following command to create a dump of all database on my production server: prodserver:/# pg_dumpall -U postgres -h 1.1.1.1 > prod.sql on my development box, I also take a ...
2
votes
2answers
521 views

Backup of database X on SQL Server 2008 on server A - restore to SQL Server 2012 database Y on server B

I want to copy a SQL Server 2008 database to SQL Server 2012 with a different database name. Took a backup of 'production' and copied it to the SQL Server 2012 machine. Created a new SQL Server 2012 ...
0
votes
1answer
258 views

Oracle XE Backup Restore Problem

I have a Oracle XE 11g on Windows 7. I try to backup my database and restore it. First, i backup my database with running backup.bat script which is in ...