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)

4
votes
1answer
868 views

How to define the logical name in a backup ? ( Sql Server 2008 )

I saw : This question but it didnt help me. In a simple way, Is there a way to do : Backup database SomeDatabase to disk ='c:\teste\SomeDatabase.bkp' configuring the Logical Name? Because we ...
1
vote
0answers
39 views

Restoring SQL Server 2012 Enterprise to Web Edition not possible due to full text partitioning

I have an SQL Server 2012 Enterprise database I’m trying to restore to SQL Server 2012 Web Edition instance. I’ve used sys.dm_db_persisted_sku_features to find features to remove before a ...
1
vote
1answer
78 views

Log shipping 2008 r2 SP2 server to a 2008 r2 SP3 CLUSTER

We have recently configured one database to be replicated with log shipping in production, using SQL Server 2008 R2. We have up and running more than 150 database replicas without any problems. But ...
1
vote
1answer
37 views

How to restore a database, ignoring the free space within each file?

Using the following script I get all the disk space used by each file in my database: ;with radhe as ( SELECT DatabaseName = 'my Database', --DB_NAME(), a.FILEID, [FILE_SIZE_GB] = ...
2
votes
1answer
71 views

Restoring a replicated SQL Server database in a non-replicated testing enviroment

Sorry in advance if this is already answered, but it's quite difficult to search exactly what I need. We have a SQL Server 2008R2 DB in Production. Originally, the DB didn't have replication. Every ...
0
votes
0answers
29 views

Restore a table deleted seconds ago with Ghost Record

I've been reading about ghost records on SQL Server 2008 R2. I've read about, but only found topics about "restore rows" of data in ghost record. Is there a way to restore a table ( or tables ) that ...
0
votes
0answers
42 views

Postgres 9.3.9 problems

I have a problem with my database backup. I was unable to find solution so I decided to ask :) Situation: Database (Postgresql 9.3.9 with PITR set up) was runinng about 3 months. I downloaded backups ...
11
votes
2answers
3k views

Best way to migrate a huge SQL Server database with low downtime over network

Problem definition Our database server needs to be transferred to an other datacenter. It runs on Microsoft SQL Server 2012 Enterprise (64-bit) and contains two databases of about 2TB and 1TB. ...
1
vote
1answer
339 views

Powershell Restore Azure SQL Database to local with Restore-Database

I have written a powershell script that uses Start-AzureSqlDatabaseExport & Get-AzureStorageBlob to export my Azure DB to a bacpac and download it locally, the next step is to restore the bacpac ...
0
votes
1answer
56 views

BACKUP Detected Corruption in the database log

I took a backups of a few db's on server A (2008R2), Then restored it to server B (2012). One database had TDE enable, so I disabled it, took a back up then proceeded to server B. The other database, ...
1
vote
1answer
22 views

Restore Structure Only

We have a database that is 3TB+ in size, and don't have enough space to restore it. However, we want to retrieve code (stored procs) from a 15 day old backup. Is is possible to restore the structure ...
0
votes
0answers
143 views

Could not locate a valid checkpoint record postgres

I have a database postgres in windows server and two slaves for reading. I need do Incremental Backup. What I've done: - Create Base Backup from pg_basebackup - Save WAL files Restore What ...
2
votes
2answers
4k views

Database after restore process still display Restoring

I restored Database from Backup File (in Management Studio) and after restore, Database showed Restoring, then I deleted files from disk (engine's stopped), then I tried Restore again with success, on ...
1
vote
3answers
262 views

What all files are required for restoration process of SQL Server in Full + Diff + Transactional backup policy

I am reading about different types of backup policy in sql server. I am not clear with backup policy for Full + Differential + Transactional backiup My main attention is towards what all files would ...
0
votes
1answer
19 views

mysqldump - does it have non-repeatable DMLs?

We are migrating databases using mysqldump, and since this is the first time I'm doing it, I have a couple of questions. If in the middle of mysqldump the utility crashes(for some reason- latest was ...
0
votes
0answers
13 views

Will PostgreSQL server work if I install the service in mounted partition

I have created all tablespaces (only tables created in these tablespaces) in mounted partition, But db is available in pg_default tablespace (root partition where postgresql installed). I am facing ...
-8
votes
1answer
789 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 ...
2
votes
1answer
193 views

How to verify that a PostgreSQL base + WAL backup has been restored correctly

Coworkers were trying to extract a PostgreSQL database copy from a backup made at a hot standby in version 9.1, but it wasn't reliable - we would run it daily, but usually it would end up with various ...
6
votes
1answer
1k views

Why do we use FILE = 1 in scripts for restoring a database

Recently when I came across the script for restoring a database, I got a doubt on why we have to use "FILE = 1"? Can't we restore a database without that statement!? Basically, what it is used for?
1
vote
1answer
539 views

DB2 - question regarding RESTORE OFFLINE backup and Archive Logs

I configured last night DB2 to be in Archive Mode. I created required offline backup at 23:00 last night. First online backup will be created at Friday night. Archive logs now keep coming to the ...
0
votes
3answers
220 views

Is it possible to restore database only with .trn files?

How do I restore database only with .trn (transaction log backup) file? I did below two steps Microsoft SQL Server Management studio shows "Restoring". 1) RESTORE DATABASE [database_name] FROM ...
1
vote
1answer
81 views

Is it possible to convert .trn (transaction log) file to human readable form

I have used below SQL statement to get the transaction information done on 2015-10-26, but the information not in human readable form. ** SELECT * FROM fn_dump_dblog ...
1
vote
1answer
26 views

Are foreign keys important while restoring database

I dumped out a MySQL database with foreign keys. I want to restore the database, but the restore database is used only for read access. Do I need to index the foreign keys?
0
votes
1answer
174 views

Postgres restore unclear behaviour

I have following: 2 nodes one of which is current production db and another is for fail recovery. I made base backup on first node with following command pg_basebackup -h 127.0.0.1 -U postgres -D bckp ...
1
vote
1answer
78 views

Restore a point between two full backups

I make two full backups on Oct 1 and Oct 10. I want to restore the server to a state in Oct 5. So I just do as follows: Perform a transaction log backup on the server on Oct 23. I have never backup ...
0
votes
0answers
65 views

SQL Server DB in suspect mode after installing SQL Server 2008 R2 SP3

One of our production DBs is stuck in Suspect mode since we installed SQL Server 2008 R2 SP3. Earlier today we found that most text fields (nvarchar) had the following data appended to it ...
1
vote
0answers
424 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 ...
3
votes
0answers
385 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
30 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
102 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
377 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
82 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
550 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
798 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
110 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
51 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
86 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
49 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
51 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
58 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
241 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
2k 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
36 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
241 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
112 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
32 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
79 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 ...
3
votes
2answers
6k 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
307 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
312 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 ...