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

SQL Server Database Migration - Backup/Restore while Original DB still in Production

I have a very large DB in full recovery mode. My SQL Server is 2008 R2. The thing is that I need to migrate to a new server while having the original DB still in production. Both backup and restore ...
3
votes
1answer
359 views

Error during pg_restore: text search dictionary “unaccent” does not exist

I'm trying to move data between servers. I recreated the whole database structure, checked that same users exist and the unaccent extension that we use is enabled for all schemas of the target ...
-2
votes
1answer
70 views

Backup file from SQL Server 2012 to 2008 [duplicate]

I have a backup file of SQL Server version 2012 but I want to restore that backup on SQL Server 2008. Question: Is this possible ?
2
votes
1answer
97 views

Cannot access MySQL database after moving files in data directory

I am using Xampp locally and I recently did a computer upgrade where I went from XP to Windows 7 and also got a new drive to install Windows on. I have all my old Xampp files in: G:\xampp I installed ...
7
votes
1answer
390 views

Is it possible to restore SQL Server DB from transaction log (no MDF)?

We had a SQL Server 2005 server that housed roughly 200 low/no traffic archive databases, and that server was not backed up to any other device. The database files (MDF and LDF) were stored on a RAID ...
0
votes
0answers
118 views

how to recover everything from ibdata in mysql

I lost all my databases files after my hard disk was broken, In a way or another I got ibdata files the size for the file is 4GB.After replacing log files and files and type innodb_force_recovery=6 in ...
5
votes
1answer
135 views

SQL Server restore differential after restoring full backup

Here is the situation: I had a full backup, and a differential backup. I have restored the full backup into the database. But accidentally lost that backup file. Now I would like to apply the ...
3
votes
2answers
435 views

Database not able to startup showing control file is inconsistent with another

Our windows server 2008 R2 is shutdown due to power failure. When I am trying to startup Oracle 11g database its shows an error. SQL> startup ORA-01081: cannot start already-running ORACLE - shut ...
2
votes
2answers
611 views

PREEMPTIVE_OS_WRITEFILEGATHER wait on database RESTORE with IFI on

I have an Azure VM with Windows Server 2012 R2 and SQL Server 2014 Enterprise Edition. I have enabled IFI (added SQL Server user NTSERVICE\MSSQLSERVER to "Perform Volume Maintenance Tasks"). I have ...
4
votes
1answer
297 views

Do indexes get transferred with pg_restore

I see other questions that have been answered in the negative (i.e. indexes do not get transferred over with the standard pg_restore). However, it looks like it did in my recent dump/restore and I am ...
3
votes
0answers
156 views

Unable to restore backup taken on one server onto another server

I am using SQL Server 2014 version 12.0.2000.8 on both systems. When I try to restore the backup taken from the first system onto the second system it says: No backup set selected to be restored ...
10
votes
6answers
39k views

Error 3154 while restoring a backup using WITH REPLACE

I have SQL 2012 with SP1 installed on my computer. I made a backup of a database test.bak. I have a database with the name test2 which is the same database, but the data changed. I want to restore ...
1
vote
1answer
56 views

Scalability of concurrent log restore for different databases on SQL Server

Are there any locks or resource blocking/contention (beyond IO capacity) between two sessions, which restore logs for two different databases with norecovery? Same about restore logs with recovery? ...
9
votes
1answer
993 views

Restoring differential backup creates DEFUNCT log file?

Here is my problem. I'm trying to move a database to a new server via a full restore, then cutover with a quick differential backup/restore. I can do a full restore without a problem, but when ...
0
votes
0answers
18 views

How to align restore strategy with backup history cleanup? [duplicate]

I was curious about how that particular problem is tackled. 1) Full backups performed on saturdays. 2) Differentials every other day. 3) Tlog backups every 15 minutes. When trying to restore a ...
1
vote
0answers
78 views

Zero downtime copy/restore of a PostgreSQL database

I have a production server with static (no deletes/updates) PostgreSQL database, serving a huge amount of read queries. Once a week or two I have to update my database with new data. Right now the ...
2
votes
2answers
93 views

idera - why it restores databases faster

We have a 2gb live database that takes forever restore whenever I need some live data to test something. If I use idera it takes 5 mins at most. When I use the restore database command it can take ...
3
votes
1answer
959 views

Doing a point in time restore with CDC enabled; Possible?

I discovered this week, the hard way, that the database restore options NORECOVERY and KEEP_CDC are mutually exclusive. So, this begs the question. How do you do a database restore, keeping CDC ...
1
vote
1answer
17 views

Restore a specific file group to a test environment without restoring the Primary file group (Error 3154)

Scenario. I have a filegroup that we need to restore to get data back that has been removed from the database after the last backup I cannot touch The production systems because they are running ...
2
votes
2answers
1k views

mongorestore failure: error writing file “/var/lib/mongodb”

I want sync my server db with my local db; dump db mongodump --db [db name] copy dump folder into my local restore dump on my local mongorestore --db [db name] [dump folder path] I have ...
4
votes
1answer
930 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
44 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 backup/...
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
40 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] = CONVERT(...
2
votes
1answer
80 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
30 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
47 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
384 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
61 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
23 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
157 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
281 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
20 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
887 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
232 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 ...
7
votes
1answer
2k 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
553 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
242 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
90 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 (NULL,NULL,N'DISK',1,N'D:\...
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
205 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
69 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 </title&...
1
vote
0answers
485 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
485 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
115 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? ...