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

Error 909 restoring a database on Standard Edition

I ran into a problem with SQL Server 2012 Standard Edition (64-bit). I have rebuilt a system with the exact same specifications for software as it had been built previously (Windows 2012, SQL Server ...
1
vote
1answer
38 views

Between optimizing a 1-billion rows table and dump-restoring it, which would be faster?

Have multiple tables which had more than 1 billion rows. Archived and deleted many of them, now want to recover the disk space. Have option to either optimize the table, or dump the table and restore ...
0
votes
0answers
8 views

Trying to restore a db2 database but stops at roll-forward with error 'SQL1265N'

I'm trying to restore a backup that is older than the current database. The restore went ok, but the roll forward didn't giving the following error: SQL1265N The archive log file ".LOG" is not ...
4
votes
2answers
82 views

Unable to create restore plan due to break in LSN chain

My backup plan is: Full backup - once a day Differential backup - every four hours Transaction Log backup - every 30 minutes. All database backup are stored on my computer. I add some wrong ...
0
votes
2answers
2k 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 ...
1
vote
2answers
2k views

Restoring an Oracle Backup Properly

I've been trying to do a proper restore of a database for weeks now and I'm convinced that I'm doing something simple wrong. I took a cold backup of the database before an update to an application ...
0
votes
0answers
21 views

How can I restore a MySQL dump faster on Windows?

I am restoring some InnoDB and MyISAM .sql files that are on the order of GBs (ranging from 1 GB to ~ 10GBs) and they are taking a day or longer to restore. The command I am using currently is: use ...
0
votes
0answers
57 views

Postgres, promoting slave to master issue

We had the following setup in place db01 -> Master Postgres 9.3 db02 -> Slave Postgres 9.3 Master data got corrupted (logically) and as soon as it was identified we shutdown the server. Dev team ...
9
votes
0answers
193 views

Restore Database using GUI - Wrong file to restore

I'm just messing around with the graphic interface and studying the options of the "restore" task. One thing that I noticed is when I click on "generate script", the first line of the query is: ...
2
votes
1answer
614 views

How to restore database from /var/lib/mysql

I have a database folder from a crashed server called gain_wordpress. I'm trying to put that database on a new server but I'm not able to do it successfully. I don't have a .sql dump, all I have is ...
1
vote
1answer
3k views

Extremely slow mySql restores

Please bear with me as I ask this question, which looks similar to questions already on DBA@SE. In the current configuration, we have a server (a Linux quadcore box with 4 GB RAM) - Both the Database ...
3
votes
3answers
298 views

Restore database to point in time from full backup only

I have a database with recovery mode set to FULL. It's a dev database and I have two full backups dated 19th and 27th i.e. latest. One of the developer did some changes on 26th and I want to rollback ...
7
votes
2answers
225 views

Shrinking a SQL Server Transaction Log

I’m currently having to deal with a SQL Server transaction log that has got out of control. Disclaimer: I’m not a dba and this isn’t my area of expertise so please bear with me. Currently I have a ...
1
vote
1answer
664 views

Restoring Oracle prod backup to test server with new database name

I need to restore an Oracle production database (aaprod) to a test server that already is home to a test database (aatest) under a new name (bbtest). I have a cold backup of the production database ...
0
votes
1answer
23 views

Scenarios in which you might need to restore large number of databases at once?

I've seen several online sources mentioning that you should always have a restore script automated for the possible need to restore a large number of databases at once and quickly get back up and ...
0
votes
1answer
21 views

Lost connection to mysql while restoring dump. Is it safe to resume?

I was in the process of restoring an sql dump to a newly created RDS mysql instance on AWS. The dump was created with the following command: mysqldump --all-databases \ --single-transaction \ ...
5
votes
1answer
316 views

Can't restore SQL Server db from full backup, log processing fails, database in 'restoring' state

I am trying to set up a database for development purposes on my PC's local SQL Server Developer Edition 12.0.2000.8. I've got a full database backup and separate transaction-log-only backup files ...
0
votes
1answer
49 views

Restored database from .bkp file in SQL Server 2014 generates some strange errors [closed]

I have restored the well-known Northwind database and executed a trivial query: Notice the strange error "Invalid object name..." although the query has been executed successfully and both tables ...
1
vote
0answers
31 views

Backup creating fork_point

I have a powershell script that is restoring from production into a test availability group database. It copies the full and t-log backups from production to test, takes the target db out of the ...
5
votes
2answers
2k views

Why can't I read my transaction log backup file using fn_dump_dblog?

I'm using this blog on sqlskills.com as a guide to practice finding the relevant LSN in a transaction log backup for point in time recovery. After backing up the transaction log, I attempt to read it ...
2
votes
2answers
893 views

Can I use a script to restore multiple SQL databases from .bak files?

I'm migrating 100 plus SQL databases over to a new server in a new location. I have the maintenance plan in place to take full back ups and then a script to copy over the .bak files to a temp ...
3
votes
1answer
47 views

Unable to restore database because it exists, unable to drop because it does not exist

I've seen this mentioned a couple of times but none of the suggested solutions worked for me, so I'm posting a question together with a solution in hope that it helps someone else. During restore of ...
0
votes
2answers
414 views

Extract one MySQL database from a FULL MYSQL Server backup file

I have a small shared windows server on which i'have installed MySQL 5.1 engine for hosting my user's mysql databases. I backup the complete MySQL databases each day by running this script as batch ...
5
votes
4answers
13k views

Error while restoring a Database from an SQL dump

I am extremely new to MySQL and am running it on Windows. I am trying to restore a Database from a dumpfile in MySQL, but I get the following error: $ >mysql -u root -p -h localhost -D database ...
0
votes
1answer
376 views

Automate SQL Server restore from Prod to Dev

I would like to setup an automated restore job which takes the latest timestamp .bak file and restores it into the DEV instance. I currently have a job on the DEV box that uses the UNC path to the ...
3
votes
0answers
255 views

Fast restore of dropped partitions

I want to test the restore of erroneously dropped partitions of a subpartitioned table. This restore would consist of three steps: restore the database (or at least the necessary tablespaces) to the ...
3
votes
0answers
176 views

Database corrupt after restore and upgrade on another instance

Just wondering, if someone faced the same issue. We have got a SQL Server 2008 R2 (10.50.2789) and SQL Server 2014 (12.0.2000) and there is a process of backup on MSSQL Server 2008 R2 and restore on ...
0
votes
0answers
36 views

mysqldump: restored by mistake with no backup

While trying to take a mysqldump on a database, we have by mistake run a restore command mysql -u -p abc.sql <abc.sql. This has resulted in the abc database going back to a state 5 days back when ...
3
votes
2answers
43 views

Enabling SQL Instant File Initialization when Restoring to a Network Path

We have a large Read Only SQL DB (SQL 2012) that we’re restoring to a NAS as a current duct tape solution. I had wondered why the restore process seemed to be hanging. Part of my guidance along the ...
0
votes
0answers
41 views

Database Restore info not logged to msdb..restorehistory

I have 4 databases on a secondary server two of which are using Sql Server log shipping and two of which are using a "manual log shipping" config (there are just 2 primary databases). Both ...
2
votes
2answers
209 views

Build Restore History table

We restore a database daily that we download from an FTP site. I would like to build a history table that tracks when the database is restored on our SQL Server. This is easy. My issue is sometime ...
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 ...
4
votes
1answer
38 views

How long does it take for powershell to restore a SQL Backup?

I executed this Powershell script to backup a Database, Drop that database and then restore it with a different name: $srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)") ...
3
votes
1answer
133 views

Error while restoring Postgres DB Dump

Using below command to restore the database Restoration command: cat my_db_dump.sql.gz | gunzip | psql -d new_database -U my_username Note: my_db_dump.sql.gz size is 4.5 GB, (extracted size will ...
0
votes
1answer
19 views

Why can't I restore the DB from an SQL dump in PostgreSQL 9.4 (problem with dblink)?

I have created a dump of a DB using: pg_dump db_name > db_dump.sql and proceed to restore it with: psql --single-transaction db_name < db_dump.sql Prior to attempting to restore the DB, I ...
1
vote
0answers
28 views

DB2 - Error accessing a table space SQL 57048

Please can you assist me,I am mighty new at DB2, I done a backup on the prod server in order to mirror the prod server on another server. Backups ran fine. I did the restore on my test server. but ...
4
votes
1answer
71 views

RESTORE FROM URL dies during database recovery

Attempting to restore a small backup from the Azure BLOB RESTORE DATABASE MY_DATABASE FROM URL = 'https://somelocation.blob.core.windows.net/mydatabase.bak' WITH FILE=1 ,MOVE N'MY_DATABASE'TO ...
1
vote
1answer
146 views

Error when restoring SQL Server 2008 R2 backup on 2012

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 ...
3
votes
1answer
5k views

MySQL Restore Large Dump

I have a dump file of a single table which is 7GB. I try to restore it using mysql -u root -p DB_NAME < .SQL FILE But I don't see any activities in task manager. CPU is 00 and RAM is 5,700 K. I ...
1
vote
3answers
290 views

Import Database from Oracle .DBF files

Recently my Oracle Installation has been crashed and I reinstalled the Oracle again. I have my old Oracle Data files (.DBF files) which have been recovered from old installation. Now, I need to ...
0
votes
1answer
129 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 ...
1
vote
2answers
245 views

Is it possible to set stand-by database to active, do changes and then continue restore chain?

Basically, I'm using a custom log shipping method on a sql 2012, where the transaction files are manually copied to an offsite location. The files are then restored using something similar: RESTORE ...
0
votes
1answer
153 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 ...
3
votes
1answer
66 views

How can I verify that my SQL Server edition is Express? [closed]

I have a SQL Server (version 11.0.5058). I tried to restore a database from a bak file and I got an error saying: CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative ...
-1
votes
2answers
61 views

Database BackupSize has Changed after migration from SQL Server 2012 Exterprise to SQL Server 2012 Express [closed]

I would like to say that after migration of MS SQL server 2012 Enterprise to MS SQL Server 2012 Express. I have seen there is some subtle diffence in DB backupsize as well as in "LSN" of all ...
3
votes
2answers
72 views

How to merge MySQL backup files (*.sql)

We have several MySQL backup files of a database in *.SQL format and we want to restore the database by using these files. However, as the sql files contains "DROP TABLE" definitions, running one ...
1
vote
2answers
629 views

After Restore Log_reuse_wait_desc of Replication

I'm wondering if anybody has ran into this issue before and has any suggestions on what's causing it/how to fix it. We are restoring a database into lower Dev environments and after the restore the ...
0
votes
0answers
17 views

How to merge MySQL backup files (*.sql) [duplicate]

We have several MySQL backup files of a database in *.SQL format and we want to restore the database by using these files. However, as the sql files contains "DROP TABLE" definitions, running one ...
2
votes
5answers
9k views

SQL Server mirrored database is stuck in recovery mode

I have a database that is stuck in recovery mode for few days already. There are multiple threads about this, but the solutions there don't work for me. Here is what I tried already: RESTORE ...
1
vote
1answer
62 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 ...