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)

1
vote
0answers
179 views

Restore of database failing due to pending requests

I am taking a backup of a database from one of our servers and I am placing it on my laptop so that I can run it locally. I have tried to restore the database on to my laptop and I get the following ...
2
votes
0answers
161 views

Restoring from pg_dump with foreign key constraints

In restoring a database from a pg_dump, a number of errors are being generated and the whole table is subsequently being ignored. An example: ERROR: insert or update on table "channelproducts" ...
0
votes
1answer
28 views

Check data is the same after restore SQL

I've backed up, transferred to another location and restored a database. Is there anyway to check that the data is the exact same? Would I be best using the CHECKSUM and then the VERIFYONLY method? ...
0
votes
1answer
59 views

How do I recover from a failed SQL Restore?

After a failure of the restore code in a webpage the database is left in the "restoring" mode and/or is offline. How do I recover so I have an operational online database - before I exit the code? ...
2
votes
1answer
104 views

Checkpoints are occurring too frequently during pg_restore

Under PostgreSQL 9.2.2 (Windows 32 bits), I have a pg_restore command that systematically results in log warnings about the checkpoint frequency, for example: LOG: checkpoints are occurring too ...
1
vote
1answer
41 views

how to obtain a list of restore points?

i am implementing restore points using pg_create_restore_point, and will then have a set of scripts to enable my users to restore to one of these restore points. Clearly i have work to do with taking ...
1
vote
1answer
471 views

CHECKPOINT prevents database drop

I'm working in the following scenario: I'm creating an script that recreates an entire database. The script involves destruction an recreation of the database and all its objects, as well as a great ...
0
votes
1answer
656 views

my oracle db won't open please help

This is what happens when I try to query as DBA: SQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 10 22:28:00 2014 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: sys ...
3
votes
1answer
68 views

cannot understand why restore database preview fails (missing archive logs)

I am fully backing up my standby database every night with following statement. (please note that I do not use rman catalog but control file) backup AS COMPRESSED BACKUPSET full database tag ...
0
votes
1answer
45 views

Backup/restore check data is the same SQL Server

I'm a trainee SQL DBA. I'm using SSMS 2008r2. I've backed up a database and restored this as a new database on a new instance. I want to check to see if the data is the same on both databases. Is ...
0
votes
1answer
53 views

MongoDB Unrecoverable Failure

My machine (OSX) had a power failure and when restarted, I have one db in Mongo that is completely unrecoverable. I am using the db per directory with dbpath and logpath specified options and was able ...
1
vote
0answers
32 views

SQL Server 2014 Management Studio restore destination changes from selected database

In SQL Server 2014 Management Studio, when I right-click on a database and choose restore, then tell it to restore from a .bak from disk, it always changes the restore destination away from the ...
-2
votes
1answer
47 views

Restored database smaller than the backup file [closed]

The new database created from a restore file is half the size of the backup file I restored from. Why? Original backup settings: Recovery Model: SIMPLE Backup Type: FULL
0
votes
1answer
36 views

Microsoft SQL migration full/diff backup/restore

I would like to move a database from one physical location to another. I already have a copy of the full database backup at the new location which is done by a nightly SQL job and is about 20GB. If I ...
1
vote
1answer
94 views

SQL Server database backup(2012) restore on lower version(2008)

We want to restore 2012 *.bak to 2008 sql server, we don't want to prefer import/export logical backup. Looking forward to know downgrade procedure.
4
votes
3answers
1k views

Error 3203 restoring SQL Server backup: The data is invalid

I am trying to restore a .bak file (backup taken on SQL Server 2008 R2, compatibility level 100). I am restoring the backup on SQL Server 2012 edition. I get the below error. Unfortunately the ...
2
votes
0answers
35 views

My stored procedure randomly fails due to invalid object in a swapping database instance

I have a stored procedure in my database (say it is CustomerDB) which joins with a table function in a different database (say it is dbPerformance), the sp is something like: select something from ...
0
votes
2answers
99 views

Restore DB from SQL Server 2008 R2 to 2014 Express

I'm trying to restore a database backup made in SQL Server 2008 R2 to the 2014 Express version. Is this even possible? If I choose restore from device and select my backup file, I see no database in ...
0
votes
0answers
78 views

Backup and restore DB through stored procedure

I need to backup a database from a server/db TO a destination Server/db. The process is pretty cool because you specify the Source Server and DB and the Destination Server / DB and the code is ...
0
votes
1answer
24 views

Restoring a database that belonged to an AG [duplicate]

I'm trying to perfect our disaster recovery steps... We take backups of a database that, in production, is in an AG. It is the only database in the AG. If we lose the building, I need to be able to ...
2
votes
1answer
55 views

Generate Database Creation Script Within A Stored Procedure

I'm looking to automate a wipe of our test environment to bring it up to be in-line with production at the end of every sprint. As it stands this is currently being completed by the test enviroment ...
2
votes
2answers
5k views

Postgresql - Recovery using recovery.conf

I am trying to recover a database using recovery.conf file for making point-in-time copy. On recovery.conf file, I added a recovery target time as below. recovery_target_time = '2011-06-16 04:10:00 ...
0
votes
0answers
151 views

How to include all sequences in pg_dump/pg_restore?

(Also posted to http://stackoverflow.com/q/32832486/398670) I have a PostgreSQL 9.4.4 database on my development server that contains test data that I want to dump and then restore to my production ...
0
votes
0answers
256 views

SQL Operating system error 5(Access is denied.)

Having trouble restoring .bak file located on desktop. My query RESTORE DATABASE MyDatabase FROM DISK='C:\Users\Mason\Desktop\48WSDB2_backup_2014_10_01_010027_0576172 - Copy.bak' results in ...
0
votes
1answer
59 views

MySQL – Backup/Restore Selected Tables/Fields Only

I support a Python application (includes some C modules) that utilises a MySQL database. A number of clients are running this in a standalone environment but have agreed that we can use their data ...
1
vote
2answers
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
1answer
126 views

How to remove triggers from the restored database in SQL Server

I am using SQL Server 2008 Management Studio. I've got a .bak backup file from a client to resolve a specific issue. Once I restore the database from the .bak file, I am unable to do any alter query ...
0
votes
2answers
26 views

When to use full backup or full backup and then differential backup [duplicate]

There is a SQL Server 2012 database that has the following configurations Recovery mode : Simple Backup Schedule : Full backup at 01:00 hours daily as well as differential database backup 13:00 ...
3
votes
2answers
143 views

Is is possible to recover a database from the 'raw' files (.mdf and .ldf) of the old server to a new SQL Server instance on a new server?

I have a client that has POS software called Restaurant Pro Express (RPE) from www.pcamerica.com. RPE uses a SQL Server database. Their old POS server had a hardware failure, but I was able to attach ...
1
vote
1answer
33 views

Can a SQL Server 2005 msdb database be restored as a User database?

Can a SQL Server 2005 msdb database be restored as a User database on another instance (same Build)? "Why?" you ask: I need a list of the mail items that existed prior to installation of two service ...
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
42 views

How do I update my database generated pg_basebackup through WAL files?

Following on from this post... I have a backup generated by pg_basebackup regularly, I would update it through the WAL files. What is the best way to do it?
1
vote
0answers
46 views

Best method for daily incremental copy of Postgres database

I'm trying to figure out the best plan of attack for making a nightly copy of our Heroku PostgreSQL production database to our local development environment. The database is rather large and grows ...
2
votes
1answer
120 views

Restore from SQL Server 2008 R2 to SQL Server 2014 fails

I have a SQL Server database backup of SQL Server 2008 R2. I want to restore that backup file that is around 40 GB on to a Microsoft SQL Server 2014 Express Edition (64-bit) and it runs till 95% and ...
1
vote
1answer
53 views

How I create backup with backup by dump and WAL files in PostgreSQL?

I have a backup and WAL files, I like update my backup with WAL files. Anyone know how to do it? Thanks
0
votes
1answer
47 views

restoring database using RMAN [closed]

If I have new data like new users and tables created after backing up database with RMAN , in case of restoring database will the operation affect my new data made after taking the backup?
1
vote
2answers
167 views

Errors restoring a differential backup

I'm getting the following error as I'm trying to restore from a differential backup: System.Data.SqlClient.SqlError: This backup set cannot be applied because it is on a recovery path that is ...
0
votes
1answer
36 views

How to restore a database from SQL Server 2000 to SQL Server 2012

I've got a databe in SQL Server 2000 and older than it! And it's very old version. I can't restore to SQL Server 2012. Is that because of old version? How can I restore it? Is there any script or ...
0
votes
0answers
103 views

Restore .dmp file into csv

We have asked our clients for certain data in a csv file format and we just got a .dmp file. I have been trying to open it using MySQL as if it were .dump but it doesn't work. I have seen other ...
1
vote
1answer
2k 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 ...
0
votes
2answers
35 views

Restoring Database to a smaller test envrionment [duplicate]

I don't believe this is possible but wanted to check. I've got a bi-weekly job running to restore the full backup to a test environment so the devs have something fresh to destroy without damaging ...
0
votes
1answer
55 views

Fullbackup + Differential/Copy-only

We have a PROD full backups copied over to support envs daily and we restore to support environments to triage some issues, as the DB is growing big we would want to run the full backup copy only on ...
1
vote
2answers
2k views

Can't restore mysqldump database backup in Ubuntu 12.04

I'm trying to restore a database backup created using mysqldump. If I do: $ mysqldump -u ROOT -p DATABASE_NAME < DATABASE.SQL the database remains empty, even though I get some screen output ...
-1
votes
1answer
67 views

Upgrade Database from SQL Server 2008 to SQL Server 2008 R2 [closed]

I've upgrade my database from SQL Server 2008 to 2008 R2 (v10.50.1600.1) on a remote server. Version of my local SQL Server is 10.50.1600.1. When attempting to restore database from remote server to ...
0
votes
1answer
20 views

Copy postgis layer from S3 to Heroku

I have a dump of a postgis layer (layer.dump), which I am trying to add to my heroku database (mydatabase). The postgis layer is stored on S3 (https://s3.amazonaws.com/layer.dump). I would like to add ...
0
votes
1answer
285 views

How to copy tablespace from one database to another database in Oracle 11g

How to copy tablespace and datafiles from one database to another database in Oracle 11g in same server ?
0
votes
1answer
21 views

Mongo DB Site to Site Migration

I am somewhat new to MongoDB but I do have some experience with MySQL and PostgreSQL. Currently, I need to migrate Mongo DB from one site to another. The sites should be identical (development and ...
-1
votes
1answer
47 views

Unable to restore the database with the query [closed]

USE master GO ALTER DATABASE Tfs_CoE SET SINGLE_USER WITH ROLLBACK IMMEDIATE; GO RESTORE DATABASE Tfs_CoE FROM DISK = 'D:\Backupfolder\Tfs_CoE.bak' WITH MOVE 'Tfs_CoE' TO ...
0
votes
0answers
30 views

Distributor Configuration for Merge Replication Restore

I have recently taken over some DBA responsibilities in my current role, and I'm struggling with a restore of a merge-replicated Publisher DB and Subscriber DB from Prod into PreProd. Both ...
7
votes
1answer
126 views

Instant File Initialization on Shared drive

I asked something similar to this before, but previously I had asked about moving backups to a shared location. This time I am curious: if I want to restore a database on a shared drive, do I need to ...