Database restoring refers to the concept of restore a database from a backup or a copy.

learn more… | top users | synonyms

2
votes
1answer
6k views

Full and differential restore with two backup files - SQL Server 2008

We are trying to establish a maintenance plan with 2 separate backups. One full backup over the weekend and differential backups through the week. [the differential backup has a "_diff" appended to ...
2
votes
1answer
532 views

Correcting the imported latin1 data to be utf8

I restored my drupal site database from a backup but after i finished i discovered that the Imported data was symbols like this قوانين كرة because the backup was taken using latin1 charset ...
2
votes
1answer
763 views

BACKUP and RESTORE MySQL Database

I have very specific question. I have seen the instructions on how to backup and restore mysql database using SSH but they barely explain the process when backing up on one server and restoring on ...
2
votes
1answer
420 views

Error When Restoring Log

Here is the situation. I have restored a database to replace an existing version (need to get it back to yesterday at a certain time). So I do a RESTORE DATABASE ... WITH NORECOVERY, REPLACE, etc... ...
2
votes
2answers
44 views

Restore Error event id 17066 and 3624 while restoring diff backup

I am getting the following error while restoring the Diff back up after restoring the Full backup in Norecovery mode. I am unable use dbcc checkdb as the database in restoring db.Issues happens only ...
2
votes
2answers
44 views

Database recovery procedure

I recovered a database with last full backup, all differentials after the full, and then all log backups after the last differential. Can I trust the database is right or do I have to do it again the ...
2
votes
2answers
83 views

An easy way to select one db dump from multiple db MySQL dump

In an urgent situation another person made a backup of all the databases from my webserver to one *.sql file (MySQL dump). Now I have a ~700 Mb file with about 20 different databases. As I only need ...
2
votes
1answer
2k views

Error restoring SQL differential database files

Occasionally I'm having problems restoring DB differentials. I'm getting the error "the differential backup cannot be restored because the database has not been restored to correct earlier state." ...
1
vote
3answers
2k views

Restore database - maintenance plan task

I need to schedule a task that restores a database once a week from a backup. I have setup maintenance plans for backing up databases (Management > Maintenance Plans) but cannot find out how to make a ...
1
vote
3answers
139 views

Proper way to export database to other servers

I am using SSMS (I am a software developer, not a DBA) and in each application release I need to release the database with its tables (some with data some with scheme only). I tried doing 3 things ...
1
vote
1answer
256 views

Restoring a differential backup in SQL server 2005

I have created a full back up of my database by executing the line below in my application: Dim Query As String = "backup database Ari to disk='G:\Documents and Settings\i\Desktop\BKAR\" & ...
1
vote
5answers
5k views

How to restore database using old full backup and current log file

What is happened? My client has lost the hard disk. He has to restore database. He has the full backup of database 15 days old. He has ldf (log) file of this database. He has NOT mdf file (it was ...
1
vote
3answers
673 views

Is it possible to get the last restore date of a MySQL instance?

Is it possible to get the last restore date of a MySQL database? I am going to restore the database from a .sql dump file, but I don't know how to get from the database, the last time when a restore ...
1
vote
2answers
226 views

“Rewinding” a Postgresql database

I have heard that Postgresql uses an append-only format for it's databases, and if this is true I should be able to 'rewind' the database to a previous point in time by removing the commits that came ...
1
vote
2answers
4k views

SQL Server: Simple database restore with overwrite

What I'm trying to do is backup one of our production databases and restore them as our dev database (overwriting what's been there). That's how I back up: backup database [authfx] to disk = ...
1
vote
1answer
158 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 ...
1
vote
1answer
1k views

while restoring mysql database, views changed into tables

I have a full database dump and i restored it. But in my new restored server all the views are appeared as MyISAM tables. In early times dumps were restored perfectly. can anyone help me to trigger ...
1
vote
1answer
125 views

DB2 ROLLFORWARD ERROR when doing “TO A POINT IN TIME” option

I do restore command of backup image which was made 03.03.2015 at 19:20: db2 restore database maxdb71 from "/data/archiveBackup" taken at 20150303192002 without prompting; Then I try to do the ...
1
vote
1answer
580 views

Restoring a database, changing recovery model

I regularly make a backup of my production database, then restore the same onto a test database, so developers can always have recent data for testing. The production database uses full recovery ...
1
vote
1answer
102 views

Maintenance plan backup and reload the same database

I want in my maintenance plan every night to copy the production database to a backup, and reload the newly-created backup into a test database. By reading here: Restore database - maintenance plan ...
1
vote
2answers
340 views

Error While restoring DB2 db from AIX to AIX server?

I am required to migrate 1 database One AIX server to another AIX server. To achieve, I took backup from 1 machine and followed below steps 1st Command I tried is as following. db2 restore db ...
1
vote
1answer
482 views

How do I open a Progress .bup file?

I have a .bup file which is supposed to be a Progress database file. My question is, how can I open/restore it and look at the data?
1
vote
1answer
93 views

mysql server password change while restoring

I restored all database backup from another server's dumpfile to my machine. At the end my mysql server's password changed to that mysql server's password. Why it got overwritten? What i need to do to ...
1
vote
1answer
48 views

Fail to attach database : MSDTC Check status of transaction

I am attaching a database from a snapshot taken of the production database volumes. These databases will be anonymised and then restored to our DEV servers. Here is my attach statement: CREATE ...
1
vote
1answer
30 views

MySQL InnoDB restoration from hardware failure

One of my server went down due to old hardware failure on a old Dell server that's over 10 years old. I was able to recover the files and got it to a local machine. I want to restore a MySQL instance ...
1
vote
1answer
140 views

Unable to restore database

I am trying to restore several databases and I have no clue why some of them fail with the following error: Msg 3634, Level 16, State 1, Line 1 The operating system returned the error '1244(The ...
1
vote
1answer
414 views

Restore a WordPress database from .frm and .idb only

I had a WordPress website running a long while ago. I used WAMP server. Then, I uninstalled WAMP. Today I would like to work again on my website; all that remains of my database is this (I cannot find ...
1
vote
1answer
197 views

Using “Generate Scripts” with EMERGENCY/SINGLE USER mode

I am trying to create an INSERT script to salvage data from a single table in a corrupt database. I've succesfully put the database online and put it in EMERGENCY / SINGLE USER mode (following this ...
1
vote
1answer
158 views

Restoring full and differential backups from production to a report server

Running this SQL query: RESTORE DATABASE Demo FROM DISK = 'C:\DBBackup\Demo_FULL_Sunday.bak' WITH NORECOVERY RESTORE DATABASE Demo FROM DISK = 'C:\DBBackup\Demo_Diff_Monday.bak' ...
1
vote
1answer
56 views

restoring Postgres dump with tablespaces

I'm trying to restore a dump done with pg_dumpall > mybak.sql from a server that has 1 table in a different tablespace that the default one. On the target machine I have recreated the directory ...
1
vote
1answer
2k views

Solution to error NID-00135 in Oracle 10g, Solaris 10

We are trying to build a test version of a production database by restoring the production backup using RMAN and renaming the database to test. We've successfully restored and opened the database ...
1
vote
2answers
3k 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
1answer
59 views

How to properly restore database from file groups backups?

I have very (from my point of view) strange error while trying to restore SQL server DB from a series of filegroup backups. Here is my corrent config: I have DB with 2 files 2 filegroups and 1 log ...
1
vote
1answer
143 views

database not restoring from dump file

I'm running the following command to create a dump of all database on my production server: prodserver:/# pg_dumpall -U postgres -h 1.1.1.1 > prod.sql on my development box, I also take a ...
1
vote
1answer
2k 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 ...
1
vote
0answers
209 views

restore using mysqlbinlog failing

While doing restore from a MySQL binary log file, it is failing with the following error . mysqlbinlog mysql-bin.000036 | mysql -u root -p asdb ERROR 1032 (HY000) at line 48: Can't find record in ...
1
vote
0answers
60 views

Pg_restore table size differences

What would account for the difference in table sizes between one PostgreSQL database and another restored from its dump file? On an Ubuntu 12.04 host, I'm running PostgreSQL 9.1, and I dumped my ...
1
vote
0answers
54 views

Restoring a database to a point in time: Database I want not showing up in dropdown list

I want to restore to a point in time from a database that is already attached. When I try to do this using SMSS I cannot find the database I want in the dropdown list, but oddly it has a couple ...
1
vote
0answers
57 views

SQL Server Database Size much higher than the backup size after restore [duplicate]

Possible Duplicate: Why is a .bak so much smaller than the database it's a backup of? The database backup size is around 120 MB but when I run Restore FileListOnly, I see that the data ...
1
vote
1answer
22 views

MonetDB auto-backup mechanic problem

I'm trying to set up mechanism that will automatically create database backup. The idea is to create a script that will be executed by crontab. Seems easy but I'm struggling with the following ...
0
votes
3answers
843 views

SQL Server restore sequence from multiple full, diff and log backups

Suppose I have a lot of backups (may include full, differential and log backups) of a SQL Server database. I want to write a program that can generate a SQL script to take the database to its most ...
0
votes
1answer
119 views

How to use imdpd to import data file into different schema including index from different tablespace as well

The original data pump file is generated by the schema which living in two tablespaces(OLD_SCHEMA_DAT and OLD_SCHEMA_IDX), if import back to the original tablespace, everything is fine, but when I use ...
0
votes
2answers
1k views

Can I find out what version of MySQL from the data files?

I have a very odd situation going on here. I had a linux box running ubuntu 8.10 and MySQL server with a Wordpress installation on it hosting an internal blog for our company. The machine that this ...
0
votes
1answer
457 views

Drop and restore PostgresSQL database without losing settings

This seems like a simple, easy question, but I'm very new to PostgreSQL administration and I'm not sure of the best way to do things. I have a PostgreSQL (9.1) database that somehow got corrupted ...
0
votes
1answer
46 views

Restoring SQL Server 2000 database to SQL Server 2008

Is it necessary to restore system databases of SQL Server 2000 to SQL Server 2008, if I am restoring my other databases from 2000 to 2008?
0
votes
1answer
48 views

fn_dblog not showing up deleted table data

I unintentionally deleted 4 rows from a table. I tried to fetch back the deleted data using a stored procedure (got from internet). However, I was able to see my data in the result of stored ...
0
votes
1answer
39 views

SQL Server 2008 R2 - Moving nodes in mirrored environment

Was hoping that I would find this documented somewhere, but I've searched and searched. Finally asking the question myself: I have SQL Server 2008 R2 in a HA setup (primary/mirror/witness) I want to ...
0
votes
1answer
129 views

Backup/restore using OPENDATASOURCE OR OPENROWSET

Has anyone ever successfully taken a backup or restore to another server using OPENDATASOURCE/OPENROWSET? I am not able to use linked servers so I am exploring this idea.
0
votes
1answer
45 views

Oracle Recovery

Oracle server died. Built a new VM and mapped out the volumes to the SAN. Installed the same version of Oracle on the new server and applied the same patches. How can I "register" or "attached" the ...
0
votes
2answers
186 views

RMAN restore to lower disk space

I have 30.7GB backup file generated from RMAN. The original ./datafile is 950.28GB. According to previous DBA, there is a lot of free space in table space. Now, I have 300GB free disk space in hard ...