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)

0
votes
0answers
24 views

Unable to remove the database name

One of the databases is getting to suspect mode. Since I have backup, I restored the same database with different name and then take the SQL SERVER and remove the data and the log file of the ...
0
votes
1answer
20 views

SQL Server Msg 2812, level 16 state 62 line 30

i want to make automatic backup and restore my database on SQL Server 2012. i have made automatic backup with script in my windows server. now, i want to make auto restore with script, i have found ...
0
votes
2answers
44 views

Can I restore only the LOG of a database?

We have a 1.5TB database. I could create some replication strategies do replicate the database to another server in a fixed time.But the developers don't know when they will need to replicate this ...
0
votes
2answers
485 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 ...
0
votes
3answers
54 views

Problem generating restore scripts for multiple ola backups

I am using Ola for maintenance solution. I have 300 databases I want restore those databases using scripts rather than going through one by one. I prepare the following script to generate restore ...
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
2answers
40 views

A tail-log backup of the source database will be taken ? Why I am seeing this warning

I took a backup of a database from 1st server (which runs SQL Server 2014). When I try to restore the backup to a 2nd server (which runs SQL Server 2012) I get this warning message: Warning ...
1
vote
2answers
743 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 ...
3
votes
2answers
58 views

Copy one database to another (existing) database on the same server

I have a "Live" database and a "Development" database and occasionally, I want to replace the entire contents of the development database with the live data. Ideally, without taking the live database ...
16
votes
4answers
80k views

media family on device is incorrectly formed. SQL Server cannot process this media family

I am trying to restore a .BAK in SQL server but get the following error: Msg 3241, Level 16, State 7, Line 1 The media family on device 'c:\glyn\JA.bak' is incorrectly formed. SQL Server cannot ...
3
votes
3answers
1k 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 ...
1
vote
2answers
169 views

ALTER DATABASE script preventing restore of MySQL database in another server

While backing up the database with mysqldump --routines options, I see ALTER DATABASE in the middle of the output dump, near the routines. /*!50003 DROP FUNCTION IF EXISTS `f_my_function` */; ALTER ...
3
votes
0answers
43 views

how do i create an automated sql restore script for multiple backups?

Hello to all SQL gurus out there. I basically have 6 daily sql backups (.bak) that need a restore everyday. I want to automate this process by having the sql agent run the script daily. I have the ...
15
votes
1answer
541 views

Restore Database using GUI - Wrong file to restore

I'm just messing around with the SSMS 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: ...
1
vote
1answer
716 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 ...
5
votes
1answer
599 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
30 views

How to, efficiently, search through many sql dump files of really big size

We have an ads website that the uncompressed(plain .sql file) size of the database is about 30gb. Until now when a user was deleting his classified the classified was completely getting wiped out from ...
0
votes
2answers
165 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 ...
2
votes
1answer
13 views

Backup a hot standby database (streaming replication) whilst it is in recovery

Synchronous Streaming Replicating is set up between a master and a hot standby database. It seems like a good idea to perform daily backups on the standby database to avoid any performance issues ...
2
votes
1answer
987 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 ...
0
votes
1answer
110 views

Database Restore Not Working

I am trying to restore an empty MS SQL database 'Rental' to a new updated version of it. The backup of the database (named Rental_2) was taken from the 2012 version of SQL Server and I am trying to ...
0
votes
0answers
28 views

Regarding Backup and Restore Strategy

Everyone I have some queries regarding backup and restore strategies. I want to take Backup and Restore of Large Database approx. 60 to 70 GB and it is critical database in SQL Server. Backup ...
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 ...
1
vote
1answer
17 views

mysql restore specific date data from a dump file

I have mysql [version 5.6] database dump file. I want to restore only one day data from that dump file. Anyone has any clue ?
1
vote
1answer
4k 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 ...
0
votes
1answer
15 views

Having two data folder in my postgresql setup- Postgresql

I am using centos 6 and installed Postgresql_9.4 using the following commands yum install postgresql postgresql-contrib postgresql-client pgadmin3 yum install postgresql-server After that i ...
1
vote
1answer
123 views

Copy Data between two databases

I have the following situation. An application writes logs into SQL Server 2012 Standard edition database. The incoming data are too big to leave in the operational DB because the application also ...
0
votes
1answer
14 views

Backup/Restore single database with MySQL Enterprise backup

From what I have found online is it is possible to backup/restore an entire mysql instance with MEB and also a single .ibd file (to my understanding is a single table). What I am trying to do is ...
0
votes
1answer
34 views

Restore a database with compression on a non-enterprise edition SQL Server

Is it possible to restore a compressed an object from backup without the Enterprise Edition? I'm getting the following error after a RESTORE DATABASE operation. Msg 3013, Level 16, State 1, Line 2 ...
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 ...
0
votes
1answer
27 views

Dumping and restoring tables in PostgreSQL - ERROR: extra data after last expected column

I am trying to dump and restore multiple tables from a database on one server, to a different database on another server. Both are running Postgres 9.4 on linux. The command for the backup was: $ ...
0
votes
0answers
16 views

Backup and restore specific filegroups [duplicate]

I've seen this Stack Overflow question: Backup and restore SQL Server database filegroup. However, it didn't do what I needed. I have a database with three filegroups: primary, reporting, and ...
1
vote
2answers
190 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
2answers
241 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
151 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
votes
1answer
21 views

Restore DB script

I wrote this script for restore DB: declare @dir nvarchar(70), @year nvarchar(4), @month nvarchar(2), @day nvarchar(2) set @year = datepart(year,getdate()) set @month = datepart(month,getdate()) ...
27
votes
4answers
7k views

Is it possible to quickly create/restore database snapshots with PostgreSQL?

First of all, I'm a developer, not a DBA or sysadmin; please be gentle :) I'm working on an application workflow where a single user action will trigger complex changes in the database - creating ...
3
votes
1answer
141 views

How to directly query other user tables

I am trying to learn Oracle database and I am having difficulties on importing a backup file with impdp command. I googled deeply but couldn't find answers to my problems. What have I done until now ...
3
votes
1answer
2k 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 ...
4
votes
2answers
371 views

Help undoing an accidental restore on SQL Server 2014

Yesterday I made a serious mistake¹: Restoring the wrong database. Background (you may skip this section): I right-clicked the Test database and proceeded to the "Restore Database" section as ...
1
vote
0answers
40 views

How to backup SSIS packages and CUBE Projects from Visual Studio 2013.5?

I'm using VisualStudio 2013.5 to develop SSIS, SSDT and SSAS Cubes (multidimensional and tabular model). I would like to ask you is there a possible to backup SSIS packages and SSAS cubes from ...
5
votes
4answers
5k views

Extracting a field from RESTORE HEADERONLY

I'm trying to use 'RESTORE HEADERONLY' to get the date when the backup I'm about to restore was made. The command: RESTORE HEADERONLY FROM DISK = '<path to .bak file>' works fine in Query ...
4
votes
2answers
16k views

Table is marked as crashed and should be repaired

I have MySQL and Nagios installed Linux PC (Centos5.5) I have wrote some script to fetch the data from Nagios to Mysql DB (Exactly fetch data in Table) The data fetching working properly (confirmed ...
0
votes
1answer
49 views

Restore databases from prod to test server with data over X days

We've got a list from app owners to restore say 20 databases from a total of 100 available production server databases onto a test server on weekly basis. Moreover, they require it in a way that ...
1
vote
1answer
30 views

Large `mongodump` followed by `mongorestore`

I have a fairly large (~240GB) Mongo database that I need to transfer across a sluggish network and onto a new server. Traditionally for these situations, I've found that a mongodump followed by a ...
1
vote
1answer
72 views

Why do I need to reset user mapping always after restoring my DB

I have created a user using SQL Server 2014 management studio, I have mapped user to a couple of tables as db_owner. But after restoring my databases the mapping again cleared for the user and I need ...
1
vote
0answers
823 views

System.Data.SqlClient.SqlException (0x80131904): SQL Server detected a logical consistency-based I/O error: incorrect checksum

I am migrating client's database to my hosted environment, the client runs SQL Server 2008 R2, and we run SQL Server 2014. I am stuck on restoring one log file, which left below error message when I ...
1
vote
2answers
275 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 ...
1
vote
0answers
56 views

Will I have to restore controlfile in RMAN level 1 backupset before recover database?

For example, I have a level 0 and level 1 RMAN backupset files like inr00_0413_* inr01_0413_1_* Is it necessary to do this when recover from RMAN level 1 backup: restore controlfile from ...
0
votes
1answer
23 views

Point in time restore fails - backup file from before the restore point not available (why does this matter)

I have tried to do a point-in-time restore of a database through the management studio gui, the point-in-time being yesterday morning (2016-04-12). This fails with the error "...cannot open ...